Ask the Community

Hello Community,I've made a script in an automation and some part of it doesn't execute and I can't figure out why.In the script below, the "if" test is pulled so I can't find "11-OK" in log but directly "13-END" (I've put an always true condition only for testing purpose). Could somebody tell me why ?Thanks in advancelet clientTarget = "";let salonTarget = "";let totalCommandes = 0;let inputConfig = input.config();let subtotal = inputConfig["subtotal"];console.log("1-subtotal: " + subtotal);let total = inputConfig["total"];console.log("2-total: " + total);let client = String(inputConfig["client"]);console.log("3-client: " + client);let salon = String(inputConfig["salon"]);console.log("4-salon: " + salon);let table = base.getTable('Client-Salon');let query = await table.selectRecordsAsync({fields: ['Client', 'Salon', 'Total Commandes']});console.log("5-query:" + query);for (let record of query.records) {console.log("6-record: " + record);let ojbClientTarget = record.getCellValue('Clien

Hi. Im having two issues with automations. Thanks in advance for any help - Michael1. My automations only run when a new or matching record is submitted through a form. If I do so on the table itself which the trigger is set up to monitor for either matching or new records, the automation doesn't run. Am unclear why?2. My automations for matching records will only run on new matching records (submitted through a form) and not on all the matching records on the table. What do I need to adjust? Thanks again!

I don't understand why this formula isn't working ... I can only think it has something to do with the Now() calculation.IF({Quote Status}="Selected" And(Now()) > {Scheduled Date},     {Scheduled Date},     IF({Quote Status} = "Fulfilled",          {Adj. Fulfilled Date},          {Dummy Date})   ) Any thoughts?  

I have a field with a formula that calculates total days using this formula: IF({Status 📝}="Unassigned", WORKDAY_DIFF({Create Date},TODAY(),'2023-09-04'), "N/A")The formula works, but returns results of 1, 2, 3 etc., which when i try to use this column in a graph it does not sort correctly.  I need the results to be 01, 02, 03 to be able to sort in ascending or descending order or I need a field that reads the formula field and converts it to a number that can be sorted. Any suggestions are appreciated. 

I'm not exactly sure on the best way to go about doing this or if I am posting this in the correct location. I want to send a text message to a group of employees about upcoming open shifts. I have the employees in a table and i have the upcoming shifts in another. I am able to text individual employees a standard message now. I am not sure how i can add the open shift date to the message and then pick which employees i want to send the message to and have the date added into it as well. The employee table and the shifts tables are linked. Right now i am able to send the message with an automation that is sent by a button in an interface I created. maybe it isn't possible or maybe its super easy and i am overthinking it. Thanks for any help in advance!

It'd be nice if we could put a photo in base's appearance, although airtable offers several options, we could have more personalized bases, making it easier to identify each one  

Hi everyone,I'm very new to Airtable and I'm trying to get an automation to check a column called "Vehicle Registration" and a column called "VIN No" and if either of these two columns match with an older record, both the new record and the old record are either highlighted as duplicates, or a column with a checkbox is automatically ticked to show it's a duplicate record.What would be the best way to go about this?Thanks in advance.

I would like to disconnect the general Slack Notifications from a base — the one that posts messages to a Slack channel whenever a base is updated, not a custom automation. I can't figure out how to disable the connection; when I click on "All Slack notification rules" the page comes up empty.

I have a table called "companies" that is linked to another table called "deals" where 1 company can have many deals.  On the companies table, I have a roll up called "latest deal", that takes the max deal start date from the deals that the company is linked to.  This all works great.Now I have a sync from the companies table to another base which tracks a project status for each company.  The "latest deal" field is sync'd in this new base.I noticed today that I had a deal start date (in my original base) change from 2020-01-15 to 2020-01-14.  This updated the roll-up in the companies table of the original base but did not trigger a sync to the new base.  And when I manually triggered the sync, it still didn't update to the new date.The only way I could get the update to sync across was by temporarily changing my roll-up formula in the original base from max(values) to min(values) and then back to max(values)!Has anyone else experienced this issue with value ch

Is there a way to sort the contents of a cell alphabetically? If I create a cell that is gathering data from other sources (linked file, concatenated), can I then take that data and arrange it alphabetically? I'm struggling to find anything that works with the data in a single cell.Thank you for any tips you might have!

Hi!Is there any easy way to add a unit to the number field?I have a lot of tables with dimensions. Some of them are metric, some imperial.I want to show them as:0,234 => 0,234 mmor0,234 => 0,234"Of course without changing numbers to texts - because I do a few calculations on them. Let's say "just view"Thanks for the help,if this is something easy and obvious  - sorry I'm a newbie 🙂regardstomek

I have set up an automation to send client creatives for approval, which allows them to update the database with either an 'approved' or 'denied' status. However, it appears that they need to create an account to do so. Is there a way for them to approve without having to create an account? Thank you. 

Getting a lot of issues with scripts starting today, that previously worked fine.  All having JSON issues with webhooks received.  This is an error from a script that is run from a webhook that is hooked up to a button in an interface. SyntaxError: Unexpected token < in JSON at position 0at runWebhook on line 30 at async main on line 14 Anyone having issues with these starting today? EDIT: 6pm PST - seems to be working correctly now.  Must be some sort of back-end issue. Will post back if any other errors surface.

When you remove a collaborator who had already been added to a specific base, does it send them any notification (email, push notification, etc.) that they were removed? We're trying to tighten up our information security as our team grows, but don't want to unnecessarily alarm existing team members that they're being removed from bases which they weren't accessing regularly, if at all, in the first place.

Simply put, I cannot understand why my "listeCommandites" Array shows 20 elements before I loop through it and then the console.log(item) within the loop only iterates through 17 elements. Lines i'm talking about for console.log() are in the last code snippet. Here's a code sample:...  async function createOrUpdateCommandite(pPostId, pRecordID, nom, status, meta) { const headers = { 'Authorization': 'Basic ' + auth, 'Content-Type': 'application/json' }; const postData = { "title": nom, status, "meta": meta }; let response; try { if (pPostId) { // Update existing post response = await fetch(`${wpDomain}/wp-json/wp/v2/commanditaires/${pPostId}`, { method: 'POST', headers, body: JSON.stringify(postData) }); } else { // Create new post response = await fetch(`${wpDomain}/wp-json/wp/v2/commanditai

Help please! I cannot figure this out. (I thought I'd posted this earlier but it doesn't look like it went through....)I have about 5000 people in a base and I need to send individual emails to them, so 5000 email messages total. The emails will contain a link to a form prepopulated with a couple pieces of their individual info, and I need them to update their info using the form. I had everything working but apparently overlooked the possibility that somebody would limit the number of these emails that I can send. I don't know whether the problem is with Airtable, or Gmail. The Gmail account being used is a Workspace account (not a free Gmail.com account). What are the limits for this sort of thing and who are they imposed by? Is this something I just can't do? If so, what's my alternative? I need this ASAP so be grateful for any help. William

I have a table of Shows and a table of Contacts. There is a linked record field in Shows so that I can attach a Contact to a Show. When I choose a linked record from the Shows table, the record picker looks like this:I built an interface in Grid format that has the same linked field—adding a Contact to a Show. When I choose a linked record in the interface, the record picker looks like this: My question: Why does the record picker look different when using the same field? Can I get the interface picker to show the linked contact's email address in the picker (so somebody doesn't choose the wrong Contact)?

Hi.I have a large table with Approx 110 Fields, 90 Views, 6,500 records and a number of automations etc. The table was created using the Emailed Data Sync as its Source. I need to duplicate this table, delete the records and then start using a fresh set of records. I receive the below error when I go to duplicate, I can only assume due to the size of the Table. It says to contact Airtable if the error continues to occur, which it does. I contacted Airtable, only to get the automated 'Please look at the Help sections' or use the chat function, neither of which have worked for me.I have cleared my Cache as suggested by Airtable, but this doesn't resolve the issue. I can see that I can't toggle off the option to Dulipcate the Records when I go to dup. the table - this isn't an issue from myside, but maybe the number of records is causing it to fail?! Just wondering if anybody has any work around for being able to duplicate an Emailed Data Source table or any idea about the error. I r

Hey Everyone!One of our tables has maxed out on automations, so we've been using synced tables in another base to outsource some work to; we are routing client emails from there and have recently started noticing that when a user has not opened up that synced base for awhile and kept it active things are happening with a multiple hour delay.An old thread where another user had this issue had the following information from customer support:When the base is inactive the base will not sync. The base will sync as soon as a user access the base. One workaround to keep the base active without a user active in the base is to create an automation set to trigger at a scheduled time (when users are not active on the base). The automation can perform a simple action like checking or unchecking a checkbox field on a record. Doing this should keep the base active, and thus syncing, without an active user. I’ve passed along the feedback to the team to have this information reflected on our support a

I have a form that a member uses to search for their name using a lookup from another base. Because of PII Standards, I can't have their full name listed for others to also see. This basically works as a task tracker so (external) users have to enter their name and what they worked on.A) Is there a way where I can only show the first OR last name OR an abbreviation (John D.)? I have tried using the Regex formula which works (don't have split function), but that only helps me put the first name in another column and won't affect the lookup that is what members use when they open the form to search their name. The lookup is critical because it uses other values associated with their name that helps me in the form to track other things. Or....B) Is there a way so that when they search their name that it doesn't automatically list all the other names? This would be easily solved if the first column of the table that I'm using for a lookup would just show the first name instead of

I would like to know, if I am paying for team program in different account, does it applies also for the fact that if I changed the functions of airtable base for example one year ago, and need to put the airtable in original state which was one year ago, can airtable support make that copy of the base that was changed one year ago ?

Hello everyone!I'm new to AirTable but I have 20+ years of experience with SQL, but I'm stuck with the interface design here.I'm helping a friend setting up a project to keep track of orders and AirTable seems to be the perfect place.I have created a "product" table, an "order" table and a junction table "order_product" for the many-to-many relationship between them.Now I need to create a form or an interface to execute the following process:I need a page where I can choose the client for the order and add multiple products with quantityWhen the form is submitted it has to create a new record for the orderWhen the form is submitted it has to create a new record for each product in the order (linking the new order that has been created)Any idea on how to do that? Thank you so much in advance and greetings from Italy! 

Hey folks, just wanted to share that we created this pipeline which is free to use.It has schema inference and evolution, so the column names and data types will automatically be normalised to fit the destination and also adapt to any additions etc.you can configure it to load fully or incrementally.If you have feedback, please join our slack and discuss there or open a git issue. Pipeline docs: https://dlthub.com/docs/dlt-ecosystem/verified-sources/airtableour slack: https://join.slack.com/t/dlthub-community/shared_invite/zt-1slox199h-HAE7EQoXmstkP_bTqal65g

Greetings to all,I'm looking for an efficient solution to a problem concerning the organization of my to-do list for different events during the year.We've drawn up a list of tasks (110) to be repeated at each event.I'm facing 2 issues:1 - When I create a list view, I link the tasks with the event; the task remains a single record, so if I validate a task for an event, the task will be validated for ALL events. It doesn't matter what the hierarchy of my list is (or did I misunderstand?).2 - In a previous version with 89 tasks, I was able to get around this issue with record templates. When we decided to take part in an event, the 89 records were created, and then I pressed a button to launch several automations linking the new records to the congress. Not the most refined method, but it worked very well. Problem: record templates are limited to 100 records per base.I'd like to avoid recreating a table for each event to keep a clean AirTable base. If possible, have one event table, one

Hi, im trying to create an automation that will move data from a field with a formula to another tab whenever a trigger is activated, but for some reason, i get this error - “Fields” could not be converted to a string. can somebody help solve the mystery? Thanks, Liran