Adi_Menayang - profile

Adi_Menayang · Sep 28, 2022

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...

Adi_Menayang · May 16, 2022

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_...

Adi_Menayang · Mar 24, 2022

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...

Adi_Menayang · Mar 02, 2022

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...

Adi_Menayang · Sep 08, 2021

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,...

Adi_Menayang · Oct 04, 2022

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...

Adi_Menayang · Oct 03, 2022

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...

Adi_Menayang · Mar 24, 2022

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 ...

Adi_Menayang · Mar 02, 2022

@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...

Adi_Menayang · Mar 02, 2022

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 ...

User Statistics

User Activity

Use Lookup Fields to Append a Multiple Select Linked Record Field Type using Automations

If((Find)) not functioning properly

Concatenating two rollup fields with array(unique), but comma is missing

Can I turn formula fields using IF(FIND) into a numeric field? (Or alternatives)

Airtable to Power BI "Expression.Error"

Re: Use Lookup Fields to Append a Multiple Select Linked Record Field Type using Automations

Re: Use Lookup Fields to Append a Multiple Select Linked Record Field Type using Automations

Re: Concatenating two rollup fields with array(unique), but comma is missing

Re: Can I turn formula fields using IF(FIND) into a numeric field? (Or alternatives)

Re: Can I turn formula fields using IF(FIND) into a numeric field? (Or alternatives)