Solved

When using filterByFormula via the API, records on which the given formula produces an error are returned NO MATTER WHAT—even when a different record ID is supplied. For example, I have many records with a {Start Date} field containing a date and one record with an empty {Start Date} field. IF I use the API to ask for records with filterByFormula=“RECORD_ID()=‘rec5pBFqsn3Bva8mz’”, I will of course, only get that one record. As Expected. And if I use the API to ask for multiple records using filterByFormula=“OR(RECORD_ID()=‘rec5pBFqsn3Bva8mz’,RECORD_ID()=‘n3Bva8mzrec5pBFqs’”), I will get only the records I specified. As Expected. However, if my formula references the {Start Date} field, then any records on which that formula produces an error will be returned, even though its record ID was not among those specified. So using DATETIME_DIFF on the {Start Date} column in a filterByFormula means I’ll ALWAYS have the records with empty {Start Date} included in the results—even if I try to in

I am trying to make a basic formula such as 2X4 = 8 however i constalny get an error message in the formula column any thoughts?

Formula error in inventory (imported cvs) when computing unit price. COST column is specified as currency ($) and QTY column is integer 2 numeric. U/PRICE column contains formula as follows: COST/QTY (Result should be $ but displays as integer 2 Record from db is COST OF $1.00 divided by QTY OF 10 = U/PRICE BLANK INSTEAD OF $.10 THANKS

Hi team support airtable, I tried in 2 ways … without success. WITH SOAP import wslite.soap.SOAPClient client = new SOAPClient(wadl) list = client.send(SOAPAction:‘https://api.airtable.com/create’,headers:[‘Authorization’:'Bearer key…’ , ‘mediaType’:‘application/json’] ) not know how to pass parameters “fields:” -> I do not know how to get the “response” WITH REST import wslite.rest.RESTClient import wslite.http.auth.* client = new RESTClient(wadl) client.authorization = new HTTPBasicAuthorization(‘Authorization’,‘Bearer key…’) list = client.get(path:’/v0/appsc…/resource’) not know how to pass parameters “fields:” -> I do not know how to get the “response” Regards Draco pd: congratulations,… airtable is increible.