Ask the Community

Hi! Below is a screenshot of what my current interface looks like, and the two fields in question are highlighted yellow.I thought these two fields would allow my team to add new contacts and update existing ones respectively. However, when this form is submitted, a new row is created regardless of which client option my team fills out. Rather than new information being linked to an existing client through the use of the drop down menu, a new row is created. Is there a way to make this distinct function for each of these fields?Thank you!

I have an unusual filter requirement. So how I need this to work is: I only need to go into the view on Mondays and Tuesdays. The data will be imported in every Tuesday. Once that data is imported I need to see data from the previous week, For example I import the data on April 23, 2024. Then I need to only see this data between April 16th - April 22nd Then when I look at the view on April 22nd I still need to see the 16th-22nd of April. So if I import the data on April 30th I will need to see records between April 23rd - April 29th. If I look at the view on May 29th I see the 23rd - 29th. Is this even possible? Or what is the best way to achieve this? 

Hello everyone!I'm looking to sell the tool that I created in Airtable as a subscription to other people. Or potentially as a one time sell.What would be a good way to make this available to them? I don't want others to be able to see the code that's the basis of the tool. I also don't want to pay a lot for each individual user (which I know some interface tools are expensive).What would be the best suggestion for this? Or is Airtable not the best platform for it?

Hi, I’m looking for a way to collaborate with a partner on a specific view on my table - but I don’t want to give them access to the whole table/other views and my entire base. I know that there is a “share view” button but that doesn’t let my partner put their own notes in. Am I missing something?

Hi Community,I am trying to create an automation to upload videos stored as an Airtable attachment directly to TikTok using make.com automation.I am running into a problem because TikTok is asking me to verify my URL prefix to prove that the source URL of the video is in fact a source owned by me. To do so, I need to upload a text doc to my server and then click verify on TikTok developer side. I have already created my app in tiktok developer, accessed the Client Key and Secret for API connection and linked it to my Make.com automations.My question is, what is the correct prefix URL that I should use given that there are multiple parameters in the download URL that Airtable provide? And, am I doing it correctly by just attaching TikTok's .txt document as an attachment in airtable field and then asking TikTok to verify the URL prefix?Example of my download URL (I've hidden some parts of URL for anonymity (N, M, W, X, Y, Z):https://v5.airtableusercontent.com/v3/u/NN/MM/WWWWW72000000/XXX

Is there any possible way to run Data Fetcher from the Interface?I have created a Button following this info https://help.datafetcher.com/advanced-options/run-request-from-button-field but this resides in the data which is not ideal. I want to be able to fetch the data on demand with the click of a button from the interface without ever opening the data. Is this possible

Hello wonderful AT folks,I'm trying to solve an issue in automations and am looking for help.I have a system where we need multiple users to review a document and then fill out a quick form to indicate their findings. The document record contains a multiselect field of all the users who need to perform this. I'm trying to create another multiselect user field of all the users who still need to complete it.What I have so far: an automation duplicates the users who "need to perform this" over to the "users who still need to do this" field.Next, when a review is entered in a linked table, a complex SUBSTITUTE formula removes that reviewer's name from the list of remaining reviewers. An automation then copies that formula result onto the "still needed" field in the Documents table. And that works!But, when the last reviewer is done, the automation refuses to copy the blank cell onto the multiselect field and errors out instead.So, I tried adding conditional logic. If there's anything in th

Hi, this is a Voiceflow specific question, but I was hoping someone might have some ideas.I'm making an API call from Voiceflow using a multiple filterbyFormula to exclude words. This is what it looks like:https://api.airtable.com/v0/appname/tablename?fields%5B%5D=Title&fields%5B%5D=Link&filterByFormula=AND(FIND(%22Long%22,%20%7BHair%20(Style,Color)%7D)%20%3E%200,%20FIND(%22Very%22,%20%7BHair%20(Style,Color)%7D)%20%3D%200 )The above works without issue. The problem is that my filterbyFormula changes often and needs to be contained within a variable so my actual call from Voiceflow looks like this:https://api.airtable.com/v0/appname/tablename?fields%5B%5D=Title&fields%5B%5D=Link&filterByFormula=AND({filter1 })This is working fine when I'm looking for a Match, i.e when {filter1} = FIND("Long", {Hair (Style,Color)})>0But if try for No match, i.e. when {filter1} = FIND("Very", {Hair (Style,Color)})=0, I get the INVALID_FILTER_BY_FORMULA error. So the problem se

I'm trying to use curly brackets to insert field content into a text box, but it shows up as "Course Name: {Course Name}" on the designed page instead of inserting information from the Course Name field. How can I make Page Designer recognize that that's a field name?

This is the image link I'm trying to use:<https://www.the-efa.org/wp-content/uploads/2018/04/Education-header.png>I can load it just fine in my web browser, but Page Designer says there's no image there. How do I fix this?

Hey guys,I am so excited about the updated Record Review layout, my team has been waiting for a way to filter and sort within the side record picker. I am trying to find a way to update my current record review layouts to use this new feature but can't seem to find a way. Is there a way to convert the old layouts? I don't want to have to rebuild my pages. Thanks!

Hi! I am using airtable to keep track of several types of info connected to individual clients. However, sometimes I need partners/spouses' names to be in the same column. Is there a way to write a formula that only runs when certain conditions are met?For example, as seen in the picture below, my current formula for IN PROGRESS: Client and Spouse column is {First Name (from Spouse/Partner)} & ' and ' & ({Full Name}) I would like that formula to run IF there is a spouse, and I would like the IN PROGRESS: Client and Spouse column to only populate info from the Full Name column if there is no spouse/partner.I tried writing IF statements, but I couldn't figure out.Thank you!

Hi everyone! I have an Airtable base for a virtual event my team is planning for Learning at Work Week. The base includes the following:An "Activities" table with all of the activities that learners can complete, each worth a certain point value. The people who have the most points at the end of the week win a prize! A form (linked here) where learners input their email address (their identifier) and can multi-select (via a lookup from the Activities table) the different activities they did during the week. The form can be submitted throughout the week as various activities are completed, or at the end of the week once all activities are done - it's the users' choice! A "Form Responses" table to store all form responses.A "Participants" table that is automated to create a record that links the users' email address to their form response(s) as they're submitted.Within the "Participants" table, I have a lookup field that lists all of the activities that that user logg

Hey, I'm getting a time limit error for the below script only for some records.  let table = base.getTable("Photos"); // Change "YourTableName" to your actual table namelet query = await table.selectRecordsAsync();// Object to hold the count of each Claim-Fault combinationlet counts = {};// First pass to count occurrencesfor (let record of query.records) {    let claimNumber = record.getCellValue("Claim Number");    let faultNumber = record.getCellValue("Fault No.");    let identifier = `${claimNumber}-${faultNumber}`;    if (counts[identifier]) {        counts[identifier].push(record.id);    

I hope I put this question in the correct area.I am developing a base to use for a contracting business, and I have a column for Distance Driven to job (to calculate fuel used in a different column)when I create the job for the client, it auto inputs the job address into a column, is there a way to have it auto calculate the distance to drive (by inputting my business address as always being the starting address, and the job address being the ending address?)Currently when I am creating the job for the client in the base, I have to open Google maps in a separate page, and input my business address and job address by hand, and manually transfer the number of miles into the base.There has to be a better way, right?

Hello all, I have a table to document my driving activity within my business. It has 3 colummns: Start adress End adress Distance from start to end adress. My question is: Is it possible to autopopulate the third column with the distance between 1. and 2. based on some automation/calculation/script etc. ? Thanks in advance!

I was thinking If this is possible. what if we keep our email user the same but just change the billing? Like, we could have our user account email as user.account@gmail.com, and for billing, we could use billing.account@gmail.com. What do you think?

Hello! Use Case: New Employees start at our company and we input a load of default events/meetings into their calendarsI manually input Start Dateand I want an automation/formula to inputDay 1 Start Start Date (ADD TIME 9am)Day 1 End Start Date(ADD TIME 5pm)Day 2 Start Start Date + 1 (ADD TIME 9am)Day 2 End Start Date +1 (ADD TIME 5pm)Making sure that Day is ALWAYS a weekday. Hope that makes sense, thanks!

I have a student financial table named OTA Financial where the OTA number and other information is manually added. That is synced with the Financial workspace tab in the student table. Then the students are connected through the OTA number in the main student table to import information from the OTA Financial.  I have spent several hours setting this up and connecting the OTA's.  They were working. Then the next time I go into the table it is not updating the financial workspace tab with the information that is listed in the OTA financial.  It is not letting me just sync the tables and I can't keep going over this and resetting it up every time I add a new person.  What the heck is going on and why does it not work over a period of days?

Hi there,I tried to empty the data in a certain view however that deleted all the information from the original base also. I am unable to undo the action, and when I look in the trash the information is not there either. The base still recognises that are 87 applicants from my application form, however there is no information in the base. I have also created a snapshot from yesterday, however since then more people have submitted an application form and so there is some data missing stillThanks in advance for any helpThanks in advance

I have a pie chart with a lot of values but a large quantity of them are '0' in certain slices of the data. Is there a way to hide/remove the '0' values from the legend?

Hi! I'm having trouble with a formula where it brings back text and adds " " when it is done. Here is the layout:Column 1: Formula cell with the following formula {Client} & ' - ' & {Total Volume}Column 2: Linked to another table, displays {Client} names (Example: John)Column 3: {Total Volume} quantity (Example: 10)What I want to get from this formula is = John - 10What I'm getting from this formula is = “John“ - 10Is this because I am linking to another table? It does not happen with every value from the {Client} column! 

Hi… I’m looking for a scripting solution that lets me auto-populate a field with a parent and child relationship. Eg - Column 1 has the children Column 2 has the parent of the child I’m wondering if I can write a script that can populate a new column with the tree hierarchy like this - wco:WC Interface → wco:Area → wco:Block → wco:Image Card → wco:Hero Image Card I have looked at a solution posted by joao_melo which works. But i’m wondering if this is doable in a script?

I have seen the same question asked elsewhere (link below) but it didn't really deal with another implication of combining a table and separating items by a type record.My question is, what is the best practice for setting up a contacts table in Airtable where those contacts could be clients or suppliers etc. If I was designing this in a traditional database my practice would be to make 1 contacts table and distinguish these by a field that indicates what type they are. The advantage is I dont need to maintain all of the different fields needed for a contact across multiple tables. The issue with doing this in airtable seems to be that I cannot easily create forms to add a contact or add a supplier (where the default values are hidden from the user) and as a result I cannot seem to trigger any automations from these actions. I dont want to spend time working on work arounds to achieve what I would like to do.So what do most developers do? Is there a best practice? Do you main

Hi all,This seems pretty basic but I can't get it to work after a day of researching and patching together example code I've found. I have no Javascript experience.I simply want to run a script that entirely clears the contents of a column. Here's what I have:  let subsTable = base.getTable('Sub Assemblies'); let clearQuery = await subsTable.selectRecordsAsync({ fields: [] }); function myObj(rec){return {'id':rec.id,'fields':{'BOM CREATE':""}}}; let updates=clearQuery.records.map(myObj); console.log('updates: ',updates[0].fields) while (updates.length > 0) { await subsTable.updateRecordsAsync(updates.slice(0, 50)); updates = updates.slice(50); }  The error I'm getting is: j: Error: Failed schema validation: <root> must be an arrayline: 2nd from last Any help appreciated!