Ask the Community

Hello,So I'm attempting to use this new feature, however I do not know how to undo the process.I have an already synced view going from one base to another and on another table I have a synced view going to that same base which contains a linked field. I decided to setup the Sync Linked Records feature and where it said, "Sync linked tables" I clicked in there and chose that already created synced view. However, I have changed my mind and do not want to Sync that linked field. I removed the synced view from that "Sync linked tables" and removed linked field from the synced view. Unfortunately, on the other base in Update sync configuration it is still showing that field even though it was removed from the synced view. Also It's still acting like a linked field even though I attempted to backtrack and undo the process. Is there anyway to remove the linked field from the sync?Sorry if this is all confusing, I'm just trying to now only learn a new process but also

Hey guys,I have a team that is using the comments in airtable for their communication, where they tag users and user groups. When they tag users the user gets an email notification, but when they are tagged through a user group they do not get an email notification. Is there a way to turn that on?As a side note, I feel that the comments section needs an overhaul in general.Thanks!

I am seeking to copy values from certain fields on one grid / table to another table. The fields names are different for most being copied over to the other table. I currently have automation triggers that send clients an email:1. Once we approve a song and send a welcome email (For clients we're onboarding for the first time)2. Once we approve a song intake (For clients we have been working with and we're accepting new material from)If possible once things are approved from either of these automations I would like to have an automation that sends the approved songs to our "Full Repped Catalog" table. That way we can have record of everything we represent. Is this possible to do?   

Hello, I have several different lead sources filtering onto a base. I have a TEAM of real estate agents that I would like to auto-assign to a lead in a round robin fashion so once all 9 agents receive a lead the first agent will receive a second lead. We have our incoming lead base synced up to receive lead data on via zapier but how would I add on the next agent in line? I believe once this is done I can set up a zapier integration that will notify each agent that a lead has been received… Please let me know if there is a solution or formula I can use! Thank you, John from San Antonio, TX

Hey everybody, I'm building a script using Airtable Scripting and I'm looking to reference/extract/use the contents of files in a file attachment field I have. If it matters, these files are mostly PDFs, and my field may contain more than one. I want to take the contents of the file, or in cases of multiple each file, and include that in the payload of a REST API call. Right now, I am totally unable to get to the contents of the file itself in Airtable Scripting.Has somebody done this before? Could you please help out?Best,Cam

Bonjour ,J'espère que vous allez bien.Je vous écris pour savoir comment effectuer un regroupement d'éléments dans une vue de liste (list view). Je voudrais regrouper les enregistrements par un champ spécifique pour mieux organiser et visualiser les données.Pourriez-vous m'indiquer la procédure à suivre pour appliquer cette fonctionnalité ?Je vous remercie d'avance pour votre aide.Cordialement,

All of automations have suddenly stopped working, while they test successfully. It's not about one automation, but for every and each automation in the base. The question is, what could be causing this problem, as everything worked perfectly until now.   

When I test my automations within the Automations tab they work fine. For some reason they are not working based on trigger on live tables. Please help this is a huge problem for us.

Airtable automations have stopped working altogether for me. The Automations worked perfectly fine uptil 27th of this month(Screenshot-1 attached) but all the of sudden it stopped working(Screenshot-2 attached). I have checked all the conditional formatting and also ran a test for automations and it works fine during test but it gives error in real time automations.  I have not changed anything in the automations and I have also checked that I have not ran over the automations run per month count but it stopped working for me. Is anyone else facing the same problem. Will be grateful if someone helps me sort it out 

I have 217 Universities in the table called "Universities"I have an empty "Applicant" table that connected to a Form InterfaceI want applicants to choose their universities NOT from a "Single select" field, but "link to another table"But when the University field in Applicant table is "link to another record field", in the form interface, it says "Invalid Size". But if the field is single select, there is no such error.Please don't tell me use Single select instead. I need the other informations in the Universities table + other tables are connected to University table from different places. I also know that I can connect Universities later manually or with some automations. Yet still that is not an option and just a silly labor. We were using this future with ourselves and clients for years and it was working perfect in "form view", i thought "form interface" should have been better.

Hello everyone,I did a trigger "When record is created" and script action where i want to get the record id to be able to update the record and all stuff. To do it, I'm using input.config() but not doing well in input variables. As shown in the picture, I've created an input variable named recordId and the value should let me choose something like "Record (from step 1)" that should be the record id of the trigger. I've never used this before and I'm a bit lost. Thank you all in advance.  

We're currently using Airtable for resource management and planning in our agency. We break work items down into 'tasks' which our team work on and we estimate time before it starts. I want people, to easily be able to track the time taken against those tasks, as well as (if possible, and easily) other tasks which don't exist at the moment in the system.I have a field for time tracking (see attached) but it's a single field and as such not great for adding multiple entries for a single task which might span multiple days and so on. Plus it's only goof for if the task already exists vs. people being asked to work on stuff that isn't in the planning system yet. Not sure if I should try and build something into Airtable but it means replicating functionality of time tracking apps which already exist or if I should try and integrate. I have looked at toggl and harvest so far but neither seems perfect in trying to map a good workflow in those systems based on my Airtab

Not sure if this the right sub-forum to ask (or if this belongs to base design), but I do have a problem. Context is I am making a HR Leave Management System for my team and am trying to calculate Hospitalisation Leave. It is different from leaves like annual leaves where it is based on the years of service and that it resets every year. The way this leave is calculated is if you are entitled 2 hospitalisation leave for every month you have worked in the first year, and 4 hospitalisation leave every month after the 12th month(from the 13th month onwards), with a cap of 120 days of hospitalisation leave. I can easily count how many days each employee currently are entitled with these 2 formulae in 2 different fields: To calculate the amount of hospitalisation leave IF({Number of months} <= 12, {Number of months}*2, IF({Number of months} > 12, (({Number of months}-12)*4)+24, 0)) 120 days limit

HelloI am developing a Airtable Script and I am looking for extracting actual file object which is part of the attachment field in a table. I got the object using record.getCellValue("Attachment field"). This object has information like URL, Filename, MIME etc. But what I am looking for is to extract the actual object in the attachment field (this could be a JPG, TXT,PDF,video etc). I need to pass this object to be stored in the target system through API (Dropbox API). The upload API in the target is looking for an object which is stored in local system. As the object is in Airtable I am not sure how this can be passed to API.The API call is some thing like below-----------------------------------------------------------------------------------------------let dropboxEndpoint =

I changed a column in Airtable from text to a checkbox (I am filling in with TRUE/FALSE (all caps)). Now I get this when I try to insert: data: { error: { type: 'INVALID_VALUE_FOR_COLUMN', message: 'Field "Active" cannot accept the provided value' } } I have seen articles saying to add: "typecast": true but this does not work. I’m not sure that I’m adding after the right curly bracket, as none of the articles I read are explicit on this, other than ‘add “typecase”: true’ somewhere. I don’t know whether to add it after each fields entry like so, or somewhere else? { "fields": { "key": "value", "key": "value" }, "typecast": true }, It is obviously being added in the wrong place, I am getting: data: { error: { type: 'INVALID_REQUEST_BODY',

I have a table that includes a single line text field called 'Product Import' and a linked record called 'Product'. I use the CSV import extension to pull in a CSV in to this table and display the result on the Data view.When the import completes, the 'Product Import' field will have a value pulled from the CSV and if the primary field from the linked Product table matches, then this automatically links to the Product field (as image below).This shows the operator which products are already in the database and they can add the missing entries in the Product field by adding them through this screen, or going to a Product table view and adding them.My difficulty is that I cannot get this view (with the found/not found matches) to refresh. It only compares the fields on an import, not subsequently. Is there a way of doing this?

I can't understand....All my automations dont work automatically.Here is an example:Trigger:When an entry matches the condition.Completed search fieldsIf everything is valid, then update the field of another table.All the tests work, manually it updates the fields, but never automatically.I tried to change the trigger by:When an record is createdAt a certain timeNothing happens. It never fires.I have no errors in the tests, and I point out again, I have no errors, the entries were intentionally created in order to match to obtain a result.I deleted all the automations I had, completely recreated the tables to start from 0 in order to find why, well it's still the same. And the reslut of the test :

Hi community,I'm struggling to understand why this whatsoever perfectly working tiny piece of script stops doing so when (seemingly) the 'start' date and the 'end' date are not in the same month.I am rather new to Airtable script editor so I couldn't find a step-by-step run mode, or a variable value watcher, but it seems that the 'days' variable is not computed correctly when 'start' and 'end' belong to a different month (for instance, 2024-07-15 and 2024-08-07 - however works perfectly with 2024-07-15 and 2024-07-31, and then 2024-08-01 and 2024-08-07)... leading to not entering the 'for' loop at all.Any clue anyone? Many thanks in advance!  let table = base.getTable('Man.days'); let inputConfig = input.config(); const start = new Date(inputConfig.StartDate); const end = new Date(inputConfig.EndDate); const days = end.getDate() - start.getDate(); var date = start; for (let i = 0; i <= days; i++) { le

Hey All I have a template table with sample dates, this is a process our company uses over and over. I am looking for the easiest way, to keep all dates relative to each other the same, but just advance all of them 2 weeks, 3 weeks, 10 weeks, etc. the goal is to take the template created now, and not modify each record by adding the time manually and make mistakes, but to be able to advance all the dates forward at the same time and by the same amount. Also, is there any way while working with a gantt chart to click and select all records after a certain date and push them back a week or two? the goal of this is to be able to quickly adjust schedules in the event of a delay, ie, leave everything that is in the past as is, and ‘grab’ all future events and bump them back x amount. thank you

I'm trying to avoid having to add a view for each new coach in a coaching engagements base.  The filtered URL works beautifully in a browser, but when I add it to the embed code in the iframe, it gives me the airtable.com refused to connect message.<iframe class="airtable-embed" src="https://airtable.com/appNTRWwuGJYQDcYK/shrPcWPXGkhHeb30F/tbl38pqjIpX(rest of code hidden for privacy)&filterContains_Engagement=(First Name)+(Last Name)&filterIsAnyOf_Status=In+progress&filterIsAnyOf_Status=Awaiting+SOW&filterIsAnyOf_Status=Assigned&backgroundColor=blue&viewControls=off" frameborder="0" onmousewheel="" width="100%" height="1000" style="background: transparent; border: 1px solid #ccc;"></iframe>

I am strongly considering moving to a more expensive plan, but here are two issues that are making me question whether or not it is worth it:1. Whenever we go to create a new record in our base on a mobile device it often closes the record automatically before we have completed filling it out.  We end up with a bunch of stub records that I have to go and clean up on a regular basis.  This typically happens when we haven't been using the app, launch it, start to create a record, and then, it closes without warning.  It's almost like the app hasn't fully loaded and synced, but our use case typically involves getting a call, launching the app, entering the order, so it happens frequently.2. When we create records and add a start and end date, the view often shows an inaccurate date for one or both of the fields.  If we close the view/navigate out of the base and re-open the base, the data is usually correct, but it is confusing to enter data and see it

We currently are exploring if Airtable is suitable for us (small agency). As part of my investigation I ran into the upgrade options to 'Team plan'.While we only intend to have a very limited amount of editors/creators (max 3), but do like to added functionality of the Team plan, it seems impossible to reduce the amount of (6) seats in the Team plan.In my case, with 3 intended seats, I would pay minimal $40,-/seat/month (annually).How can I get a Team plan for 3 editors and unlimited commenters? Thanks for helping out 🙂  

Every time I try to add creator access to the new treasurer of our school society , it doesn't work. It makes the person have commenter access but then when I try to change it to creator under the drop down menu when you go to "manage access" it tells me there's an error (Error: pglpqKAGvjJY649Z1) and I should refresh the page (which doesn't work FYI). When I try to share a link instead , the new treasurer says that she either still can't access it or that it says there are too many people on the page already. (so I tried to delete some old collaborators off the page but it still doesn't work and still says there is too many people). How can the error be fixed and how can I share the page with creator status to the new treasurer and president of our society ?

Hi! I'm new to Airtable and I'm trying to create a dynamic data base. The goal here is to have a table with Clients info and then other tables that relate to the Clients info table. Let me explain it further: I have a table called Clients info but then I also have other tables such as Spaces (which offices they are renting and other information about these offices), Communication (social media profiles, presentations and others). I want for each record on the tables Spaces and Communication be related to the Client Info table records.How can I do that?Thanks!  

I am trying to extract the first 6 digits from a rollup so that the main column is automatically filled with the resulting ID, but when I use this formula, I get #ERROR in the fields.