LinkedIn
Twitter
Hi everyone! Wasn't sure how to best write a subject but here goes.
I have a form view that adds a new row to a Projects table.
The "Please choose the customer name." column is a Ref to a Customers table.
The "Please choose the customer site." column is a Ref to a Customer Sites table.
Each row in the Customer Sites table would be linked back to row in the Customer table via key column.
If I don't have the customer site option I need in the "Please choose the customer site." column, then I can add a new Customer Sites table row with the New button above.
When I do this, Appsheet doesn't know which Customer row to relate to, so it's doesn't create the key connection.
What I need to do in this case is pull the key from the referenced customers table from the "Please choose the customer name." column.
How would I pull this value from the form view to create the connection?
Thank you in advance!
