Solved

Hey guys, I’m struggling to get my if condition to return a value which is formatted as a currency. Formula as below IF(Client=‘Ebay’,{Qty/Hr}*{Qty/Hr Price}*0.029+0.30,’’) This is returning the value as a number with decimals, but refusing to allow me to format as currency Formatting error: Is anyone able to assist with this, thanks in advance.

I am stuck on something that shouldn’t be as hard as I’m making it. I have several formula fields in my base that are calculating dates based on a # of days entered. I want to put all of these dates together - but I’m having a minor issue. Some projects have 1 date, others have 3 - up to 4 potential dates that need to be concatenated. I have a simple formula written that concatenates them "IF( {FP 1st}, CONCATENATE({FP 1st}, ", ",{Fp 2nd}, ", ",{Fp 3rd}, ", “, {FP 4th}))” - so if the FP 1st isn’t blank, put all of the values together. The issue I’m having is that for the projects that don’t have FP 2nd or higher, I’m still getting the commas. Normally this isn’t a big issue, but this field is going on a shared view for clients. Is there a way to write an IF formula to tackle this? Or set it up differently and try to run an array formula on this field?

Guys you are always so amazing, I have tried everything I can think of I have a table with rows that represent different branches and then there’s 15 columns representing a variety of different areas all with options red, amber, green - i would really like to have a colum that counts how many “red” responses there are, how many amber etc but I cannot work out how to do that - any ideas Thanks in advance

Hi everybody. My question is simple… (hopefully the solution also) I need a formula who automaticly tells me what date it is next Tuesday. On Wednesday it needs to update itself to next Tuesday. Thanks in advance!

Hi all, I’m loving the new Automations in Airtable, but getting stuck on what I think should be a pretty simple thing… I have a table that functions as an inbox for messages and attachments coming in via a Zapier integration from an email inbox. And I want to then use Automations to copy these incoming records to various tables where they’ll be processed - I have a growing variety of incoming message types so want to split out the handling of each type to a dedicated table. I can easily create new records and populate with much of the relevant data, but I cannot move an attachment(s) across to the new record in the second table. What’s the easiest way to achieve that? Thanks!

Hi everyone, Im trying to put together a payroll base for my small start-up but Im finding it quite challenging dealing with the income tax calculation bit which requires the use of a progressive tax bracket system. The income tax bracket system has the following rules - Chargeable Income Rate (%) First 319.00 0.0% Next 100 5.0% Next 120 10.0% Next 3,000 17.5% Next 16,461 25% Exceeding 20,000 30% Since there isnt any vlookup in Airtable like in Excel making an if statement is impossible. I am pretty sure there is a simpler way to go about it but I just dont have the insight yet. Any help is totally appreciated.

I have 2 fields that are linked to other fields. I want to combine the 2 fields in a 3rd field and keep the 3rd field still linked. If I do a simple {Field 1} & {Field 2} in a formula field, it makes the linked records into stringed text. How can I keep the resulting field still linked? Thanks!

I’m using a formula to populate the PrimaryKey field which looks like YEAR(Date_form_submitted) &"/"& MONTH(Date_form_submitted) &"/"& {department_code_lookup (from Departments_Lookup)}&"/"& rolling_id It works perfectly without any issues. What I want to do is add this generate value in a form. So for example, someone is submitting a new form and prior to submission I want to let them know what the PrimaryKey value (labeled as URN) is. Equally is there a way that I can send an email on submission that includes the Primarykey (URN) value to the submitter? Regards Simon

With the Pro plan, there are “20 synced tables per base”. Does this mean that a table can only send its data out to 20 other tables? Or does it mean that a table can only have incoming data from 20 synced tables? Or both … or something else? Thanks.

I would like users to be able to select an individual name when filling a form. I created a calculated field with the Last and First Names. But it seems I cannot add a calculated field to a form. How else can I do this? Just to clarify. If I have calculated two entries “Smith, John” and “Smith, Peter” how can I list them in the form?

I have a rollup field that uses ARRAYJOIN() to produce string values separated by commas. Next, I want to be able to count all instances of a particular string.For Example, the field I want to count contains: BT,DT,BT, DT. I want to count only the “DT.” Any suggestions on what formulas are able to do this? I would use a conditional rollup, but it doesn’t feature any “IF” statements.

Is the WEBSITE DOWN now ?

Hi community! I am building a job site with Webflow and using Airtable as the database. Note: Job site not job board, which means the candidates will apply on the same site, instead of linking them to the company’s “jobs” page, as Job boards do. With the tutorials I saw online, including the one by @Aron, the “Apply Now” button links to an external site. With my Job site, I’m linking it to an Application form, where I need to prefill 2 things: The Company and the Position. I currently have a “Job Posts” table, a “Candidates” table, and a “Apply now” form/table. Every Job Post has an associated “Apply Now” URL which can be customized to have either the company name or the position prefilled (whichever is the primary field). The “Apply Now” form links to the “Job Posts” table and picks the primary field. I need both: the company name and the position to be prefilled into the form. How do I do this?

I have a formula where this year’s anniversary is based on the date of Marriage but it returns an ERROR if the marriage date is blank and I would like it show as a blank instead. Here is my old formula. DATETIME_PARSE( DATETIME_FORMAT( {Marriage Date}, ‘MMMM D’ )& ’ '& YEAR( TODAY() ), ‘MMM D YYYY’ ) II have tried using an IF statement and it does work for the blank marriage dates but for some reason, the ones with Marriage dates are no longer formatted as MMM/D/YYYY and instead show 2020-03-31T00:00:00.000Z. . Here is my new Formula with the wrong formatting: IF({Marriage Date},DATETIME_PARSE( DATETIME_FORMAT( {Marriage Date}, ‘MMMM D’ )& ’ '& YEAR( TODAY() ), ‘MMM D YYYY’ ),"") I can’t figure out where to move the date formatting so it shows up as 3/31/2020 Any help would be appreciated.

The documentation page for RecordQueryResult says “…filtered to a useful subset of the records in the table.” I see that it’s possible to sort and specify which fields are returned but I can’t figure out how to actually filter on selectRecordsAsync. Being able to filter here would be awesome because then I won’t have to manually create views. (Or if it were possible to programmatically create Views I could create the ones I need when a new employee is onboarded.) Thanks!

Hey, I have been reading carefully the airtable api documentation to work with my data. I tried copying and pasting the suggested snippets of code from the official docs into visual studio project. which is just an index.html boilerplate + an app.js reference in the same folder. I understand that in order to follow the documentation I must install airtable via npm into my project folder. All done. Now when I add the code to my project and save it, I get an error on the console: “app.js:1 Uncaught ReferenceError: require is not defined at app.js:1” Then I thought, this must be something to do with the airtable npm module not being referenced. I then look for a fix here in the community and could not find any, so a threat in stack overflow advice to include: import Airtable, { Base } from “airtable”; Now after saving and loading my html boiler plate and checking the console it reads: Uncaught SyntaxError: Cannot use import statement outside a module Can someone show me, how to list

Is there a way to choose which record gets referenced while setting up and testing an automation? I am setting up some email automations and I want to avoid emailing an actual customer during the testing and trial process. I have a sample customer and a record using the sample customer’s information created; but the record that is referenced for use in the actions section is an earlier record referencing a real customer. The record I want to use for all setup and testing purposes: The record that is being automatically referenced for all setup and testing purposes: I’m sure I could find a workaround by creating a blank new table or moving previous records around in some way, but it would be far easier to just select my sample customer’s record in my live table.

Until yesterday Typeform -> Aitable direct integration was working well. From yesterday it does not work the uploading of images (from the “attachment” field of Typeform into the “attachment” field of Airtable). Everything it is automatically imported excluding the images. On the contrary, Airtable Typeform app works well. Anybody with the same problem? RColasanti

Hi There, I’m having a hard time figuring out how to put a value when a subscription occurs between to date : I’ve tried this :arrow_down: IF( {Date} < ‘30/09/2020’, “TPP Test phase”, IF( {Date} < ‘31/12/2020’, “TPP OND”, IF({Date} < ‘31/03/2021’, “TPP JFM”, IF({Date} < ‘30/06/2021’, “TPP AMJ” ) ) ) ) But it won’t work at all. Someone could help please ?

The formula is indicated on the screenshot. How to get Duration value, not a NaN?

IF + SWITCH formula can’t have a non-numeric value as True / False argument. If it does, the result of this formula is going to be ALWAYS non-numeric and thus can’t never be used as an input for calculation in subsequent formulas. For instance, if I have IF(Column1=“ABCD”,999999,“nonsense”)… the result of this formula is always non-numeric, no matter what the result. Even if the result is TRUE (that is Column contains ABCD), the result of the formula is non-numeric text 999999. To get numeric result, I have to change the formula to IF(Column1=“ABCD”,999999,“000000000000000”) and then I’ll get 999999 as numeric result. Same goes for SWITCH formula. This is an issue when the result of the IF or SWITCH formula is an input or variable in a subsequent formula because the result of the subsequent formula(s) produces an #ERROR! This is not a show-stopper but reduces the usability if I can’t have text “nonsense” as the result if the result of first formula is FALSE. What we need is the first

Hi, I’m having trouble with the following formula: IF(LEN({Copy})>150,“ :rotating_light: ”,“ :ok_hand: ”). It returns “ :rotating_light: ” if the Copy cell quantity is longer than 150 characters and “ :ok_hand: ” if less than 150. However, I’d like it to return a blank value if the Copy cell is empty. I’ve tried adding “BLANK ()” to the formula a few different ways, but it either returns an error message or doesn’t take. Any help would be appreciated. Thank you!

I have 2 fields that contain email addresses. The first column contains 1 email address and the the 2nd column contains multiple email addresses. I want to create a 3rd column that combines both fields with the appropriate commas separating each email address. What formula can I use?

I have two rollup columns that each contain (potentially a lot) of text values. Rollup column 1 will most likely contain some, but not all, of the same text values of Rollup column 2. I need a way to write a formula for a third column that pulls out any unique text that exists in column 2 that does not exist in column 1 and then shows what those unique text values are in column 3. (Essentially I’m trying to find values that don’t match between the two columns, but I don’t want to calculate just a true or false statement as to whether the two columns match. I want to know what the text values are.) Anyone that can help? -Thanks

I am using grouping in several of my views and I was looking at the “guide to grouped records” page from Airtable and saw that I should be able to hide no grouped records - so records that are empty in the field I’m grouping by. I went to do that, and I do not have that icon on my grouping dropdown. I saw that if I changed the field I’m sorting by to something else, it appears. The fields I’m trying to sort by are “calculated fields” and I only want to see the records in these views if those values have been calculated, otherwise I don’t want to see them. Any clue how to fix this on the grouping level or do I just need to filter them out? https://support.airtable.com/hc/en-us/articles/221747587-Guide-to-grouped-records#:~:text=Once%20you’ve%20grouped%20your,or%20hide%20no%20grouped%20records. This is where I saw that as an option, at the very bottom.