Airtable Number field missing from INPUT bundle — ifempty+switch formula not working

Questions
, ,
1

:bullseye: What is your goal?

Write a number value to an Airtable Number field (תדירות/Frequency in days) based on a singleSelect field (קטגוריה/Category) value using ifempty+switch in the mapper.

:thinking: What is the problem & what have you tried?

The Number field does not appear in the INPUT bundle of the “Airtable Update a Record” module at all — it is completely missing from the Record Collection. So Airtable never gets updated.

Formula used in the mapper field:
{{ifempty(95.תדירות (ימים); switch(95.קטגוריה; “A”; 14; “B”; 7; “C”; 10; 7))}}

  • Module 95 = Airtable Get a Record
  • OUTPUT of module 95 confirms: קטגוריה = A (plain string)
  • The Number field תדירות (ימים) is completely empty in Airtable before the run
  • Smart links = false, Use Column ID = false

The INPUT bundle of the Update Record module shows Date, Status, Log, Publication count — but תדירות (ימים) is simply NOT there.

What I have tried:

  • Added parseNumber() wrapper — same result
  • Enabled Smart links = Yes — same result
  • Confirmed singleSelect returns plain string “A” not an object

Why is Make dropping the field from the Collection? Is ifempty with a null Number field causing the issue? What is the correct IML formula?

4

Hey there,

Sorry but can you share screenshots of the input and the formula instead?

5

image
image1636×870 154 KB

6

And the input? Is it A or “A”?

7

The output of module 95 shows the category value as “A” (with quotes). So in the switch formula I’m using “A” to match it. But the תדירות (ימים) Number field is still completely missing from the INPUT bundle of the Update Record module — not sent to Airtable at all.

8

image
image1684×872 155 KB

image
image1757×858 195 KB

9

As you can see in the INPUT bundle — the Record Collection contains Date, Status, Publication count and Log — but תדירות (ימים) is completely absent, even though the formula is set in the mapper.

10

Yeah its A and not “A”. Remove the quotation marks from the formula and it should pick it up.

11

Hi Stoyan,

That was exactly it! Removing the quotation marks from A, B, C in the switch formula solved the problem. The Number field is now correctly written to Airtable.

Thank you so much for the quick and precise answer!

David