Selecting the related row from another table in a form

Ask for Help
1

Let’s say I have two tables:

1- Equipment
2- Lease Agreements

I’ll create a form for the users to create new agreements. The user will select basic stuff like date, duration, price etc and obviously the equipment. There should be drop down menu to select from the first table. But I cant do that!

(Another nice to have option would be to go into details of a single equipment, there would be a button that say “add new lease agreement for this equipment”.. and you would click and the system understands you are creating a lease agreement for this equipment)

Previosuly I used Airtable for some projects and “links” (relations in Glide) between tables worked differently. Therefore I might be missing something very easy!!

2

This is all very possible. Where are you struggling?

Why can’t you do that? A choice component that writes the equipment ID to the lease table will allow you to create a relation and lookup in the lease table to retrieve any values you want from the equipment table based on that equipment ID.

Also possible. A form can pass any values you want from a parent row through that. Either add the appropriate Value components to a regular form, or if you are using a form container, you can set those values in the right hand panel of the form container configuration.

1 Like