Hi Alkio. I’m stuck with the LOOKUP expression and tearing my hair out because its critical to everything else I need to do.
Two Tables -
“Client_Details” with FIN, Client_Name and other columns (containing client particulars) The search table called “Entitlement" with FIN, Name columns and other additional columns
the Entitlement field FIN is TEXT and Scannable
In the Name Column Definition of the Entitlement table I used the LOOKUP formula. LOOKUP([FIN], “Client_Details”, “FIN”, "Client_Name”) FIN is a key in the Client_Details Table but not in the Entitlement table
The current result is Name field in the form linked to the Entitlement table always displays the first row Client Name in the Client_Details Table. Is my use of the lookup expression wrong? The formula I used comes from appsheet.com - The no-code app maker for Google Sheets, Excel, and more. Create mobile iPhone and Android apps for your business. Start for free and build powerful apps. - Lookup Function - How to use the LOOKUP function I also tired LOOKUP([_THISROW].[FIN], “Client_Details”, “FIN”, "Client_Name”) the result was the Name field does not show up at all in the form. Both formulas pass the verification test. and produces this result.
One randomly chosen value from this list ( …The list of values of column ‘Client_name’ …from rows of table ‘Client_Details’ …where this condition is true: ((The value of column ‘FIN’) is equal to (The value of column ‘FIN’)))
Reading through past posting in the community, someone said that Any(Select…) was the way to go and Lookup just returns the same value so it does not work. Being able to scan or type in a code and retrieve a client’s details is essential to everything I need to do. I have tired Dereference. It works but it uses a pull down menu and we have just too many clients to use this method. Thanks very much for your help.
The no-code app maker for Google Sheets, Excel, and more. Create mobile iPhone and Android apps for your business. Start for free and build powerful apps. appsheet.com