I have 2 tables, Issued Vouchers and Claiming. Under Issued Vouchers I have the columns Reference Number, Name, and Amount. Under the Claiming I have the columns Reference Number, Name, Amount, and Status.
What I was looking for is to have Suggested Values for the Reference Number Field under the Claiming table. Then I use this Reference number as a Ref column to auto populate the other fields like Name and Amount. When I try to put the “Issued Vouchers[Reference Number]” so that when users type a reference number, suggestions will be made to minimize the error a prompt from Appsheet appears which says
“Column Name ‘Reference Number’ in Schema ‘Claiming_Schema’ of Column Type ‘Ref’ has invalid ‘Suggested Values’ of ‘=Issued Vouchers[Reference Number]’. The type of the Suggested Values does not match the column type.”