Solved

in our simple CRM system for our shop, we’d like to keep record of which dates the repeat customers have visited in the past. (and count them up to know how times total he/she has visited) We know each day the customer visits since the staff enters it, but what’s the best practice for keeping track of all the dates of the visits? Is there a way to automate some of this?

Hi all, I am wondering if I had a long text field and then a multi select field for key words, could I create a formula to show each key word and a count of it’s occurrence in the text field.

Expected behaviour: return the number of selected items.

I would like to use lookup in formula field. How can I make it? Here is my Airtable. Airtable Airtable: Organize anything you can imagine Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free. In the Table A, the data which entered by the user via form is “a”. Then the data will convert by a formula into “aa”. This “aa” is the key data in the Table B. I want to lookup the data form Table B using “aa”. Here is the form. Airtable Form - Airtable Fill out the "Form" form quickly and securely on Airtable. Thanks for your great support!

So, I made a calendar view based on a calculated field. Everything in the calculation seems correct and items appear in the proper spots within the calendar. But every entry on the calendar begins by showing the month in the date calculation. Why? You can clearly see which month each entry is using - it’s a calendar! So why show this subset of a field before showing the primary field name? Seems like a bug.

Hi I have a student / courses many to many relationship. I’d like to have a column in the Students table with only the current year’s course. Is there a way to to this using a formula? It guess it would have to filter according to the year column of the Courses table. If courses.year = 17 () Is this in any way possible?

How long can long text be?

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.

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.

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}))

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.