Other Questions

Is there any type of app or script I can do to create the ability to bulk select the options in a link to another record field? Also open to other suggestions on ways to do this! What I am trying to accomplish: Create a form view employees can use to build custom order forms for clients. We have around ~50 products that can go on this field Create a printable order form that includes only the products they selected The problem is currently can only pick one at a time, so it’s click, pick, click, pick. Takes way too long to make this worth it. At the least I’d like to set this field to automatically include all possible products, and that way they can remove the ones they don’t need.

I have a Zapier firing when a certain label is added in Evernote. I am able to get the record added correctly into Airtable. Inside the text of my Evernote, I have encoded who the note is about. Example below: <NAME: First Person, Second Person, Third Person> I have a formula that can find “<NAME:” and I can pull the correct list of names, comma separated string. However, I also have a contacts table with peoples first name. How can I get a column that has to be a formula (in order to pull the text) and get it linked to a Contact. The ultimate goal is to be able to have a view of my contacts and see what Evernotes were tagged to their name. Thanks!

We run a small medical practice with multiple therapists. We need to schedule each therapist a full days work. How can this be visualised in the calendar view? Ie, see more than one therapist diary at one time with his own work, that is not in conflict with other appointments? We would prefer to use Airtable functionalities instead of API’s or other integrations. Any help and suggestions will be greatly appreciated :blush: TIA

In my App (made with thunkable) I store all the used data in airtable tables. Concrete example: The main-table is the “tb.ITteam”. In this table I have a couple of usual fields like firstname, lastname, shortcut, etc. And I have some linked fields like function and group. Function is linked to table “tb.function”, group is linked to table “tb.group”. I use this method to ensure, that values in the fields function and group (in table tb.ITteam) are crosschecked for validity in tb.function and tb.group. Everything worked fine for about two weeks. Here is the block-snip where you can see how I read those fields: You can see (No. 1 & 2): these are the linked fields, all others are unlinked fields. Without me changing anything (neither in the app, nor in the tables) suddenly, my app hangs when reading 1 & 2. I am sure about this point, because a ran a test where I deactivated only the blocks 1 & 2 and everything ran fine (of course - without the values function and group). This

Hey All! I have 3x tables (W, X and Y) and each table has the same formula entered into a formula field called ‘Alias’. This ‘Alias’ field aggregates data from 3x other fields within the same table – where generally only 1x field will have data actually present. Let’s say the ‘Alias’ field in tables W, X and Y have data equal to ‘John Doe Ltd’. (It is possible that ‘John Doe Ltd’ will appear in some/all of the ‘Alias’ fields, in any/all of the 3x tables of W, X or Y). – In another table (Z), I have aggregated the ‘Alias’ fields (via an aggregator array) from tables W, X and Y to give a list of unique aliases in Z, from all 3x tables (W, X and Y). Next to each unique ‘Alias’ in Z, e.g., ‘John Doe Ltd’, I have a ‘Linked Field’ to retrieve an existing ‘Account Number’, from yet another table, call it table A. So let’s say the ‘Alias’ of ‘John Doe Ltd’ (in Z) is assigned the existing ‘Account Number’ of ‘JOHNDO’, what I THEN want to do, is enter this ‘Account Number’ [of ‘JOHNDO’] into a N

I have one base with multiple tables. Some of the tables have identical fields. How do I synchronize these fields across tables so that if I change the info in one field, it automatically updates it in the other table in the same named field? thanks.

Thanks in advance for this basic question. I could not find the answer thus the post. Imagine I have 2 tables (in the same base). Table 1 has 3 columns. col #1 has some key Col #2 is date col #3 has sale amount There would be multiple sales on same date. Table 2 has two column: Col #1 is the date Col #2 >>> I would like this to be the sum of all the sales in from Table 1. How do I link the two tables to get the sales summary. Thanks.

Hello, I have built a Airtable that some people have shown interest in. I want to sell them access and charge them through Stripe. How do I automate the access part based on their subscription? Like if the subscription status is active on Stripe then they should have access to it. And they should lose access once they have cancelled the subscription. I’m thinking of doing it with Zapier, is there any other solution? Thanks

Hello, I have created an scavenger hunt App where the users needs to find a checkpoint, when they find it the scan a QR code and the app sends to Airtable their unsername connected to the name of the check point found. Winner is the one which has most points in total (which means that they found more check points) here is how the table looks https://airtable.com/shrZkdykmqmIMHMAc My issue is when a user scans twice the same QR code which results in a double entry in the table. Is there a way to overwrite the data which are automatically sent to Airtable? or eventually an automatic way to delete double entries connected to a user? I am not so good with airtable, so it might be a super easy thing to solve, but I’m not able to figure it out… any help is greatly appreciated. Thanks.

Currently every morning at 4am, I have an email that gets sent to all my crew that are cleared for work that day (covid testing, etc.). Gmail is now sending me bounce backs because there are too many on that mass email. I am wondering how to integrate Zapier to send this email to everyone who is in a certain grid view, even if that means Zapier goes in and presses a sendgrid email button for everyone there, but I can’t quick figure how how. I’m trying to avoid making someone wake up at 4 am just to hit send on all these people every day.

Hi all, I’m diving into the wonderful world of Airtable scripting with a custom CSV import script that does some data interpretation and creates links to other tables. Starting point was the CSV import example. I managed to get that working and added more functionality. Now, I keep getting an error that I cannot seem to solve: But the editor shows no red markings, and the first line of my script is a comment! Here are the first few lines of my script: // Timesheet CSV importer by Emar Vegt output.text("Note: this script does not handle duplicates yet. You'll have to sort them out yourself."); // Ask the user to import a CSV file containing a header row let csvFileResult = await input.fileAsync( 'Upload a timesheet CSV file', {allowedFileTypes: ['.csv'], hasHeaderRow: true} ); // The file importer will automatically parse contents for many file types, including CSV files let csv_rows = csvFileResult.parsedContents; // Edit this to the name of a table in your base let timeshe

I’m wondering if anyone has thoughts on this problem. I’m currently using a WORKDAY formula to calculate the due date of project from the ordering date. However, if the deliverable is ordered after a certain time of day, let’s say noon, I don’t want the calculation to start until the following business day. In other words, I want it to calculate only full business days. Anyone have any ideas on how this could be accomplished? Thanks in advance!

Hi - I’m new to Airtable. When one of my team chooses a filter while I’m using Airtable I can see it happening live on my screen and it overrides what I am doing. Is there any way around that? Thanks

I simply want to delete a record in grid view. If I understand correctly the only way to do this is to right click on the record and select ‘Delete Record’ (as a side note, wouldn’t it be better to have a delete button ?) When I right-click I get chrome right-click menu together with Airtable right-click menu which is confusing and I assume is a bug … what is needed is for Airtable right-click menu only. See picture below:

Hi I create new records in Airtable via the API with integromat. As part of the payload I send a id which is numerical, however when I receive the response back from airtable, the id is displayed as alphanumeric. The same happens when I send an api request for records, the id is also displayed as alphanumeric - I have to see the id as a number Please assist Thanks Jaco

Hello, I have lots of tabs for different locations of a tour plus a tab for tasks. In each location table I can see all my tasks associated with each record of the project. However once a task is completed I want to be able to hide it from the table view. Basically I want it to be clear at a glance where there is work to do in each location. I have worked out how to filter tasks by their status in the Task tab but seem to be unable to do so in the other tables. When I click ‘Filter’ then ‘Tasks’ the options reduce down to only: Contains, Does not contain, Empty, Is not empty. When I type Completed nothing happens. Any help would be much appreciated! Thank you

Hi this question should be very basic. I have a table with names, some content, and tags. The “tags” is linked to another table. I then added a new name on the first table, but on the linked “tags” table I don’t get the new name added to the primary table. I tried linking the primary table again into a new table, and sure enough the new name shows up. What did I do wrong? Primary table (first column name…the cell with “apologetics” is the tag column that was linked to second table called “Tags”. This row, with name “DeAnn” was added after the linked table was created. [The original linked table. In the second column only one other name “#1196652” was there, but the new row added (for DeAnn) was not updated in the linked table. [I created a new linked table after DeAnn was added, and the tag column apologetics has both the first name and the new name added.]

I searched through the help and FAQs but I don’t see a direct way to reach out to billing’s customer service. I have a credit that I’m supposed to receive that isn’t appearing on my account. How do I reach someone directly?

I currently have table from partner’s bases synced to my base. For some reason that we can’t work on same base. My ultimate goal is has a table can sync and update records from partner’s base and I also can add new records from my team. 'Cause I can’t add new records at original sync table so I think about create a new table can update all records from original sync table. But I can’t figure how it work.

Is there was a script I can use to erase all attachments in an attachment field with the click of a button or even with an automation?

I’ve read many posts where the issue is making auto-filled forms read-only. I have the opposite need: making then editable - I’m getting a form messages saying forms with private links only are editable when empty. I’m on the pro plan and the form uses a read-only view having a private link with a clickable URL button which opens the auto-filled form in read-only. I’d prefer to do this within AT using no external apps. Can this done, and if so what am I doing incorrectly. Thank you.

I have a base that includes a table (“table 1”) that contains links to a second table (“table 2”) that is synced to another base. The links in table 1 were cleared automatically. The history says “Table Sync updated this record”. I can’t figure out why this happened. Furthermore, I’ve shared table 1 with someone else and they can still see all the links. The links are cleared in my view, but not cleared in their view. This sounds like a bug to me. Can anyone explain what is going on and how I can get my data back? Thanks.

Hey all! I run a philanthropy/product brand in Montreal Canada. I have recently been using Airtable to build-out bases that correspond to different functional units of my company. The only thing missing for us is a task manager. I know there are simple to-do list templates offered by Airtable but none of them are having similar logging functions to Salesforce’s task management. I was hoping to create a task manager that can log tasks, notes, a specific contact from our CRM, and most importantly a date-log. I would like to be able to assign future dates to certain tasks so that when my employees and I come into work every day we can just look at “today’s tasks”. This would also be useful to view in an “upcoming tasks” and “past due tasks” view. Thanks in advance!!!

Hi people :slightly_smiling_face: I have quite a few automations running in my base and this is nothing that interests me in the revision history. Every time I want to check who has been updating a record, I have to work through a lot of automation-information in the history. Is there a way to exclude the automations in the revision history or to only include real creators? Thanks for help!

If you have ever wanted to run SQL queries on Airtable, like I have, then take a look at ZapQuery. Full disclosure, I created it, but it has a free mode and I would appreciate some feedback about whether it’s useful or not to anyone who is running Airtable for their business like we are. zapquery.com Home Page - ZapQuery Basically it allows you to run SQL on your airtable bases as if you were writing queries on SQL Server. You can join tables, sum, all the stuff you would want to do in SQL. It’s good for making reports. I used it to run reports and pipe it into zapier and email/text myself what’s happening in the data. It’s a great way to kind of build a mobile reporting system for your business and know what’s happening. For now, our zapier integration isn’t live because we don’t have enough running zaps, so if you want to pipe your query output into zapier, just email me @ support@zapquery.com and I will invite you with your email. I c