can we show two table fields in one variable?

[Hafila Hatta]

hi, i have a custom table whereby theres column:

column A: building code

column B: building name

in the catalog item, is there anyway i can display both in one variable? tried ref_ac_columns but its not working

[kaushal_snow]

@Hafila Hatta ,

can you share what you have used while trying ref_ac_columns ?

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.

[kaushal_snow]

@Hafila Hatta ,

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=building_code;building_name,ref_ac_columns_search=true

however.......once the user selects the record, only the table single display value is shown in the field........ because snow reference fields can only display one display value after selection .......you cannot have a two field display in that single reference variable by default.......

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.

[Ankur Bawiskar]

@Hafila Hatta 

if you use reference or list collector you can use ref_ac_columns so that when user types they see both the columns, but after selecting the record they will only see the value of field which is marked as Display=true

Instead if you use Lookup Select Box variable and point to that table you can show both columns

Something like this -> specify the columns in Lookup label fields as comma separated

After Selecting the record you will see both the columns

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@Hafila Hatta 

if you want to go with reference or list collector variable

you need to give the ref_ac_columns attributes for that and give the additional fields

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=category;serial_number,ref_ac_columns_search=true,ref_ac_order_by=name

Variable attributes sections

Output: I have added category and serial_number as extra fields to be shown along with name

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏