Michael_Benson - profile

Michael_Benson · May 12, 2023

Hello,I want to compare the values of a Rollup field with a Linked Record field.Field A is a rollup that contains the following text:"Value 1, Value 2"Field B is a Linked Record that contains the following records:Value 1 Value 2I want a formula that...

Michael_Benson · Feb 03, 2022

Hi there, I have built an automation that will: Step 1: Trigger when a record is created in Table A Step 2: Find matching records based on a condition in Table B Step 3: Update a linked field on all matching records from Step 2 with the ID of the new...

Michael_Benson · Feb 01, 2022

Hi there, Lets say hypothetically that I have 40 separate Linked Record Fields (Field 1, 2, 3 etc) that make the same connection between Table A and Table B. For each row only one of these fields will be updated. I want to therefore create a master f...

Michael_Benson · Jan 31, 2022

Hi there, I have a rollup field - Field A - which displays items in an array using a comma separator. I retrieve the items using ARRAYUNIQUE(values). When I try and call this field in another field - Field B, this formula keeps the comma separator: {...

Michael_Benson · Jan 30, 2022

Hi there, Let’s say I have a formula field - Field A - that produces a decimal value (e.g., 0.5). I use the formatting option within the formula field to display this value as a percentage. However when I call that field in another formula - Field B ...

Michael_Benson · Jul 13, 2022

I prefer the current format. It’s all a little cleaner. However, I’m not moving between bases - we keep everything all in one, so for my use case, I feel the current format is nicer :slightly_smiling_face:

Michael_Benson · Jun 14, 2022

This would be really useful. It seems to be a feature with the Chart App in the “Main” Airtable. Is there any chance this feature could be expanded to cover the Chart App in Interfaces as well? Otherwise there is no suitable alternative to properly d...

Michael_Benson · Feb 06, 2022

Thanks guys. I think I’ve worked out the problem. It seems the script is triggering too quickly. It is set to trigger when a new record is created, but sometimes a user might create a record and then spent 5-10 seconds filling out the fields that thi...

Michael_Benson · Feb 05, 2022

Thanks Jonathan - this is a newbie question, but how should I go about logging record? Should I be using the output object? Any help getting started here would be great!

Michael_Benson · Jan 31, 2022

Thanks both! I’ve opted for Scott’s approach as I still need to be able to count items in the array. I didn’t realise we could use ARRAYJOIN outside of a Rollup field. The documentation seems a little unclear: https://support.airtable.com/hc/en-us/ar...

User Statistics

User Activity

Compare Linked Record field against Rollup field

Automation script not updating linked record field

Rollup data from multiple linked records

Commas separating items in array lost

Formatting percentage numbers in a formula

Re: Product Update: Improvements to Base Navigation

Re: Interfaces Bar Chart Default to Stack

Re: Automation script not updating linked record field

Re: Automation script not updating linked record field

Re: Commas separating items in array lost