Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 17, 2023 08:33 PM
Hello! I'm creating an Airtable form, and I want to enable a default text to fill in a field if the field is left empty by whoever is filling the form. Example if name is not filled in, then it will default to anonymous instead of being blank. How do I go about doing this? I tried to use the blank formula myself but I failed :')
Thank you so much!
Mar 18, 2023 12:45 AM
If you're alright with the person filling out the form seeing "Anonymous" there, then you can use prefills
If not, you could make an automation that would trigger on if the Name field is not filled in and use an "Update record" action to put the text "Anonymous" in there?
Mar 18, 2023 06:56 AM
A formula field cannot change the value of a different field by itself. A formula in Airtable can only set the value of its own field.
For example, you could have a formula
IF( {Name}, {Name}, "anonymous")
However, this formula will not change the original {Name} field. On the other hand, if you only want to see the results, this formula may do what you need and save you automation runs.
Mar 18, 2023 07:02 PM
Ohh omg ok! I will try the prefills! Thank you so much
Mar 18, 2023 07:03 PM
Ahh no wonder it wasn't working :') Thanks so much for letting me know!!