So recently i have tasked to continue on an already deployed App, adding a approval layer but i want the approval form to reflect the Serial No from the main table which to no avail. The main table have a column named [PR No] ← Key & Label, Approval table has a ref column [Ref ID]… the initial value…

Rather than LINKTOROW([PR No], “Approval Form”), try LINKTOFORM(“Approval Form”, “Ref ID”, [PR No]).

Form is not autofilling based on Ref key

whlim November 19, 2024, 11:56pm 21

Hi steve, the expression works wonderfully. Cheers!

Topic		Replies	Views
Initial value for ref column AppSheet Q&A ux , databases , expressions	3	21	May 3, 2020
Initiale value in the same form AppSheet Q&A admin	4	14	February 4, 2022
Hello, I have problems with the initial value... AppSheet Q&A expressions	6	23	February 19, 2024