Create record bounded to records in other tab

Ask for Help
1

Hi all, the question is very simple, Im pretty sure this has already been discussed but I cannot find it when searching for an answer.
I have a Properties tab with a column name Property_Name
I have a Customers tab with a column name Customer_Id

I want to create an entry to a tab called Contracts which has columns for Property_Name, Customer_ID (referece keys to the Properties and Customer tabs) and a bunch of other fields related to the contract, like start & end date, price, etc…
I need to bound the values to choose from those exisiting in Properties and Customers tabs respectively.
In other words, I can only create Contract records with existing Properties and Customers…

Thank you all in advance!!

2

In your Add screen or Form Button for the Contracts tab, you can add Choice components which you can fill with values from the Properties and Customer sheets.

https://docs.glideapps.com/all/reference/components/pickers/choice

3

Thanks!! sorry for such basic question:)

1 Like