Solved

My records are created from automation, representing tasks that were started. I have a created date field that represents the start date of the task. I also have a single-select field that staff use to mark a task completed, among other statuses. I want to be able to know when the status has been marked completed and show that date as a record field so I can then compare and check if tasks are completed the same day they were started, and if not, how long they took to complete. I’m not even sure this can be done or if there are other ways to get to what I want but I appreciate any advice! Thank you!

I’m developing a real estate website focused on condo buildings in the Washington, DC metro area. I’m housing the data in AirTable and via Zapier, it will create/update pages in WordPress. Two of the tables I have are for [condo] Buildings and Metro [stations]. The Metro is the subway system in Washington, DC. There are roughly 2500 condo Buildings and 100 different Metro stations. A Building will be near zero or several Metro stations. In the Building table, there are 3 fields that contain the names of Metro stations that are: Field 1 - within a 1/4 mile Field 2 - between 1/4 to 1/2 mile Field 3 - between 1/2 to 1 mile Each of the fields can have 0 to several Metro station names. An example would this abbreviated record for the building Turnberry Tower: Building Name: Turnberry Tower Field 1: Rosslyn Field 2: Courthouse, Pentagon, Virginia Square Field 3: Metro Center, L’Enfant Plaza I would like to relate each Metro station name to the corresponding record in the Metro table. Do I ne

Hi I wanna script a (+1) button, somehow (like) button… to increase (or decrease) number in a filed For example, When I click this button, the filed X become (10) instead of (9) Thanks

Hello. I need to send, once every month, the attachment (it’s always a pdf) in a particular cell from all the records that appear in a particular view. I can’t seem to Integromat to find and send the Attachment file… Any help?

I run an acting school- and have a google drive folder full of about 1500 scripts. I’ve created an index of those files with links to them (in a google extension), then imported that list into airtable. We then went through and painstakingly added searchable info and a clickable button for each entry. So now we have a sharable view that students can search by age, gender, genre, etc. But we continually have new scripts coming in…and I’d love to skip the step of manually indexing the new scripts and pasting that into the airtable. Using a form is too tedious for each individual script we get in (cause it’s a lot) Is there a way to connect an airtable to Google Drive so that it automatically dynamically INDEXES a google drive folder (with LINKS to each individual file). That way when we get new script we could just drop them in the google folder (and add searchable data down the road into the proper airtable row) OR- is there an easy way to batch import FILES into an airtable (so that ea

I’m new to AirTable, but have been a FileMaker developer for many years, and I’m trying to figure out the AirTable way of doing things. I wrote a simple time tracking application and I would like to create invoice line items from each of the time slips. If I’m creating an invoice for a client, I want to find all of the time slips that haven’t been invoiced previously and create an invoice line item for each one of them. I realize that I could use the time slips table itself, but I might want to combine some, change descriptions or otherwise alter them and I want the invoice to be independent and “locked” after they are sent. I know how I would do this in FileMaker, but what is the best way to do this in AirTable. You can assume that each invoice line item would be filled with the Date Created, Customer, Product, Description and Time Worked.

Hi, I’m trying to build an app based on the To-do list tutorial (Airtable Blocks SDK) for the Blocks SDK. Whenever I try to show a value with record.getCellValueAsString(‘someFieldId’) I get the following error: Error: Cell values for field fldQYB8sxPz3dvhwH are not loaded spawnErrorWithOriginOmittedFromStackTrace@https://localhost:9000/__runFrame/bundle.js:619:13 invariant@https://localhost:9000/__runFrame/bundle.js:661:11 getCellValueAsString@https://localhost:9000/__runFrame/bundle.js:6185:34 Booking@https://localhost:9000/__runFrame/bundle.js:162:91 renderWithHooks@https://localhost:9000/__runFrame/bundle.js:62042:27 mountIndeterminateComponent@https://localhost:9000/__runFrame/bundle.js:64576:13 beginWork$1@https://localhost:9000/__runFrame/bundle.js:65944:16 callCallback@https://localhost:9000/__runFrame/bundle.js:46118:14 x.wrap/e._wrapped@https://cdnjs.cloudflare.com/ajax/libs/rollbar.js/1.9.0/rollbar.nojson.min.js:1:13806 invokeGuardedCallbackDev@https://localhost:9000/__runFr

I added a timer app to a table. Is there a way to attach it to a button in a grid view record to directly start the timer, instead of opening the app area, running the app and selecting the record? Thanks.

Dear fellow airtable wizards, Today my quest has put me up to a challenge I hope you guys can help me with. Short backstory: We offer courses which people can subscribe to (their record enters the base using forms) The first course starts the 3rd of January. Whenever they register we send them an email (using automations). In this email we confirm that the first course is on the 3rd of January. I came up with the following formula: IF(IS_BEFORE({Created time},{Start date}), DATETIME_FORMAT({Start date},‘DD MMMM’)) Now comes the tricky part… If a person registers a day after the 3rd of January, I want my formula to let them know their first course starts a week later (the 10th of January). If they register after the 10th, they start on the 17th… and so on. I’m looking for a formula that knows how far apart the {Created time} and the {Start date} is, so it can add 7 (or 14 or 21…etc.) days to the {Start date}. I know there’s an easy way of doing this by simply making a formula that tells

Hi everyone, I’m trying to write my first automation and could use your help with some basics. I need to use an automated script to modify multiple fields of the record and then I also need to take values to manipulate. The script below throws me the following error: TypeError: Invalid arguments passed to recordQueryResult.getRecord(recordId): • recordId should be a string, not undefined at main on line 4 I have an input variable defined: name: ID id: record (Step 1: Trigger) | Record ID Then my script looks like this: let table = base.getTable("Books"); let pitch = input.config; let allrecords = await seriesTable.selectRecordsAsync(); let record = await allrecords.getRecord(pitch.ID); await table.updateRecordAsync(record, { 'Status': 'Cancelled' }); let title = pitch.title;

Hello there, I’m building a base to manage activities. Table 1 is a registration form. Table 2 is the listing of activities with a rollup to track the number of person for each activity. I want to add a limit of person for each activity and block the activity in the form when limit is reach. Here’s a view :arrow_down: Anyone can help ?

Hello Everyone, I would like to create a formula that defines a range of dates depending on the due date within next Monday: as follows filter content that due date is coming on till next Mondy only then resets again on Tuesday and shows me what is coming till next Monday. Thank you Guys

Hi! I’m trying to see if there’s a way I can do this. I know Airtable is not a “spreadsheet” and that typically you cannot use different formulas per row/cell because of the database situation. I’m a complete newb to airtable, so I’m still learning the intricacies to see if it’s something I can use in my role. I’m putting together a checklist for a large event that has due dates- start and end dates included in the table. In my google form/excel sheet I have formulas created so that all I have to do is put in the first day of the actual event into a column, and then another column has the # of months, days or weeks out that we need to start working on that particular task for the event. I had to go in each cell to change the formula for the specific task for those that were 1+ months out vs. those that needed to be start 2 weeks out, etc. I’m using this formula in the column (the DATE and Project Start are the columns I’m having it pull data from): DATEADD(Date,-{Project Start (Months/

UPDATE: See my last post for the ultimate solution. I came up with some inadequate solutions earlier in the post, so save yourself some time if you are looking up how to generate random items from a linked field. EDIT: to make this more clear for future readers—I was trying to do this in an automation script. It worked as a script app in Airtable, though my final script below is much more performant. I make heavy use of scripting in Airtable, as well as the API, and I am pretty comfortable with using both, but this simple script is kicking my butt for some reason… it either hangs after running for 3000ms CPU time, or quits with an “unexpected error”. At one point it also threw a “syntax error”, even though there is no syntax error, and that error went away on its own without me changing anything. AFAIK there is no way to ‘select’ records with a filter in Airtable Scripts, before fetching them all, so you have to select the whole friggin’ table (even if it’s 6000 records), and then u

When a table is synced the field type of a formula is changed to long text (which makes sense). Is there also a way to change it to short text? Long Texts can’t be used in Pivot tables (but results of formulas can). Therefore I’m not able to create the same pivot table in the original and the synced table.

Hi Airtable Community, For a payroll automation base I’m developing, I need to figure out how to set a payroll date which will be 30 days after the first of the next month or the first of 2 months out, depending on net terms. For example, if someone logs time worked on 11/15/2020, and their payment terms are Net 30, the payment would be due to them by figuring out the first day of the next month, (12/1/2020), and adding 30 days which would be 12/31/2020. If someone logs time worked on 11/15/2020, and their payment terms are Net 60, the payment would be due to them by figuring out the first day of the next month, (12/1/2020), and adding 60 days which would be 1/30/2021 (or so I think). I’m trying to automate this calculation if possible. I’ve set up multiple calculation fields to take the number of the month, add 1, adjust if it’s past December. But then I have to address the year as well. So I wondered if there might be some kind of date formula to help with this, or if someone migh

Hello everyone, I am really enjoying Airtable, but I am running into an issue using the send Gmail email action with an image attachment inside an automation. When this email with image attachment is send, the image doesn’t show up as attachment, but a weird file-type does: These images in my base are just simple jpegs from around 350kb. When using the ‘Airtable send email’ action the attachments work fine, but I need to use gmail. Any help is super appreciated!

Hello All, As someone who knows nothing about JavaScript, I am trying to write a script that creates a one-to-many link between two tables. I found some code elsewhere on the forum and have modified it slightly. I have a “Facilities” table that lists out each facility from which we will be collecting data. I also have a “Results” table that has the results from all data collection at every facility. (This table is quite large and new records are added everyday.) The common link between these two tables is the Facility ID. I would like each Facility to have all their results linked (one-to-many relationship) in the “Facilities” table. Currently, I am able to run the following code and return a one-to-one link. I’m assuming that the output gets rewritten each times it goes through the FOR loop, resulting in only one output. Is there a way to modify the code to have it output multiple links instead of just one? Here is the code that I am using: //Define the Facilities table and que

Hi, I have searched around for someone with a similar problem but can’t find exactly my issue, perhaps someone can help. For work projects, we have an Airtable base to track the status and components of our collections (think fashion collection). Now, I want to track how long each collection dwells in each ‘status’ without having to input that information manually. We have a big team working together and each person will likely not remember every time to log how long they were working on their part of the project. We have a status table with a single select field with options like ‘design’, ‘marketing’, ‘graphics’, etc. I have a last modified field that tells us the last time the status field was changed. But I want a log of every time it was changed, and what it was changed to. I know I can look at the expanded record but that’s rather tedious. So I’ve created a linked table called ‘Status Time Log’. I’ve set up an automation that creates a new record in that table when the Status fie

As in, businesses X, Y, Z each have separate cards in my CRM, but are also owned by Alphabet (and this relationship is visible when I open my Account card for X or Y etc) Thanks a/Community!

Is it possible to update the lookup filed on a linked table via the API? I have a projects table. An a people table. O the projects table I have a lookup field that grabs the first name from the people table. Using the API, would I be able to change the name by simply updating the lookup field on the projects table? Thank you!

Hello! I am trying to use Zapier, to take information gathered from an AirTable form to create an outbound text message. I have everything working except for the use of the date / time in the outbound text due to the Airtable format of date time (2020-12-17T06:00:00.00). Is there a way to change the outbound formatting of the date time to something more legible? Thanks in advance, Jackson

I’ve noticed that when using .loadCSSFromString() the frontend renders multiple duplicates of the same <style>/<style> element in the DOM body. Is there a way around this that I’m missing? In the example below, .loadCSSFromString() is placed at top-level and not within a loop.

Good Evening, I must definitely use the “®” & “™” symbols in the text description of my products. I guess the property of my field should be RTF file. How should I do it? I also have a attached photo with my name (for example) that how I want to be done [I made it in Microsoft Word]. Thanks.

Got a newbie question for you. I’ve got 2 tables linked together: Viewers and Movies, through a field on Movies table called, “Fans”. I’m trying to look up the viewer of a movie and change their status to “Favorite” if it is currently “Watched”. let viewer = record.getCellValue("Viewers"); if {name: viewer[0].getCellValueAsString('Status')} == "Watched" { updateRecordAsync(writer[0], { 'Status': {name: 'Favorite'}; }) } The error gives me an unexpected token ‘{’, which I suspect isn’t the real problem. Any ideas here? Would love to get my first script block running!