Solved

I have used a formula to create a new date value based on another date cell: The Next Due Date uses the following formula: SWITCH(Frequency,'Weekly', DATETIME_FORMAT(DATEADD({Task Due}, 1, 'week'), 'DD/MM/YYYY'),'Monthly', DATETIME_FORMAT(DATEADD({Task Due}, 1, 'month'), 'DD/MM/YYYY'),'Quarterly', DATETIME_FORMAT(DATEADD({Task Due}, 3, 'month'), 'DD/MM/YYYY')) However,  to set up views and automations I need to be able to use the conditional properties of a date value, and I can not seem to filter on any of the normal date values. Is there a way to filter Next Due Date to be 'within' and 'the past week'? Thank you! 

hi friends! we are an organization that provides online trainings. i have a base with registrations in one table and a unique attendance list in another table. the other table has a list of all the trainings.so the registrations table is all the registrations we received for each training, so that we can see things like: 100 people registered for training X, 80 were approved to attend (either because they were members or they paid), and 70 actually attended. because people attend multiple trainings, this list contains different registrations for the same person.the attendance table is a list of each person who ever attended a training with a related record field that contains all the trainings they attended, linked from the list. that way we can see things like: 300 people attended our trainings last year, person X attended 4 trainings, Y organization sent 4 people to trainings last year.i have an automation set up that after a training happens & we record the attendance, it takes

Hello! Apologies for the potentially basic question, but I was having trouble sorting through the existing documentation and I couldn't find a simple explanation. I'm trying to pass the output variable newCode into a new script, however I'm not sure how to define the variable before I pass it to the oldCode variable (see screenshot). Any suggestions would be appreciated!Thanks,Peter

Hi everyone, I just would like to know if it is possible that I can hide fields with empty value in gallery view. Airtable Gallery - Airtable Explore the "Gallery" view on Airtable. For example, I would like to hide “Attachments” in row “Test1”, “Notes” in row “Test2”, and “status” in row “Test3”. Is it possible? Thank you!

Hey there!I have two tables. One contains projects, and the other contains tasks. I want to update the status of a project (from pre-production to production) when a certain task is checked off. How would I go about doing this? 

HiI'm reading my Airtable data using the API which is working fine, I'm now trying to write back to Airtable but I am having issues.I can write to Airtable successfully if the field is a string or a number but I can't when it's a currency. Any ideas how I do this?This is how I am currently doing it: Request.headers['Authorization'] = 'Bearer API here'const obj = Noodl.Object.get(Inputs.ObjectId)  Request.content = {    records: [      {        fields: {          "Overhead": obj["Overhead"],          "Amount": obj["Amount"]        }      }  ]} Amount is currently a number although it doesn't matter if it's a string or a number as they both work but currency does not.

Hello, I am pretty new to airtable and have a slight issue with fetching info from a record within a record. With an automation i create a number of records within a record to be able to choose multiple products for the same order number. (Not a lot of context here, but it would be a way to long post if I provide all the context)All I want to do is separate the info, in the following case, for the two elements.Looks kind of like this:Amount & product (linked records)Weight (lookup)Weight, first element(help here)Weight, second element(help here)120 Coarse,100 Fine4.5, 3.04.53.0 Is there any way to fetch certain info depending on the position of the lookup element?  Thank you! 

Hi All,I need some help with extracting specific text. I've looked through the community and tried to apply the examples offered...but I am not getting it quite right.I need to extract the suburb, state and post code from a (text) address field. Some suburbs are made up of two names. Below is an example of how the addresses are formatted/written.  Whilst the addresses are made up, these are real suburbs in Australia 😀.Address Examples:305 Smith St, COCKBURN SA 544012 Lincoln Cres, WOOLLOOMOOLOO NSW 201112/65 Johnston Lane, DOG SWAMP WA 6060Wanted Outcome:COCKBURN SA 5440WOOLLOOMOOLOO NSW 2011DOG SWAMP WA 6060I appreciate the help. I don't expect an explanation but I am trying to learn so any info alongside the solution will be helpful.Thank You!!

Hi, I'm looking to just get some sort of identifier of the button pressed.  I would like to have several buttons run a single script and just identify which button is pressed in the script.I was following this code from the tutorial for getting the button working, but not sure what to access to get the label of the button pressed.  Just the record.      // Change these to match your base. let table = base.getTable('Tasks'); // When run from a button field, the script skips the prompt // and automatically uses the button's record. let record = await input.recordAsync('Choose a record', table);     

I am using the field, "Total Days Open" to count the days between the date something is submitted and the date that work is completed. The formula is: IF(AND({Work Completed} = BLANK(), {Submission Date} = BLANK()), "",IF({Work Completed} = BLANK(), DATETIME_DIFF(TODAY(), {Submission Date}, "d"), DATETIME_DIFF({Work Completed}, {Submission Date}, "d")))On a separate tab, I want to calculate the average total of days based on the Health Plan link to the records I want to average. I have been trying to use the Rollup field but it is returning a value of "NaN"

Hi, I'm new to Airtable and I'm setting up Bases for a company with multiple teams (marketing, sales, project management, asset management & finance). When I set up Bases, is it best to set up separate Bases for each team or to have one Base with multiple Tables for the entire company? The teams share data for Accounts, Contacts, Asset ID and Deal Amount, so those will be common to all and needs to be the universal source of truth. Does it make sense to have one Base with those common/shared Tables and then share and sync the Bases, or to just do it all in one Base?  If I created one Base, it will end up having many Tables and could become unwieldly, but seems much easier to create automations if everything is in one Base with multiple Tables. The end goal is to have one source of truth. 

Hi Airtable Community,I have the error as shown in the subject in my script. I am struggling to determine the field that it is referring to. Is there a way to identify fields by this "code" or am I missing something? I have no linked fields in my table.Thank you!

Hey Guys, My question is how many external API calls we can make in Scipting Extension Block per execution.FYI, my usecase is to read records(around 2000) from a table view, make 2000 API calls for all of these records, and then finally update the records in a batch update of 50.I particularly want to know that if there's any limitation on making external API calls in scripting extension block?Thanks!! 

Hi All,I made some changes to my form and now I am unable to generate it.  Error msg in Screenshot.I went to back to previous versions (snapshots) and got the same error.So now I am stuck. Would appreciate any help.  

Hi Everyone!So I would like a formula field where it shows the month and year of the End Date match the month and year today, say "This Month". I only know month and year separately as shown below however, I want them together in a single-sentence formula. IF( MONTH({END Date}) = MONTH(TODAY()),"This Month")IF( YEAR({1st Payment Date}) = YEAR(TODAY()),"This Year")

We are in the process of transitioning some of our different bases to use synced tables coming from a sort of ‘Single Source of Truth’ base. Now, some of these tables that we would like to make synced to the base have numerous linked records, lookups, rollups, as well as scripts and automations that impact them. From what I have discovered so far, there is no way to sync an already existing table containing the same information to our new source base. Is this correct? Essentially, to properly transition to the synced table, I will need to recreate all of the items that are not synced? I want to make sure this is the case before I jump into transitioning some of these bases, only to find out there was an easier workaround all along. Thanks for all the help!

I am looking to assign tasks to non-airtable users by sending them via slack. Is there an integration or extension that allows the assignee to complete the task and update the record on my table without actually going on Airtable? It appears Todoist has that sort of feature but I'm not finding anything on Airtable that enables this. Thanks in advance.

Is it possible to use a formula or some other work around to find the most recent date across 4 rollup columns? See photo. I'd like the left column to then show the most recent date, the 4 columns are different donation platforms and it'd be helpful to summarize that info to one single column showing most recent date regardless of the donation platform. 

I currently have an inventory base (A) that I synced to another base (B) in the same workspace. When I tried to sync the same base (A) to another base (C), I get this error message: Non-200 Response Received: 413 error. I am not sure why I am getting that, since the first sync worked fine. Could anyone help me figure out what that error means? I do have to sync the original inventory base (A) to multiple separate bases. I hope this makes sense! Thank you so much!!

Over time our long text field with bullet points has evolved into 100+ lines and we're looking for a way to no longer add new bullets at the bottom of the field, but rather at the top. Hence the very logical question: on existing long text fields how could one "invert" the bullet points. As an example:Item 1Item 2Item 3Should become:Item 3Item 2Item 1I've tried to use the "LEN" formula but haven't been able to produce anything working. Many thanks,

I have a Date/Time field that feeds into a formula field to pull the date from it. It used to work perfectly well, now that I have added the time option to it as well though there is an issue with it sorted dates wrong. As an example I have a task that is listed with the date 1/19/2021 7:00pm but when I put it into the formula it reads it as 01/20/2021. If I change the time to 1/19/2021 7:00am it reads it as 01/19/2021. It does read the Date/Time correctly in Calendar view. Is there anything I can do to ensure it reads the Date/Time field correctly for the formula? It is important for grouping reasons. The formula I am currently using is: IF({Due On}=BLANK(), “N/A”, DATETIME_FORMAT({Due On}, ‘L’))

Hi everyone. I’m using some rollup fields in a way that is only really useful if I can automate the linking of new relevant records to that rollup field’s record. Right now, the automation simply overwrites the old record link, rather than adding an additional one. The link field is set to allow multiple linked records, and I can add multiple links manually. Is there a way to configure this in the update record action? I am stumped.

Hi, I am trying to create a formula to work out meal allocations for works at a festival site.Currently I have date fields for 'ARRIVAL DATE' & 'DEPARTURE DATE' and a field for 'DAYS ON SITE' which uses the formula DATETIME_DIFF({DEPARTURE DATE},{ARRIVAL DATE}, 'DAYS') to calculate the days that any given crew member will be on site. I use another field 'Crew Meals' with the formula SUM({DAYS ON SITE}*3)Through the actual show component of the event, we only feed crew members that are actively working ie audo / lighting operators. I have included a check box field 'SHOW CREW' for crew members to check if they work on the show. I would like to create a formula (potentially an extension of the 'CREW MEALS' formula) which takes into consideration the 'SHOW CREW' check box status.For example - departure date minus arrival date = days on site minus 4 days, if the check box is unchecked. ORdeparture date minus arrival date = days on site minus 0 days, if the check box is checke

Howdy yall, I am trying to do a simple math setup for a client. calls per hour, demos per hour, calls per demo... The issue I am running into is the math seems to be coming back wrong. I have tried a few different ways and still having issues. Here you can see the number not adding up. In this case, we did 30 demos and had 19 families sign up. According to my calculator, I get 1.58 demos per family (30/19). However, I get 1.82 in the formula field. I have eliminated the infinity/NaN issues with the code in the pic that I found and edited. I will add that the rows the data is being pulled from are just normal number rows. I have tried different decimal sizes to see if it was a rounding issue, but it wasn't. Any advice or ideas would be awesome. 

A few days ago, I tried to help another Airtable enthusiast concerning a question about timelines. According to this community platform, I have written about  3250 posts since 2018, and despite my grandfatherly age, I recall one such post about Vega-Lite that would be perfect to help this customer.When a search engine believes you've made a mistake crafting your query, such as a misspelling, it tries to help. In this case, it demonstrates a significant degree of cluelessness.Did you mean: negative-lite ... Seriously? And what will this brilliant discovery engine tell me about "negative-lite"? Feel free to dive into that rabbit hole. We need to press on with a point to this post.Looking through all 42 pages of results did not contain the post I was looking for, but it did give me a few laughs like this one. It's entirely irrelevant to the query.The Khoros search engine has no idea that Vega-Lite is an entity, much less an Airtable extension. This says a great deal about the indexin