Solved

I’m importing a google spreadsheet of workers and their trades. The sheet has over 11,000 rows (each worker = 1 row). There are 40 trades. Each trade has its own column, and there is an “X” if the worker is skilled in that trade. I converted each “X” into the name of the trade that it represents. I now want to combine all of the columns for each worker into 1 multiple select field so that each worker has one field where it lists all of his/her trades. Any ideas?

I will want to possibly create several different lists so that they can be choices for different drop down fields. Thank you.

I am creating a Master Calendar & Team Calendar system in Airtable, where each calendar update automatically updates/creates based on an update in the other calendar. I put together a system that created a “Unique Event ID”, which is a shared ID for the same event across both Bases. Everything is working great so far, except that I would like to delete records automatically in one Base if the corresponding record is not found in the other. There’s no Delete trigger in Integromat, so my workaround is: -The trigger is an existing “Update Record” automation After that automation completes, the automation will do a scan on both Airtable Bases. Step 1: Search all existing records on Master Calendar Base (up to 10,000) Step 2: Search all existing records on Team Calendar (up to 10,000) Step 3: Filter, then Delete - If the Event ID is found on the Master Calendar Version but does not exist on the Team Calendar Version, Delete the record on the Team Calendar (up to 10,000) I’ve tried a f

I swear this must be really easy, in fact in excel it’s really easy what am I doing wrong :frowning: I have one sheet on there I have a variety of columns I want to create a column at the end that says how many out of columns xyz (which are all single line text columns) contain text - please can anyone help as 4 hours later a rabbit hole of videos and posts on here I still cannot get it to do anything - thank you in advance

Is there any way to create a read-only table view that can be accessed anonymously via the API? I just want to be able to do a simple table lookup/mapping (with a filter formula) with a front-end Javascript call without exposing an API key (or having to host a back-end script on a 3rd-party server). Alternatively, is it reasonable to create a “collaborator” account with read-only access and expose that account’s API key?

I have recently configured the Map block on a few tables with a total of couple of hundred rows between them. A few days later I checked my Google Developers console to see how my geocoding API key was faring, and I was shocked to see ~18,000 requests for that key. If I open a Map block and the associated table simultaneously, I can see the geocoding cache column get updated repeatedly as I interact with the map — even though no data in those rows is changing. The gif below shows cell updates being triggered just while viewing/panning/zooming the map… Then, if I open up one of records in question, I can see a bunch of changelog entries of the form: “User X edited this record using Map block Y”… Can anyone explain what’s going on here? I’d like to keep using the Map block, but not if it’s going to blow up my API quotas simply by viewing the maps :frowning:

What am I doing wrong? How do I as the owner, make it so multiple users (<10) are able to view/update the database at the same time?

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”)