Hello all!
First time posting here so I apologize in advance for any etiquette breach.
I have a simple Base project that I’d like some advice on how to approach providing a form for users.
The data model is relatively simple with a survey table, species table, and a joins table to hold all of the species identified during a survey:
The joins table has FK to the survey id and species id.
I’d like to create a form in base where the user can fill out data for a given survey, and then add multiple entries to correspond to each species they found. (The joins table will also have a count column, not shown in the above diagram).
Ideally the form would have inputs for a particular survey, but then I’d like to allow them to add any number of species (and a count) as well.
Any advice on how to proceed with something like this? TIA!