Jono_Prest - profile

Jono_Prest · Oct 05, 2021

Hi there, I’m a developer who has been building some custom apps for a company over the last 6 months to help keep Airtable at the center of their operations and integrate various services and APIs right into their Airtable workflow. One of the most ...

Jono_Prest · Nov 05, 2021

Xavier_G_Sabater: let foundValue = lookupRangeRecords.records.filter(filt =>{ return filt.getCellValue("Item") === lookupvalue; }) await mainTable.updateRecordAsync(record, {"CA Inv"}: foundValue.getCellValue("CA INV")) Runnin...

Jono_Prest · Nov 05, 2021

Hi @Mark_Brigham, Welcome to the community! I have a few suggestions for your problem. Perhaps the simplest thing would be to have a formula field in your table that divides the value by your total budget. For example let’s say your budget is $5000 a...

Jono_Prest · Nov 05, 2021

Hi @Aaron_Hanson, You should be able to set a cookie in your header on a fetch request from the airtable scripting app seeing as it’s just using your browser-native implementation of fetch. This is not the case with a scripting action that runs on an...

Jono_Prest · Nov 05, 2021

Hi @forms.ge, Unfortunately there is no native way to do this with an airtable automation. You can create the pdfs manually using the Page Designer app but this does not integrate with an automation. Your only option is to use a third party service. ...

Jono_Prest · Nov 05, 2021

Welcome @Joe_Pepper ! Will need a little more info to help you debug. What is the issue or error you are getting when you run this? For one, the .selectRecordsAsync() method is deprecated so you need to pass in an object with the fields you want to s...

User Statistics

User Activity

Feature Request: recordActionData.fieldId in useRecordActionData hook

Re: Help with simple code block

Re: How to subtract from a value using groups and subgroups

Re: Alternatives to fetch() and cookies for authentication?

Re: PDF document in automation

Re: Vlookup script help