Hi there.
If the role and description is submitted in a single text field, you could use that string and create a new dropdown option out of it using a script. I would assume though that you would need some sort of data validation, which I think is not possible in Airtable as of now (otherwise people could submit whatever they want and a script would turn that into a drop down automatically).
Best,
Rupert
Hi @J9_L,
I think Rupert_Hoffschmidt has a good idea using a script from a single line text field.
@Rupert_Hoffschmidt, could a single select field be used to gather the data and then a formula field convert it to text, which the script would read? Just a thought. That might take care of the data validation.
Thanks,
Chris
Hi @J9_L,
I think Rupert_Hoffschmidt has a good idea using a script from a single line text field.
@Rupert_Hoffschmidt, could a single select field be used to gather the data and then a formula field convert it to text, which the script would read? Just a thought. That might take care of the data validation.
Thanks,
Chris
Hi Chris, I guess you mean that the options for the user submitting the info is pre-defined. As far as I understood it, the idea was that any information can be added in the form (which would require ideally some sort of user input validation I guess). Cheers, Rupert
Hi Chris, I guess you mean that the options for the user submitting the info is pre-defined. As far as I understood it, the idea was that any information can be added in the form (which would require ideally some sort of user input validation I guess). Cheers, Rupert
Ah yes! Great point. I guess I envisioned a categorical field that was pre-defined, like job type. The person’s name would have to be single line text and I imagine the description would be long text.
Thanks,
Chris
Hi Chris, I guess you mean that the options for the user submitting the info is pre-defined. As far as I understood it, the idea was that any information can be added in the form (which would require ideally some sort of user input validation I guess). Cheers, Rupert
Hi @Rupert_Hoffschmidt @Williams_Innovations thank you both for putting even more than a minute of thought to this. You’re awesome.
To give more clarity, the items from the form submitted would be only three fields:
- Team name (open text field)
- Role name (open text field)
- Role Description (open text field)
These three fields would then need to translate into a single option (team, role, description) in a drop down in a different form in a different sheet in the base that someone can fill in. So they would get a question that asks; “what role are you interested in?” → they scroll the drop down and select it → that then matches the record with that role.
Any ideas how to make that feasible or suggested changes to hack together a solution? Thanks again!
Hi @Rupert_Hoffschmidt @Williams_Innovations thank you both for putting even more than a minute of thought to this. You’re awesome.
To give more clarity, the items from the form submitted would be only three fields:
- Team name (open text field)
- Role name (open text field)
- Role Description (open text field)
These three fields would then need to translate into a single option (team, role, description) in a drop down in a different form in a different sheet in the base that someone can fill in. So they would get a question that asks; “what role are you interested in?” → they scroll the drop down and select it → that then matches the record with that role.
Any ideas how to make that feasible or suggested changes to hack together a solution? Thanks again!
From what I can see the only change is that now we have three text fields that get merged into one string to be then created as an option for a single select (dropdown).
I think you should definitely insert a caption in the form that says like (“only one word”) or something like this. Maybe on the backend you could then use a formula to only take the first word in that field. Also how long will the description be? I think the issue I’m having here is that single select field options are usually quite short.