Help

Hiding a field with a defaulted value?

Topic Labels: Data Formulas Workflow Design
Solved
Jump to Solution
1141 4
cancel
Showing results for 
Search instead for 
Did you mean: 
krtphr
6 - Interface Innovator
6 - Interface Innovator

Hello all, I created a form, and one of the field values needs to be "1" as the default value. However, I need that hidden so that when someone goes to submit data, they don't have to fill that field in as "1".

Now this is what I have:

krtphr_0-1703260261536.png

I tried hiding this field from the form options listed, but when I go to submit this form - it doesn't display a "1" in the field value on the table view. 

I also tried this method on the table view:

krtphr_1-1703260348246.png

When I go to create a record on the table view - it does default the value to "1", but on form submission - it does not. Any idea what it is that I'm doing wrong?

Thanks. 

1 Solution

Accepted Solutions
krtphr
6 - Interface Innovator
6 - Interface Innovator

I actually did something simple. 

Created a formula with nested IF statements to input the correct value, based on another field's entry. I also removed the input box on the form. 

Thanks all!

See Solution in Thread

4 Replies 4
ScottWorld
18 - Pluto
18 - Pluto

Unfortunately, default values in Airtable aren’t really what you would expect. They only work under a few unique situations. The only bulletproof way to get a true default value in Airtable (that works under all circumstances) is to create an automation that will set the values that you want.

If this is a form view (and not an interface form) you could try using a hidden prefill and send people the url with the hidden prefill. You can use the Prefilled Forms extension to build a formula for the url, or just build the prefill yourself since it doesn't involve existing field values. People will still be able to remove the prefill from the url, but it might be close enough for your use case.

Sho
11 - Venus
11 - Venus

Prefilling and hiding is also possible in the interface form.

The usage is exactly the same.
Prefilling a form via encoded URL | Airtable Support

krtphr
6 - Interface Innovator
6 - Interface Innovator

I actually did something simple. 

Created a formula with nested IF statements to input the correct value, based on another field's entry. I also removed the input box on the form. 

Thanks all!