Solved

Is it possible to send a weekly digest of all records created within that week? If so, how? I was playing around with the automation, but I really don’t see the trigger I am looking for. I am looking for FREE solutions, thanks!

Trying to add indicated number of days to date via scripting. But the system gives an error. Anyone has any clues about what is wrong? Maybe the DATEADD function is available to formulas only and is not available for scripting? ReferenceError: DATEADD is not defined Code: let current_date = new Date(); let date_added = DATEADD(current_date, 7, 'days')

I have a table for physical addresses and a formula field to convert linked records to an array. Below is an example of the array. “Main Residence: 123 Main, New York, NY 10001”, “Office: 789 Left Ave, 3b, New York, NY 10001”, “Vacation: 456 Right St, New York, NY 10001” How can I extract or leave only the address for the office? If there is an office, show the address and if not, leave the field blank.

Hello, HELP! Working with a base containing formatted currency fields but when downloading CSV, the resulting import into MS Excel, converts the currency fields to TEXT. Is there a way to override this so that currency remains as a number field? Thank you in advance Kind regards, Sally

Is there any good workaround to specify a global filter that applies to all shown tables or views? The idea is that a user needs to work with multiple tables/views and applying a filter to each of them (changing customer, for example) is quite cumbersome. Any ideas? The alternative we are using is using a different base for each customer, but that doesn’t seem very efficient and requires to apply changes in multiple bases.

Hello everyone! I’m trying to migrate from Google Sheets to Airtable, but still having issues creating a budget template for my projects… As you can see in the screenshot below, my “total” and “tax” fields are working fine when I add numbers to the fields “QTY” and “COST”, however, my “SUBTOTAL” formula (also in the screenshot) always stays at zero, regardless if I do or do not add numbers to the fields “freight” or “Discount”. I also would like my subtotal field to calculate the formulas even if “discounts” and “freight” are numbered as zero as I don’t always get a discount or have to pay for freight. Can someone please help me understand what I’m doing wrong and how to solve it? It would be very much appreciated!

I’m having a little trouble with a script I’m using to update a date field in Airtable with data from an API. The API I’m using gives date/time info most of the time. Every once in a while it’ll output a string like “UNKNOWN,” which brings the whole thing to a grinding halt. I’d like my script to be able to skip trying to enter that in and move on to the next iteration in the loop. I’m feeding the data it gives me to a Date() function to save it as a new variable, then I pass that variable to table.updateRecordAsync(). But when the data is a string that can’t be parsed into a date, I get an error saying that the Airtable can’t store that string into a date field. Which is totally accurate and fine, but it halts the whole script. Is there a function/operator or something to check whether a variable/constant/piece of data is in a format that Airtable will accept for a specific kind of field? Thank you!

Hi all, I want to use the DATEADD() formula on only the oldest created value (date) in a Lookup column that stores multiple values (a 1-to-many relationship is needed). I can’t seem to figure out a way to design the base or write a formula that does this. Any ideas? Thanks, Julie

Greetings! I would love to anybody’s help with solving some not-trivial task for Airtable automation. I have long-text field with many words ( I do not know exact number of words, but all of them separated by " "). Is there any possibility to split this field to different words? This script for automation. When the form is submitted with long-text field, the script will create as much records as words in long-text field. Thank you so much

Hi, I need to convert letters to their position in the alphabet. So A becomes 1, B → 2, C → 3 etc… Does Airtable have a function to do that? I’d like to avoid the multiple IF statements :upside_down_face: Thank you

Scripting within an automation, I’ve tried a couple of ways but I can’t get the console log to output across multiple lines. As a work around I can use a table, but it’s kind of annoying that it’s collapsed, and I just want a few lines of console to appear; Any suggestions?

Hello, this is an example of a value in my NAME field: 1290 Name 3 (Some Words) 1255 Another Name 12 (more words) I’m looking for a formula that will get rid of the numbers and space before Name, and anything in parentheses) so would result in: Name Another Name Thanks for any help!

I’m trying to build a dashboard for investors on top of our sales and client data. I don’t want them to have access to the data itself, but only see charts and summarized values. I believe that with the built-in Airtable data visualization tools, this is not possible as I have to give access to the entire base. How would you approach this? Which third-party app would you use for some simple graphs and sums? Thanks!

Hey all. I am trying to use Airtable to manage farming schedules. I’m trying to figure out an automation that would create an entry in one of four other tables, whenever I update a status on a primary table. Specifically, I have a primary table with all the seeds I am using, and one of the field types is a single-select with labels [Seeded, Transplant, Finish, Harvest]. I also have several scheduling tables that correspond to each of those labels. The idea then, is that when I set a seed status to “Seeded”, an entry for that seed would be created in the Seeded table, and so on for the other tables. Would a REGEX_MATCH formula work for this? I have zero experience writing up complicated formulas.

I want only current records to show in a view. There doesn’t seem to be a way to filter for “date created after dateX”, so I figure I can create a field that says “yes” if the date created is after whatever date I put in, then filter on that field. But what would be the formula for saying, "If ‘date created’ is after September 13, “yes”, “no”)? Thanks!

I’m not too sure where I’m going wrong. The Javascript examples I’ve read indicate that this should work, but Airtable isn’t processing them as I’d hoped - and judging from the results I’ll need to modify my script somehow. Although the Automation triggers at the correct local time, it certainly doesn’t pass the local time as an input into the script - which isn’t a problem so long as we can easily process it to the correct time within the script, which is where I’m stuck. //Trigger executes 7am daily and provides the _input_date to the script, but it is using yesterdays date (even though Airtable trigger states it is using local time?), so attempting to align it with local time via JS below let rightNow = input.config()._input_date; var date = new Date(rightNow); let today = new Date() let string = today.toLocaleDateString() let correct = new Date(string) console.log(date.getTimezoneOffset()); console.log(date.toLocaleTimeString('en-AU')); console.log(correct) Appreciate any hel

Hi all, I’ve been spending around 2 hours trying to understand what I was missing in a simple “if X superior to Y, then show X, otherwise show Y”… Here’s a screencast of what’s happening, can’t believe my eyes :Screencastify I have Y = 11.8 If I change X to 9, the formula says X is higher than 9… Very weird behaviour here as shown above. Any hint on this amazing bug??

what formula can I run against a text field that will display all text characters up to a “,”. Example: TEXT1, TEXT2 Result: TEXT1

Hi everyone, I currently have a base where there is a column for DIMENSIONS in the form of manual entry formated as such: 12" x 10" x 8" I would like to SPLIT the numerical values into 3 different columns (column 1 = 12, column 2 = 10, column 3 = 8) From my research I have not been able to find an adequate split formula (I know that airtable, unfortunately, doesn’t have an easy way to SPLIT) How best would I go about splitting this information by a split-like formula?

I am trying to count the number of values entered in each cell of a column, just so that I can perform certain automation. like for example, if the column name is 'Colleagues" and the first row in this column contains three names of colleagues. Then how can I automatically detect that there are 3 names/values entered in this cell?

Hi community! Is it possible to trigger a built-in Airtable automation (example: Create a custom automation) when a button is clicked? Thanks!

Hi everyone! I have been using Airtable together with one collaborator for a while and reached record limit on one of my bases. Unfortunately, I think the service has a rather steep cost rise for users like me that have few basic bases with one collaborator only but who surpass a thousand records x base. I am currently paying for premium services but none of them is $20 x month with the prospect of having to upgrade to $40 sometime soon. I was thinking of excluding my collaborator from the base workplace (making him not billable) and hence cutting my costs to half. Before doing that, I need to be extra SURE that my base data will remain as it is, and if I eliminate him I won’t lose any records and changes HE had previously made to my base. Can anyone please advise me on how to proceed? Thanks so much.

Hi All, I hope someone could help me a better way of doing this. I have two tables on a base (Table 1 and Table 2). In Table 1, data is shown below: Here is what I am trying to do in Table 2: Count all similar State Country entries from table 1 Count all EMEA, APAC and AMERICAS from table 1 I tried using the Pivot Table app but the lack of exporting it to CSV is not ideal for me.

Hi there, I am using a formula field to pull the time stamp (and t-zone) from a Date and Time field. I am using this formula currently: DATETIME_FORMAT(SET_TIMEZONE({Day 1 - Start}, ‘America/Los_Angeles’), ‘h:mm a’). This works wonderfully, however, if the time and date field is blank (which, in my case, does happen) my time stamp field shows #ERROR. How can I add to this formula so it knows to leave the field blank if the date and time field is blank? Would appreciate all and any help on this. Daniel

Hello, I am looking for the option that when trying to create a record, the system will autocomplete or suggest based on information already registered in other fields.