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,...
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 ...
@Kamille_Parks seems like the output for ARRAYUNIQUE cannot be split when I generate a bar/pie chart in the Charts app or in Interface (e.g. “Health, Education” and “Health” are separate bars/slices.
Is there a way to manipulate the formula to make t...
Kamille THANK YOU!
I was not aware of the ARRAYUNIQUE formula for rollup, and good to know that I don’t need quotations for the numbers.
ARRAYUNIQUE is going to help me a LOT in terms of analysis and deleting all these helper columns I’ve created. I ...