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.
Hi all, I’m trying to create an automation that will update a linked record field (which sometimes starts empty, sometimes starts with records already in it) based on whether a lookup field is not empty.
The original data I am using is sensitive so I...
I frequently use the formula IF((FIND)) formula to create indicator columns with 1s and 0s or emojis.
In my latest project, however, it has not been working out as I want:
The above is a screenshot of a Grid View of form results.
The field “BACKEND_...
Hello,
I am trying to create a field that concatenates two rollup fields that have the array(unique) formula in each of them. But the concatenated result eliminates the comma.
You can see in the 10th row, the comma between “Refugee Support” and “Wat...
Hello,
I’m trying to summarize information in a Linked Record field type collected through Forms in which respondents can select multiple linked records. We invite respondents to select their Subject Area Expertise, options provided are categories fr...
I followed the directions from this handy Airtable Support Page: Sending Airtable data to Microsoft Power BI & Power Query to get data from one of my tables to Power BI.
It worked perfectly. Then I transformed one field/column on Power BI by mistake,...
Hi Laura,I think this might be a temporary problem, because I had an interface with charts using lookup fields that worked fine for a whole month, and just this week they weren't displaying properly. I explained more in my reply here (came to the Com...
Hi choldgraf.This happened to my team's interfaces this week, so I hope it is a temporary issue. As originally designed, the interface we have displayed state (location) of respondents to our form:Field type was Linked Record to a table where each St...
Adam_TheTimeSavingCo:
Hmm! Sorry, I don’t understand this bit, the formula would be longer but would still work fine. What’s the problem that arises from having many restaurants?
I may very well be misinterpreting your suggestion or am unfamil...
That would be handy if I only had three Restaurants, but I have more than a dozen!
But your response did inspire me to create two lookup fields of Restaurant names in the Order table’s “part of menu” or “individual dish” fields, and then create two R...
Thanks for the comment.
I had originally tried to just concatenate the two fields I titled with BACKEND but because these are Rollups with array(unique), the resulting concatenation in the formula field omits the comma. It seems to still be the case ...
