I have a task submission form for co-workers to use. I have a single-select field for my own use that lists where I am in the task (submitted, assigned, stalled, etc). I am using a calendar and kanban view to show all submissions from the form. But I do not have that field showing on my submission form as it’s just for me. However, I want that field to auto-select Submitted from that single select field. That way, in my views, it comes up because I have it filtered to show only the submitted selection. So my question - when a form is submitted, and creates a new record, is there a way for that one single select field to automatically select submitted?
Page 1 / 1
Hi @Rachel_Romines - a single select field doesn’t have a default option so you can’t do this directly. However, in your form you can set the field so that it only shows one (in this case) option to the form user:
By also making this a required field, you are forcing your users to submit with the one option you want to see. Not a perfect solution, but hopefully this will work for you.
JB
You can achieve this by pre-filling the value in the form. Try something like https://airtable.com/shrT3xFytWdfbBjAu?prefill_SingleSelect=DONE
SingleSelect is what the field name is.
DONE is what the pre-filled value is
shrT3xFytWdfbBjAu needs to be your form’s ID.
Check out https://support.airtable.com/hc/en-us/articles/234982508-Prefilling-a-form
You can achieve this by pre-filling the value in the form. Try something like https://airtable.com/shrT3xFytWdfbBjAu?prefill_SingleSelect=DONE
SingleSelect is what the field name is.
DONE is what the pre-filled value is
shrT3xFytWdfbBjAu needs to be your form’s ID.
Check out https://support.airtable.com/hc/en-us/articles/234982508-Prefilling-a-form
This is exactly what I needed and works perfectly! Thank you very much!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.