andy_m - profile

andy_m · Apr 02, 2024

This forum has been incredibly helpful, so I thought I'd keep asking questions. Next up is why filterByFormula doesn't seem to work in my node app. However, the formula works in the Airtable UI and when used in an HTTP request via the API. const bas...

andy_m · Apr 02, 2024

Just to be clear. When I add a lookup field to a table, that field is not accessible direct through `getCellValue`, correct? I still have to get the id of the corresponding Linked Record field, and do another lookup to get the value of the field that...

andy_m · Mar 31, 2024

I'm trying to write a formula that will count days between two dates (assignment_start_date and assignment_end_date) that overlap the current week, not counting weekends.First example:current date is 4/5/2024assignment_start_date = 3/25/2024assignme...

andy_m · Mar 13, 2024

New to AirtTable automation and surprised this hasn't been asked before, but I couldn't find anything in docs or here. I've got a repeating group set up using List of Records as the Input list. The list of records is only 8 rows long.For each record,...

andy_m · Apr 03, 2024

thanks!

andy_m · Apr 02, 2024

wow. I've just been calling the field by the field name. However when I tested using the field's actual ID, I got the array as you guys pointed out. Then I tried using the field name as displayed and got the array. Example: I have field called `user...

andy_m · Apr 02, 2024

fyi. I indeed ended up doing this with JS and a script I'm running daily.

andy_m · Apr 01, 2024

@ScottWorld thanks for the quick reply. I had the same thought about Javascript after I posted this last night. I'm much better with JS, anyways.I was trying to keep this lightweight, though, as there are thousands of records that will have to be pro...

andy_m · Mar 13, 2024

@Dan_Montoya If it were a snake it would have bitten me. That worked perfectly. thanks

User Statistics

User Activity

filterByFormula returns nothing (node.js) but results everywhere else

Get the value of a lookup field

Formula to count days between two dates that overlap the current week.

Access Values from Repeating Group in Script

Re: filterByFormula returns nothing (node.js) but results everywhere else

Re: Get the value of a lookup field

Re: Formula to count days between two dates that overlap the current week.

Re: Formula to count days between two dates that overlap the current week.

Re: Access Values from Repeating Group in Script