Entering Child Data

Ask for Help
1

Hi there. I’m creating an app for tracking trips and expenses. A trip can involve one or more customers. It can also include multiple expense line items.

So, the structure looks like:

Trip 1
Customers
Customer Code AAAA
Customer Code BBBB
Customer Code CCCC

Expenses
Expense Entry 1
Expense Entry 2
Expense Entry 3

Once I have created a Trip 1 entry, I’d like to (from the Trip 1 detail screen) have a button to Add a Customer to the Trip. Customers are children to Trip entries. So, adding a Customer Code to a Trip actually involves two fields: Trip # and Customer Code.

Is there a way to make the new Customer Code inherit the Trip # when using the Add a Customer to the Trip button? In other words, I don’t want to make users re-enter the Trip # to this entry.

The same strategy would be applied to the Expense Entries (under a Trip #).

Thanks!

2

Yes, if you add a form button within the trip details for example, the form will have access to all of the values from the trip details (as Column Value components) and you can submit them to a different sheet. Take a look at the Multi-Level Select example in https://concepts.glideapp.io/.

3

Thanks! I’ll check that out and get back to you.

1 Like