Skip to main content

Solved

7383 Topics
H
Hashim_WarrenKnown Participant
asked in Other Questions
What is the long text character limit?

How long can long text be?

314
C
M
Matt_SaywardKnown Participant
asked in Formulas
Number operations in text

Airtable doesn’t seem especially forgiving of formulas doing numerical operations when the original cell contained text. For example, I have a cell describing engine sizes of cars. They’re pasted in like the following: “1498cc”. I’d like to show the engine size in litres, which would translate to “1.5 Litres” What I’d like to do is have a formula substitute out the ‘cc’, then divide the remaining 1498 by 1000 (which would be 1.498), then round the 1.498 to 1 decimal place (1.5), and then put " Litres" at the end of it. The following formula works exactly as you’d expect in Google Sheets / Excel: =concatenate(round(substitute({Engine Size}, “cc”, “”)/1000, 1), " Litres") However, Airtable formulas doesn’t seem to be able to treat ‘1498’ as a number after the ‘cc’ has been removed.

141
P
J
James_SamuelKnown Participant
asked in Other Questions
Parse a date while keeping the European date format

I’m struggling with dates, and suspect it might have to do with the different conventions for describing dates. Here in NZ (and in most of Europe) we use DD-MM-YYYY whereas in the US you use MM-DD-YYYY. Rather than describe in words, it will be easier to show you these screenshots that tell the story. I’m trying to present a date (that is recognised as a date), that is stripped of the time details in the DateTimeStart field.

3410
T
C
Chester_McLaughInspiring
asked in Other Questions
OR, filterByFormula, and Date Field don't work together

I have a field called {Expires}. I would like to use the filterByFormula parameter via the API to retrieve records that have no expiration date or that have not yet expired. This successfully retrieves records that have no expiration: {Expires}=’’ This successfully retrieves records that have not yet expired: IS_BEFORE(TODAY(), {Expires}) Putting the two statements into an “OR” condition seems like it should work, however it only returns records that have not yet expired—omitting records that are empty/blank/have no expiration: OR({Expires}=’’, IS_BEFORE(TODAY(), {Expires})) I have also tried testing for ISERROR rather than =’’, but the behavior is the same. This works as expected (returns records with an empty/blank {Expires} field): ISERROR(IS_BEFORE(TODAY(), {Expires})) This omits records with empty {Expires}: OR(ISERROR(IS_BEFORE(TODAY(), {Expires})), IS_BEFORE(TODAY(), {Expires}))

162
C
C
Chester_McLaughInspiring
asked in Development & APIs
Formula using {Start Date} field always returns records with empty {Start Date}

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

163
K
D
Daniel_CzertokNew Participant
asked in Other Questions
Error when using formulas

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?

91
K
R
Renee_SmithNew Participant
asked in Other Questions
Formula error when dividing currency by integer of 2

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

31
K
D
DracoNew Participant
asked in Other Questions
How to CREATE a RECORD using GROOVY-WSLITE?

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.

41
A

Badge winners

Show all badges
Terms & Conditions