I have an Airtable Database with Fieldname (“Expense”) and values. I am trying to write a JS code to query if user input available in this database. Here is what I got so far. Appreciate help in getting the RegexMatch / FilterbyFormula work. Thank yo...
Hi All!
I am building a tool with Airtable as database and users can access using API. Is there a way I can review log of all user requests? I am especially interested in requests that failed to analyze and add those records to my Airtable db.
Hi! I have an excel VBA tool and I’m inclined to use Airtable as the tool’s back-end database (db). Based on the user’s input text (string), I’m looking for Airtable API that will loop through all fields and return if text is present in the db, else ...
I have a simple table called “Imported table” where Field 1 is merchant category and Field 2, 3, 4…10 are merchant names.
I am looking for a JS function with merchant name as parameter and if present in the database, can return the corresponding Fiel...
@kuovonne - thanks for this! I was hoping I could do this using Airtable. My tool’s front-end currently is excel, so I have now added a vba code to log all failed API requests to a separate table in Airtable.
Thanks for the tip!
@Justin_Barrett thanks for the response!
I was trying this code on Airtable Scripting and I think I read somewhere that Scripting doesn’t support filterbyformula. However, I was able to run this on node js with a few minor changes to the code as belo...
My code is as follows, but line 4 seems to throw an error. Any suggestions on how to use the filterbyFormula?
function checkmerchant(merchant) {
let table = base.getTable(“Imported table”);
for (let field of table.fields) {
let recordFound = table.se...
Thank you - I was looking for the JS Script API, which I was able to figure using the attached link
Pass variable in filterByFormula (Node.js) API
Hi, would anybody know how to pass the second variable (airtableField) in b...
Hi @dilipborad
I an new to Airtable and have a similar requirement. I have a simple database with keywords. I’m looking for a get API that will search input string in the database and if available, output the same.
It looks like Regex can resolve thi...
