This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
We are an outdoor lighting company that installs lighting as well as sells product. We have a robust network of apps that speak to each other. We use airtable for our inventory and project management. We would like someone to help in building forms t...
We are looking for developers to help automate our Airtable bases with Hubspot, Zapier and other programs. Please message me with details/rates/abilities etc.
Hey guys!
I’m looking to add an if formula to the formula below. What I need is that if the “fixture model #”, the “bulb model #” or the “miscellaneous” fields are empty, the output of the concatenate funtion is “N/A”
CONCATENATE({Name (from Orders)}...
So I guess I have one more question. In the formula below, I should change to the & instead of using concatenate? Also, how would I get the “-” or spaces to not show if there was no value in the field?
CONCATENATE(Manufacturer, " - “, {Product Type},...
So I guess clarity goes a long way here, lol. These are great. but what I should have said is that I still need the concatenate output of the items that ARE there. Just in the places that there is no value, I would like to insert “N/A” instead.
