[Solved] Form fields where "data field" dynamically chosen
Posted: Mon Mar 14, 2022 7:01 pm
Hi, I'm new with Base. Hope I explain this well...
I created a table to collect data from Scientific publications with the following fields:
* Author
* Date
* Latitude
* Longitude
* Method
Then the table has about 200 extra fields. They are species names with a default value of zero. For each record, I need to complete all the fields listed above, but only a few species fields will need to be edited. As you can imagine, it's not practical to have so many fields in a form. So I was wondering whether is possible to set up a bunch of fields in the form, let say 10, where I can dynamically select the data field, and then edit the value. For example, in given record, only Canis familiaris and Felis silvestris were found, in abundances of 5 and 7. I would like then to select these two species in the "open fields" and set the values to 5 and 7. The rest of 198 species will be zero by default. The species selection process could be done with a dropdown list, predictive text typing, or other smarter method!
Well, so far I managed to create a form with Author, Date, Latitude, Longitude and Method fields. But no idea on how to set up these "dynamic open fields".
Is that even possible? If so, how I can do it?
Thanks in advance.
I created a table to collect data from Scientific publications with the following fields:
* Author
* Date
* Latitude
* Longitude
* Method
Then the table has about 200 extra fields. They are species names with a default value of zero. For each record, I need to complete all the fields listed above, but only a few species fields will need to be edited. As you can imagine, it's not practical to have so many fields in a form. So I was wondering whether is possible to set up a bunch of fields in the form, let say 10, where I can dynamically select the data field, and then edit the value. For example, in given record, only Canis familiaris and Felis silvestris were found, in abundances of 5 and 7. I would like then to select these two species in the "open fields" and set the values to 5 and 7. The rest of 198 species will be zero by default. The species selection process could be done with a dropdown list, predictive text typing, or other smarter method!
Well, so far I managed to create a form with Author, Date, Latitude, Longitude and Method fields. But no idea on how to set up these "dynamic open fields".

Is that even possible? If so, how I can do it?
Thanks in advance.