Solved: Form capture filter view - Page 2

Japie · 10-16-2022 11:42 PM

I am new to this and need some advice. I want to collect harvest weight data and designed a table on AppSheet. When I capture the App data I select from a list the Produce - Variant - Farm Name - Block number and then capture the harvest weight (kg). After saving the data I want to capture the next Harvest weight (kg) without having to select again Produce - Variant - Farm Name - Block number. I want to go right back to the Harvest weight (kg) to capture the next weight for the same

Suvrutt_Gurjar

It sounds that for the unique combination Produce - Variant - Farm Name - Block number you wish to capture the multiple Harvest weight (kg)

So you could look at creating a parent child relationship between block number and weights and you could have "IsPartof" enabled in this parent child relationship.

References between tables - AppSheet Help

Another option to evaluate is LINKTOFORM() action with form save event and auto reopen the form.

LINKTOFORM() - AppSheet Help

Exact implementation will depend on your data schema.

View solution in original post