Other Questions

Hi everyone! Newbie to anything this technologically advanced and have no idea what I am doing LOL. I am using the Airtable “Create Scripts for Multiple Templates” script, but I don’t need the “Type” table. Is there anyone here who can educate me on how to edit the script so it doesn’t include any reference to the “Type” table and still runs through what I need it to? Thank you in advance!

Why emailed data only for Enterprise plan?

Hi, I’ve looked at the online tutorials and for some reason I’m doing something wrong! I need to link numerous sheets into one master sheet. The master sheet needs to link individuals by surname and email to avoid duplication. I run a non for profit and we have so much data and so much duplication and I just need everything on one sheet. I’m now getting really confused as its not linking things but is adding a link name to a form. Can someone explain how I do this in a really straightforward clear way?! Thanks!

If I currently am using the 5 free collaborators on the free plan and need to add a 6th collaborator how much will I be charged on the pro plan? (1 seat, with the 5 free collaborators still free or 6 seats for each of the 6 collaborators? )

Curious if there is a way or a work around to conditionally display two different buttons. Use case: Different roles/jobs (each is a record) that are open for applicants at different times. Want to gallery view all roles/jobs, and display a “learn more” button that would take user to a job description page, but would like that button to be an “apply now” button that takes user to the application form for jobs/roles on which we’re currently accepting applications. My first thought was create two button fields and then have a formula field that would pull apply now button in if applications open and pull learn more button in if applications are not open for that role/job/record. It pulls the URL but doesn’t pull the button. Any thoughts? I wasn’t sure if you could write a conditional in the Label field of the field settings for a Button or if you could even reference another field as the Label… Also wasn’t sure if there’s a better way to reference the data in the field of the record

I have created a two-question survey. One question asks the respondent to pick their top three options out of six and the other question asked them to select their top four out of 16 options. I’d love to limit to the three or four, but I’m pretty sure that capability isn’t there. MY PRIMARY CHALLENGE AND QUESTION IS: Some of the options to select are longer, and part of the sentence gets cut off when you view them on the survey instrument. Is there a way to change that???

Hello! I am working on a project that collects data from multiple areas (collect sequentially), and I am tracking the percent complete each area is. I want to make a pie chart that shows the percent complete of each area over the entire project. (For example, 10 Areas and each area varies between 0 and 100%). Thank you!

Hello! I have a submission table that lists dates of a submission and an associated “office” to each submission. I also have an Office tab that takes all the submission data with other rollups. There can be multiple submissions a day to the same or multiple offices. I want to use a rollup to gather the number of missing dates from a specified project start date (in this case 3/28/2022) as these would be weather or maintenance delays (and I’m trying to see if there is a formula that will automatically calculate this). Thank you!

I have a fetch that calls an API and adds all of the records to my table (Title, Date, Unique ID). That is good. Now when I make another call to the API I want to run thought the existing field, match the Unique ID and update the name and date (does not matter if they are different) and if there is no record with that Unique ID add the Title, Date and Unique ID to the end of the records. let response = await remoteFetchAsync("URL", requestOptions); let json = await response.json(); let table = base.getTable("Table"); let titleColumn = table.getField("Title") for (i=0; i < json.length; i++) { if(json[0].Title !== titleColumn){ let recordId = await table.createRecordAsync({ "Title": json[i].Title, "Date": json[i].Date, "Unique ID": json[i].uniqueID }) } }; Thanks!

Hello! I have a submission table that lists dates of a submission and an associated “office” to each submission. There can be multiple submissions a day to the same or multiple offices. I want to use a rollup to gather the number of unique dates per office, so that I have a calculation of the total days of submissions associated with each office. Is this possible? Thank you!

Hi guys, Would appreciate your help, I’d like to know how I can establish a particular row in a table as the parent row, and rows below it as children, (so that I can hide/unhide the children rows as needed). So for example, row #1 is a city name, and rows 2-5 are town names within that city. At the moment, I can’t seem to establish row 1 (the city name) as a subheading on its own, such that I can then set rows 2-5 (town names) as rows within that subheading’s umbrella. Please let me know if there’s a way to achieve this? TIA, Gennady.

I have a column that is a checkbox and would like to start capturing unique ID’s in numerical order (i.e. Autonumber) for records that have a tick in that checkbox. Is this possible?

I’m contemplating moving from WordPress to Airtable, where I would spit out posts via the API (not with Webflow on the end of it). Of the many things I’m trying to wrap my head around… How would article bodies function, from a formatting perspective? Unlike highly field-driven CMS work, articles are not discretely formatted. That is, article bodies contain a variety of text formatting originally created at the user discretion, inside WordPress’ TinyMCE editor - ie. crossheads of different h-tag sizes, links, images etc. WordPress stores the post body as HTML in MySQL. These elements should be retained on the Airtable side. What are my options… ? Long Text field that just contains a load of HTML tags and becomes burdensome to actually write/edit into? I see the Long Text field accepts formatting, with some reference to Markdown. How is this actually stored? As Markdown/HTML/something else? If Markdown, maybe there’s a risk I will lose any non-MD-trasnslatable HTML elements, ie. iframes

HI - I created a lovely base. I imported a CVS file and it totally messed up the base. I tried UNDO several times to no avail. I tried to go to a snapshot but there was no earlier version of the file. What to do? HELP!!

HI THERE – I imported a list from an excel doc. The format was exactly the sane as the base. For some reason - the import didnt work probably and a lot of the entries are either blank or only have one category filled in, Basically - is there a way to delete an import to an exisiting base. I tried UNDO but it didnt work. THANKYOU

Hi there, I’m building an app separately and I’m using Airtable as my database. In my base, I have “categories”, “brands”, “products” and “inventory” tables, where the 4 tables have proper linked fields configured as one-to-many (inventory → products → brands → categories). I need to have an API that shows records from all 4 tables based on the linked fields and using filters. After reading different help topics, it seems that the way to do this is by creating view, but I understood that creating a view with linked fields is limited to maximum 2 tables (linked and linked to tables). How can I create a view (or an API) that retrieves data from all 4 tables? Your help is highly appreciated. Thanks Fouad

Hi everybody, I would like to create a column that displays an action when a date has reached a certain value. If the date field is 30/6/2022 the actionfield would read “GO”. So I tried IF(Date=“30/6/2022”, “GO”, BLANK()), but it wouldn’t work. IF(Date=Datetime_format(“30/6/2022”,‘D/M/YYYY’),“GO”,BLANK()). No result either. What am I doing wrong? The date field has an European Date format (D/M/YYYY). Thanks in advance!

We currently use Air Table to enter our customers purchase orders- creating Work Orders for our warehouse. Within that **Work Order, we enter date created, due date, and any "Stations (A,B,C,D,E) that each Work Order will need to get work completed at- along with some other details not relevant to this topic. What we need is a way utilizing Air Table to do the following- I need EACH Work Order # to show on the schedule for every day beginning with “Date Entered” and ending with “Date Due.” Also need each Work Order to show on the schedule as I stated above- for EACH “Station” (A,B,C,D,E) for each day beginning with “Date Entered” to “Date Due” For example- Work Order # 10000 entered on 5/1/2022- and due on 5/16/2022 - and will need work completed at Station A, Station D, and Station E.(For this example- assume there are 5 “Stations” A,B,C,D,E Work Order # 10001 entered on 5/1/2022 and due on 5/31/2022- for Stations A, C Work Order # 10002 entered on 5/2/2022 and due on 5/24/202

Hello Airtable Community! I am going to make this simple and sweet. Is there any way to accomplish what this article is doing, but instead of just updating the primary “Name” field, I can update a status? This may not be possible but I figured it was worth a shot. Airtable Support Use case: update records via a form This article is meant to give you an idea of how to work around a common request we see from Airtablets: updating a record that already exists in a base via a form submission. If you often find you... Our organization essentially has a lot of people outside of our admin team that we delegate the “status” of a particular project and need a way for them to update this status through a form submission and without having access to Airtable. Hope this makes sense. Thanks!

Hello- I saw this formula for creating SKU’s based off of Single Selects and codes: SWITCH( {Product Category}, “Mural”, “MUR”, “Magnets”, “MAG” ) & “-” & SWITCH( {Class}, “Economy”, “EC”, “Deluxe”, “DX”, “Premium”, “PM”, “Platinum”, “PT” ) & “-” & SWITCH( {Substrate}, “Canvas”, “CN”, “Wood”, “WD” ) & “-” & SUBSTITUTE({Size}, " x ", “”) & “-” & SUBSTITUTE({Product Name}, " ", “”) My Question is: Is there a way to not specifically call out the IF selected in the field types, basically what ever you select becomes the “CODE” - because I have thousands of selections that would not work here - would take me forever to write and I don’t want to have to add new ones as the new parts come in - make sense?

I started working on an Airtable Template and there was sample data in it. I didn’t realize I had to clear the sample data before using it. I did some manual deletions and then started entering new data. I then got a bunch of popups wizards to guide me through using it. I saw an option to Delete Sample Data. I clicked on that assuming it would only delete the sample data - not new data entered! It deleted everything. I’ve checked all the ways to restore (trash icon, snapshot, revision history, workspace trash) and it’s like the info never existed. Is there any way I can get this restored? Or do I have to start from scratch again :sob:

Hi ! We have a search app installed on a base, the app is configured to search accross 5 tables. When we search for “permis” (in French), the search return results for word starting with “perm” like “permanence” for instance, but that’s not relevant at all. Also, it only search content starting with the search keywords. For instance, if we search “entreprenariat”, it won’t return content with the words “l’entreprenariat”, again, that’s not relevant at all. Is there a way to know exactly the search rules for the app ? Or a way or another to configure the rules ? Because, as is, it’s quite useless… Thanks, Nicolas

Hi All, Is there a way to change the list order of users listed in a Collaborator Field? We have some users using a table more than others and would handy for them not to have to scroll or type their name’s in the list. Thanks, Andy

Hi, I have no coding experience, Im trying to run a Vlookup to search a value from a single select field (integrated from jotform) and bring a value from another table related to that value. Saw a script on youtube but won’t work, the only difference with the video is that the selectRecordsAsync is crossed out.

I have a base where we log samples into and out of our laboratory. Samples in and out are in separate tables. Samples out has a link to the corresponding sample in. In the samples out table I have a link field (multiple selection) to a separate table that lists the tests that are done on the samples that go out. We started with a simple multi select but changed to the current system so that we could associate more information with the list of tests (methods to be used, approved laboratories, levels of detection etc.). We have set up a second base where we record the various test results for each sample. We could do this in the original base but for various complicated reasons we need a separate base for this. Each time a new sample out record is added to the first base, the second base is updated with a new record, ready to record results against. I have put a lookup field into my second base to reproduce the information from the linked to tests field in the first table. So we can see