Validity/Conditional Drop Down Lists in Base
Posted: Wed Jun 14, 2017 5:06 pm
I have been researching this, and have seen that what I want is possible in calc, but I haven't come across any topics for this in base.
I'm creating an artifact catalog for archaeology in anticipation of some large upcoming projects.
What I would like is based on my first field of "Artifact Type" (historic, prehistoric), to then have other fields drop down list options change accordingly.
For instance, if 'historic' is chosen in "Artifact Type", in the next "Subgroup" field, I would like the options to be kitchen, architecture, transportation, furniture, etc.
If 'prehistoric' is chosen in "Artifact Type", I would like the "Subgroup" dropdown options to be lithic, ceramic, fuel, etc.
Thank you in advance for any help. Please let me know as well if this is only possible in calc. I was hoping to use base for the query abilities for analysis, but I'll switch to calc if necessary.
I'm creating an artifact catalog for archaeology in anticipation of some large upcoming projects.
What I would like is based on my first field of "Artifact Type" (historic, prehistoric), to then have other fields drop down list options change accordingly.
For instance, if 'historic' is chosen in "Artifact Type", in the next "Subgroup" field, I would like the options to be kitchen, architecture, transportation, furniture, etc.
If 'prehistoric' is chosen in "Artifact Type", I would like the "Subgroup" dropdown options to be lithic, ceramic, fuel, etc.
Thank you in advance for any help. Please let me know as well if this is only possible in calc. I was hoping to use base for the query abilities for analysis, but I'll switch to calc if necessary.