Solved

Hello everyone, I’m new to Airtable and I’m struggling to come up with a formula that calculates the different scenarios in relation to the timeframes for the tasks to be performed. I would like to post a notice describing the situation in relation to the various remaining timeframes. I am here so far, but i have an error that prevent notices to be displayed and I am lost… : IF( Deadline = BLANK(), /* Deadline is not entered */ "To be planned...", /* Deadline is entered */ SWITCH( {End date} != BLANK(), DATETIME_DIFF( Deadline, {End date}, 'days' ) >= 0, "DEADLINE IS TODAY !", DATETIME_DIFF( Deadline, {End date}, 'days' ) < 0, DATETIME_DIFF({Délai}, TODAY(), 'days') & " DAYS LATE !"), DATETIME_DIFF( Deadline, {End date}, 'days' ) > 0, "Delivered on time" ) ) Can anyone help? I would be very grateful :grinning: Have a Good day ! Gad

Hello Airtable Community, I have a large base of recipes, each with a unique ID. I would like to be able to do a bulk search for several IDs at once, but I have not been able to find a way to do this. Is this even possible in Airtable, or do I need to search for each ID individually? Thank you! Leslie

I have a column for “Completed?” with a checkmark option. When this is checked, I’d like for that column (“When complete?”) to populate the time it was checked. I think I need to combine something like this: IF({Completed?} = 1, LAST_MODIFIED_TIME({Completed?})) with DATETIME_FORMAT(SET_TIMEZONE({Completed?}, ‘America/Chicago’)‘M/DD/YYYY h:mm’) but I’m not getting it to work the way I was hoping. Thanks in advance! Rachael

Hey everybody, If I have to use somet sensitive information in my code, like an API key, what’s the best way to do that? I could put it right into the code, but my block to be open source (for the hackathon), so…any advice? Cheers, Alec

I have 2 fields that both sum up strings of currency. One is the sum of services and the other s a sum of the money paid in. If they total to the same, then my drawer should be balanced. The sums are the same in both fields. Originally, I had an if formula that contained the same sum action that is in {Paid In} because I would rather use an IF formula to tell me if they are the same, rather than comparing the two myself. I thought they must not be the same, so I created the {Paid In} field to check. They are indeed balanced, but the formula does not recognize this as so. My formula: IF({Paid In}={Gross Income},“√”,“CHECK BALANCE”)

A major limitation of Airtable currently is the ability to generate useful notification emails. Looking though the list of scripts on “Built On Air”, I don’t see any scripts that send emails. Have any scripts been written related to sending notification emails? Is that possible? Thank you! Paul Warren

I have table with 3 fields name (lastname,firstname, email). id seems to be auto incremented in airtable. Now am trying to programmatically delete records but its not working here is the code //table.deleteRecordAsync(record); //table.deleteRecordsAsync([record1, record2]); 1.) delete records where id is = 1 import {initializeBlock, useBase, useRecords, createRecordAsync, updateRecordAsync, updateRecordsAsync, table} from '@airtable/blocks/ui'; import React from 'react'; import {base} from '@airtable/blocks'; const first_tab = base.getTableByNameIfExists('myfirst_table'); const ok = first_tab.deleteRecordsAsync({id: '1', fields: {'lastname': 'Carrots-2','firstname': 'joy-2', 'email': 'joy-2@gmail.com'}}); if(ok){ alert('records Deleted successfully'); } 2.) delete record where id is = 1 and email is = john@gmail.com const first_tab2= base.getTableByNameIfExists('second_table'); const ok = first_tab2.deleteRecordsAsync({id: '1', 'email': 'john@gmail.

Hi there! I’m trying to set up an GET function to pull data from Airtable into Dexter (chatbot) based on a user inputting their e-mail address. I’m not getting an error message, but the response is coming back as empty. Any idea what’s going wrong here? is the user e-mail variable. $ GET https://api.airtable.com/v0//Sheet&20Name/ {“headers”: {“Authorization”: "Bearer "},“body”: {“records”: {“filterByFormula”: “({Email Address} = ‘’)”}}} ${{records.fields.First%Name}} //The field value I am trying to pull from Airtable. Thanks!

HI! I’m concatenating a few name fields and have been running into what seems like a bug. An errant space shows up before the first field insert in some, but not all instances. Code: CONCATENATE("Set (",{Score Name}," + ",{Part Set Name},")") Output: Thoughts? Thanks –

Hi there, On the DevPost Contest summary, it mentioned “Need Inspiration? We highly recommend taking an idea from our list of use cases.” Is that “highly recommend” just in reference to getting inspiration, or were these use-cases identified as high-value asks that the team is keen to see implemented? Put another way, does implementing or not implementing the use cases outlined have an impact on the “User Impact” or other overall score criteria? Thanks for the clarification!

I have a table that keeps track of calls being made by volunteers. The base has 3 main tables: callers, people being called, and a call log where volunteers submit a form detailing their calls (the tables are all linked). The call log form has a field where callers put “yes” if they reached the person and “no” if they did not reach the person. I want to create a view of the “people being called” table where there are only the people who have not been reached for all of the lates 3 calls. How can I do this? I know I could do rollup fields for the calls, and I have used this to keep track of when the last call was for each person, how many calls total, etc. But I am not sure how to keep track of the characteristics of the 3 latest calls.

I want to be able to take live notes during a video recording, and then be able to go back into the recording and find things easily. More specifically, imagine a user: Opens empty table Types text into record 1, time is noted in adjacent cell as 00:00 (mm:ss) [it takes them 5 seconds to do this] Types text into record 2, time is noted in adjacent cell as 00:05 (mm:ss) [it takes them 15 seconds to do this] Types text into record 3, time is noted in adjacent cell as 00:20 (mm:ss) And so on…

I have a table that is suppossed to create records for file attachment and other details. Juding from code below, How do I attach files along with other records in airtable. Do I have to convert the file to base64 or just upload the files to a remote server and then add the file links in the record. How does air table programmatically handle files attachments be it photos, pdf, videos etc. can someone help me out with the code below Thanks const files_tab = base.getTableByNameIfExists('myfiles_table'); const ok = files_tab.createRecordAsync({'title': 'file title','description': 'file details', 'myfile': 'my file attachment goes here'});

I am probably overthinking this but I am new here and just want to start out using a basic monthly calendar to use for checking off tasks. Can someone direct me to what form to use? Thanks so much.

Hi! :wave: I am using the PUT version of the Airtable Update records API. I have four columns/fields, Name , Contact , Attachment Image & Active. Now I call the API to update just the Attachment Image column, with the below API body : It updates the Attachment Image field’s value successfully, but clears all other fields. The record snapshots (before and after) look like - Before - After - So, how can I make the API update that cell ONLY, and touch nothing else? I hope you understand my query - Any help is appreciated! :slightly_smiling_face: Thanks!

I’m trying to list all records using the Airtable API that have been updated in the last 24 hours. This job will run each day and check for the last modified column and if the date `IS_AFTER(TODAY()-1 DAY, TODAY()). I’m struggling with the syntax. Does anyone have any guidance on this?

Hey everybody! I’m starting development on a block for the hackathon – super exciting! I’m going to need to store a unique token for each user, because I’m going to need to do some OAuth in my block. I’m wondering the best approach to do this? I could store it in GlobalConfig, each token is accessible through the ID of the user, but I’m not sure about that. Any advice would be much appreciated! I noticed this is done the demo for blocks, by storing the Twilio ID and Secret, so I’m curious how it’s done there

Hello, I have a column that is called Contacts that lives in table Publications. In this column, each cell has one or multiple linked records that can be found in another table called Press & Media Contacts. A cell inside Contacts looks like this What I would like to do is to filter and select the rows that have a certain contact in, using the record id. The only way I could do this was to use filterByFormula and Name, not record id: "filterByFormula" => "FIND('Keith Shearin',Contacts)" What I would like to do is something like this: "filterByFormula" => "FIND('reclhWRUlh9q47Zfd',Contacts)" Where reclhWRUlh9q47Zfd is Keith Shearin record id. FIND is obviously not the proper way to do it since it finds a string inside a string. FIND(stringToFind, whereToSearch,[startFromPosition]))` Do you guys have any tips on how can I achieve this?

I have created two table first_table and second_table. Now I want to create records programmatically so I imported table, but its still displays errors TypeError: _ui.table is undefined [2]<@https://localhost:9000/__runFrame/bundle.js:83:12 o@https://localhost:9000/__runFrame/bundle.js:1:265 o/<@https://localhost:9000/__runFrame/bundle.js:1:316 runBlock@https://localhost:9000/__runFrame/bundle.js:29:33 e/<@https://static.airtable.com/js/by_sha/8f4b64fb/block_frame.js:1:2329961 r@https://static.airtable.com/js/lib/regenerator-runtime.min.js:1:160 L/<@https://static.airtable.com/js/lib/regenerator-runtime.min.js:4:58 D/</a[b]@https://static.airtable.com/js/lib/regenerator-runtime.min.js:1:339 F@https://static.airtable.com/js/by_sha/8f4b64fb/block_frame.js:1:2324534 a@https://static.airtable.com/js/by_sha/8f4b64fb/block_frame.js:1:2324738 Here is my coding so far import {initializeBlock, useBase, useRecords, createRecordAsync, table} from '@airtable/blocks/ui'; i

Can someone help me combine multiple roll-up fields into one? These fields are notes from another table. Instead of having multiple roll-up fields spreading across the projects table I’d like to combine them into 1 field. I’d like to add a “heading” of text in between each rollup to differentiate each note field. My current formula gives me an error. CONCATENATE("Incoming Request: " & {Incoming Request}& "\n" & "Contractor Notes: "{Contractor Notes}& "\n" &"Client Notes: " & {Client Notes}& "\n" &"Project Notes: " & {Project Notes}&"\n" &)

Are there any downside to enabling rich text in the long text field? Any implications for Zapier or Integromat integrations?

Hi, I need help with linking records with forms. I used this product last year to do exactly what I’m trying to do this year with no problems, but I am running into a problem now. I’m trying to make two different forms, and have information from the second form link to the first one. Specifically I would like the entrant’s email address to link to the first form. When I did this last year, the entrant had to fill out their email address on the second form, and then I went into the grid view and linked the records manually. This year, I can only find the option for the entrant to select their email address from the ones that are already listed on the first form. I’m using these forms for summer reading registration at the library where I work. We get about 700 kids registering every year. Allowing anyone with a link to the second form to see the email addresses of everyone who registered on the first form is not an option; it’s a giant invasion of privacy. Is there a way to link these f

Hi. Does anyone know if it’s possible to copy several attachments at once and then paste them across a select range of records in one go? Many thanks in advance! Katy

I am more familiar with join tables, SQL etc. I have 3 tables: “person”, “activity” and “activitylog” “activity log” is essentially a join table that stores the person ID and activity ID. I created two linked fields in the “activity log” table and AT created two fields for each: “ActivityID”, “ActivityID (From activity table)”, “personID”, and “PersonID (from person table”) I am updating the join table from Integromat and it works fine, but I don’t understand why AT creates two fields for a linked record? What I’m trying to accomplish: log all activities people do and issue rewards based on accomplishing ‘missions’ show me who has done what activities (and other aggregate reporting) This is super simple in my old world of SQL server stuff, but is there a reason why AT creates 2 fields, or am I not going about this the right way?

I like to integrate the airtable to my website and show it as announcement. I created api with POST. example https://sample.com/api/announcement I tried with zapier but i like to integrate within Airtable. please help me, Thanks in advance for your response.