Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Default number on linked base NOT working

Topic Labels: Automations
3573 7
cancel
Showing results for 
Search instead for 
Did you mean: 
Some_Voices
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all

I’d like to add a default number of ‘1’ in ten columns on a linked base - so that whenever a new record comes through from the ‘master’ base, it automically fills those columns with the number ‘1’.

For some reason the default number option doesn’t work, and I can’t find any scripts that will work to be run as an automation to do this either.

It feels like a simple request so hoping there’s a simple solution and I’m just being stupid…

Thanks in advance,
Curtis

7 Replies 7
augmented
10 - Mercury
10 - Mercury

I just tested the default value option in the number field. Works fine. You might want to bring in Airtable support because that should work for you.

How does a new record “come through” from the ‘master’ base? I’m unclear on what you mean. I assume you mean table. If you go into your linked table, where you have your number fields set to default to 1, and you add a new row then the default values don’t appear?

Thanks @augmented - and apologies I’ve only just seen this.

How does a new record “come through” from the ‘master’ base? I’m unclear on what you mean. I assume you mean table.
Correct - I mean table :slightly_smiling_face:
The master table has information (customer details) come in from Shopify (via Zapier), and then all data is sync’d to a different base.

If you go into your linked table, where you have your number fields set to default to 1, and you add a new row then the default values don’t appear?
Exactly that… The default field is an additional column in this base (not from sync), so I wonder if because the data is sync’d from another base, that that’s the reason it doesn’t auto-fill?

I’m experiencing the same. Have send an email to support.

Airtable support got back to me on this. Apparently, this is a bug that they will try to resolve.

_ 40x40 Maelyn (Airtable Support)

Aug 11, 2021, 12:11 PM MDT

Hey Jan,

Thank you so much for your patience.

The engineering team is currently working on a fix for this behavior. Unfortunately, at this time, they do not have a timeline available on when this will be resolved.

I experimented with this a bit and it looks like default numbers added to the original (source) base will be carried over to the sync if you need a workaround in the meantime.

Again, so sorry for the trouble this causes, please let me know if you have any further questions!

Update: this issue is still on the roadmap, but without any view on a date.

Green_Fox_Acade
4 - Data Explorer
4 - Data Explorer

This is still an issue. When I add a new Number column to a linked table there is no "default" option (only "Format")

daverad
6 - Interface Innovator
6 - Interface Innovator

Here to "plus 1" this issue. I'm still experiencing it.