Aug 16, 2021 07:44 AM
Why can I only “go to record” by the 1st column? I need to be able to go to a record by entering my customers name which I need to leave in the 3rd column. Thank you!
Aug 16, 2021 11:37 AM
Hi @Kim_Brauer and welcome to the community!
It always uses the primary field. Have you considered using the CONCATENATE() function to include your customers name in that first field?
Aug 16, 2021 03:56 PM
At the risk of sounding naive… what is the CONCATENATE() function?
Aug 17, 2021 12:17 AM
This function joins together arguments and/or field values from any number of fields into a single text value, and follows this format:
CONCATENATE(Value 1, Value 2, etc...)
For example, you can join together the values of two fields by using this formula:CONCATENATE({Field A}, " - ", {Field B})