I have a lookup field in table A that is supposed to retrieve values from a number field on table B.
Some of the values on table B are 0. Currently the lookup field on table A is showing blanks for all 0 values.
0 is different than blank. For my purposes, blank means missing information and 0 means 0.
How do I fix this? I have a feeling that if I changed the table to a text field it would help, but I have some integrations with accounting software and would rather not do that if I don't have to as it may muddy some other things.
Lookup field showing "0" as blank
+8
+29Airtable sometimes considers blank and zero to be equivalent.
How is your lookup field configured? Can you post screen shots of your lookup configuration and of your data (including the related linked record field)?
If you are setting a condition for where the field "is not empty", it should include zero, but not blank.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.