Solved

This may be outright impossible based on how Airtable is designed to be purely dynamic however, I would love to know if anyone has any solutions. Here’s the Problem: I am using Airtable as a Series Bible for my Fantasy Book series. It is a massive world with many plots and subplots, characters, themes etc. As I am writing the scenes and beats, I’m noticing Airtable is not persistent with the sorting of its records. In other words, I set up a series of scenes, then I filter and sort. When I remove the filter and sort, the scenes are no longer in the order they were created. This is maddening, effectively removing the usefulness of Airtable due to it resorting all records. Furthermore, I am aware of ‘Autonumbering’, however this isn’t much use when you decide to re-organize scenes or add a scene in between two existing scenes. The numbering immediately becomes irrelevant. How can I maintain the order of my scenes and still use sorting, but rest knowing it will be restored to the default

Use SendGrid block to contact our members, great! But is it possible to schedule the start of sending? Met vriendelijke groeten, Geert Dornez

Hello, I am trying to gather information from my colleges on how they do specific tasks through out our building (some departments have the same tasks but are done differently, we are trying to accumulate all the data and compare). I have a grid view of all the tasks from all departments, but I am having trouble finding a way to track which department answers which questions and making sure that when a department does answer, the question can not be asked again (I do not want duplicate data if someone forgets that they already answered a previous question). Is there a conditional format I can use to accomplish this or will I need to find an external form builder? Thank you.

Hello everyone - Does anyone know how to send an email notification when an editable field within a record changes? I looked at Zapier and the only triggers are New Record or New Record In View. We have several scenarios where people want to be notified via email (not currently collaborators) when information changes. Many thanks for your insights and advice. Doug

Basicly everything is in the title. I have a checkbox filed that return null instead of false when not checked. Is that some normal behaviour ? am i missing something ? Here are some screenshots

Hello, I would like to be able to view various locations daily performance reports. Is it possible to have several different forms within one table and then create a view or report for each of the locations? I was thinking to create forms that can be completed for each location and then be able to view a report based on location or other criteria in the future.

Newbie trying to get my feet wet using a custom form to create new records. I am following the samples provided with the API documentation but the script completes before Airtable is able to finish it’s create function. I didn’t realize that was the problem until I threw in an alert() command to help me debug. That’s when the record would appear in my table. Looking forward to smacking my forehead when someone shows me some simple thing I am overlooking to stay in the script until Airtable is ready. Mahalo. (Hawaiian thank you ) <script src="https://code.jquery.com/jquery-1.12.2.min.js"></script> <script src="js/airtable.browser.js"></script> <script> $(document).ready(function(){ var Airtable = require('airtable'); var base = new Airtable({apiKey: 'keyXXXXXXXXXXXXXXX'}).base('appt4hr3kqdqXXXXX'); $('button#submit-bin').click(function() { base('Parchment').create( { "Tag": "3333", "bin#": 1 },

I’m trying to roll up a bunch of different dates. I need them comma separated in an array, so I later can replace the comma with a line break to display them on top of each other. I’ve tried with ARRAYUNIQUE(DATETIME_FORMAT(values, ‘DD-MM-YYYY’)) in my roll-up field However this only works if there is only one date, but when there is more dates then they return ERROR. Is there a way around this?

Hello Airtable Community. I’m actually not sure if the subject is the right for this question but it’s the closest I could think of. I created a formula field to autofill out instagram.com prior to a profile name to save me re-typing it every time. (Thanks to Scottsworld for helping me with that) "https://www.instagram.com" & {profilename} Is there a way to only show instagram.com if a profilename is not empty? ie nothing will show in the formula field if profilename is empty. Hope this makes sense!

Is it possible to hide fields in the expanded view? Right now the expanded views is totally unusable. We have over 100 fields in our table, but only need to see 6-10 in the expanded view. Is that possible? Thank you!

I do not see a way to add a time field, so someone can choose 7:00am or 9pm, etc.

I have table with 3 fields name(lastname,firstname, email). id seems to be auto incremented in airtable. Now am trying to update records where id is 1 with the code below but it displays error below here is the code I have table with 3 fields name(lastname,firstname, email). id seems to be auto incremented in airtable. Now am trying to update records where id is 1 with the code below but it displays error below here is the code 1.) update records where id is = 1 const first_update = base.getTableByNameIfExists('myfirst_table'); // Update cell values //{id: record1.id, fields: {'My field name': 'updated value 1'}}, const ok = first_update.updateRecordAsync({id: '1', fields: {'lastname': 'Carrots-2','firstname': 'joy-2', 'email': 'joy-2@gmail.com'}}); if(ok){ alert('records updated successfully'); } 2.) update record where id is = 1 and email is = john@gmail.com const first_update2= base.getTableByNameIfExists('second_table'); // Update cell values //{id: record1.id, fields:

I would like to lock the permissions of editing ‘duration field’ to creators and up (that is easy), but let editors to be able to include information there ONLY by using time tracker block. My goal is to lock to the possibility to change amount of time manually. So, I can use that time duration for billing purposes. However, the problem is: IF I set permission of editing for ‘creators and up’, Time Tracker block can’t be used by ‘editors’ (my general employees) IF I set permission of editing for ‘editors and up’, Time Tracker block can be used by ‘editors’ (my general employees), but they can ALSO change the amount of time of the duration field manually (non secure information). Does anyone know how to solve that situation?

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…