Other Questions

To simplify the description… I have 1 table that has a field of a Linked record. I need a dead simple way for my teammates to know to Create a New Record. Idea: Create a button with a good label, that opens the new blank record in that Linked Record field. I haven’t found in any examples a way to open a blank/new record on a different table, that is linked to the record where you initiate the process. Please help. Thanks in advance. Dave

Hi- We’re trying to get Airtable to sort a list of records by the most recent linked record. Basically, we want Airtable to ‘understand’ dates in a linked record. Here’s the basic flow: One table we have is the ‘Sponsor’ (advertiser) who has purchased a ‘Sponsorship’ (advertisement) The ‘Sponsor’ is linked to every individual ‘Sponsorship’ that it has bought Each individual Sponsorship is its own record, with a Date field as the primary field in the linked Table What we want is for Airtable to know what date a Sponsor’s most recent Sponsorship ran (or, what is the latest date of a Sponsorship linked to a particular Sponsor) With this, we’d be able to allow our users to sort by Sponsors who’ve run an ad recently (say, in the last 30 days) The problem is that even though each Sponsor has all its Sponsorships linked to it, I don’t see any way to get Airtable to use the linked Sponsorship records to sort Sponsors. We’ve tried a Lookup field of the date of the Sponsorship, but Airtable tr

Hi Airtable Community, With sample scripts that I found here, I was able to create a script to duplicate a record, and I’ve set up the script to run on a button. [So, thank you for all those how-to scripting posts!!] However, I was hoping to be able to limit access to the button, so that only the right people could click and run the script. But, on the button field the option to set “Edit field permissions” is grayed out. I know I can hide the button from certain views, but my users do know how to copy a locked view and hide/show whatever fields they want in their personal or collaborative view. Is there another way to prohibit who can click a button, since field-level permissions are not an option? Thanks for any help provided.

Me again, still working on same database as Going mad trying to avoid duplicates with ARRAYUNIQUE. I’m trying to create a field that shows a date-ordered list of unique dates on which the items on the table are listed in a linked table. The rollup (or a lookup) works fine, and ARRAYUNIQUE() is doing its thing, however the result is a slightly strange, non-sequential order which I think might be related to the creation time of each record. Has anyone got any bright ideas of a workaround that might let me sort this into a sensible order?

Hello community, I’m using Zapier to send data from other apps to Airtable The zap starts with a CRM called Streak, it includes a variable “company helper” with value “Diamir” The Airtable action is writing “company helper” into the “company” field: The data in is correctly shown “Diamir”. But the data out becomes “recPLcGiYMFsYsWPT” Which equals FIT and not Diamir Can someone help illuminate me as to what may cause the difference between in and output? Thanks!

For example you send a form to a client, they complete, save and send the form back with only half the information. They are then able to revisit that same form link at a later stage and see the fields that they can then complete at that later point in time? Thanks Brian

Hi could I get some help. I’m going nowhere with IFs and the Date/Time functions. How do I get make this work to print a result if the DateCreated is 30+ days older than TODAY() Driving me mad thanks

I’m trying to bulk upload records from an excel file. the columns match. but whenever i finalize the upload, airtable creates my new records AND it also creates a boatload of blank records. this is particularly irritating because i am doing an initial upload of many records into a table that has automations that create records in a different table whenever records are created in the current table. so now i have to delete the blank records from the one table, and go delete the blank records from the other table too. is there a way to set limits on what airtable imports from excel? i assumed it would stop importing when there wasn’t data in the cells. but this is not the case.

I apologize if I missed this out there, but I tried searching for a similar answer but couldn’t find one that matched exactly or I could learn enough from. Unfortunately my knowledge of script language is borderline zero. High-level explanation: I have a multi-stage project process that I am starting to build in Airtable that I am curious if am automation is possible, where a button can automatically create tasks from templates as you work through a project. Details: Currently my process has 2 main components, the Submission/Review process and the Launch process, with a task table for each process linked respectively. The tables are laid out like this: Submission/Review Captures new requests from a form and has data fields for review steps Fields related to this automation: Vendor; single line text (primary field) Stage; single choice Assigned to; collaborator Stage tasks created; multi-select with same options as Stage Submission/Review Tasks Houses the standard tasks for each

If I am over my extensions limit, do I need to delete them from my dashboard, or can I simply disable them? I have some that I use very infrequently, but I’d like to keep them around if possible, enable them when I need them, and then disable again.

I seem to have access to a new feature that let’s me build a filter based on an exact linked record object. But the way I get access to it seems to be a bug. If I try to build a filter by chosing a linked record field, I only have the options of [‘contains’, ‘does not contain’, ‘is empty’, ‘is not empty’]. However if I start my filter on a different field type, such as a formula or text field, I can chose the filter option ‘is’. Once I have selected ‘is’, if I then change my filtered field back to a linked record, I have a new option to filter my linked records with ‘is exactly’, and I am presented with a standard lookup list to choose from. Unless I have missed something, this is a huge new feature that I can put to good use. I have added some screenshots, let me know if others have the same thing.

Hello everyone, I am having an issue with a pretty simple if statement with !=blank(): If({Date}=blank(), “Blank”, “Not blank”) - this returns “Blank” if the field is blank and “Not blank” if there is something is entered - as it should If({Date}!=blank(), “Blank”, “Not blank”) - this returns “Blank” no matter if the field is empty or not Am I missing something? Thanks, Jordan

Hi community! I am looking for a script to use within an automation that would create a new record in another table when a field in the original table meets a condition. Is anyone familiar with how to achieve that or can recommend another way to reach the same outcome? The purpose of this would be to identify the necessary workflows in one table and, once selected, trigger the workflow to kick off in another table. Thank you in advance!

Anyone else that is using web clipper not working? Im getting "The clip action could not be loaded Please verify the app settings and try again." Seems to have started this morning when it changed form apps to extensions.

Hi, I have a list of Jewelry Stores that contains all the pertinent information about the store and also my contact at the store. I have imported this list into a table but would now like to create a separate table for just my contact at the store so that i can put more information (email, cell, social media). Is there a way to do this?

I have an needlessly complicated formula field that, despite my best efforts, still does not produce a result type as a date despite making every possible result return a date value. Here is my formula: IF({Date Sent to Captioning}=BLANK(),BLANK(), SWITCH( {Captioning Speed Requested}, '1 day', DATETIME_FORMAT(DATEADD({Date Sent to Captioning}, 1, 'days'), 'M/DD/YYYY') , '2 day', DATETIME_FORMAT(DATEADD({Date Sent to Captioning}, 2, 'days'), 'M/DD/YYYY') , '4 day', DATETIME_FORMAT(DATEADD({Date Sent to Captioning}, 4, 'days'), 'M/DD/YYYY'), BLANK() ) ) Originally this was just a simple SWITCH formula to add a number of days to a date column based on three possible options from a single select column called “Captioning Speed Requested” with options for “1 day,” “2 day” and “4 day.” I want it to add 1, 2 and 4 to the date entered to have it automatically give me an ETA based on number of days selected. I had the remainder to return a BLANK() value to prevent an error from appearin

Hi everyone. I’m trying to follow this guide and I’m told to setup this script but Airtable is complaining about this fieldsToSend.forEach saying that forEach dosen’t exists on type string but I just copied it so it must work for him. Does anyone know? Here is the complet code // Get the airtabel webhook URL let webhook = ‘https://hook.eu1.make.com/uiob4x9vxuob2np2wwifebvlqfqenae4’; // Airtable script button name. let actionDescription = ‘Sending images to processing’; let tableName = ‘Test Make’ let fieldsToSend = ‘Brand’ let table = base.getTable(tableName); let record = await input.recordAsync(actionDescription,table); let queryParams = ‘/?id=$(record.id)’ if(fieldsToSend.length > 0){ function buildParams(fieldName) { let fieldValue = record.getCellValueAsString(fieldName) queryParams += ‘&${encodeURIComponent(fieldName)}=${encodeURIComponent(fieldValue)}’ } fieldsToSend.forEach(buildParams); } const returnedpayload = await fetch(‘${webhook}${queryParams}’); var payloadRespon

Newbie here (with the obligatory “newbie here” intro lol): I have a problem I can’t seem to solve despite reading multiple version of what I think are similar problems with solutions that don’t seem to work. I will try and describe what I have and what I want: I am an artist looking to track collectors and paintings. I have successfully created 2 bases: 1. Base 1, Artwork: This base contains 3 tables. Each table is a category of art. Each table contains title, price, availability (sold or not) etc. 2. Base 2, Clients & Collectors: 1 table with list of clients and fields that include name, address etc. Successfully implemented: The bases are synced. In base 1 of Artwork is has a table that is a shared view from the client base. In each art work table I have linked a corresponding client. So if I go to Base 1 Artwork, go to the Landscape table, go to a painting that is sold, I can see who the collector is. If I open a collectors record I can see all the paintings they have purchased

I feel like I’ve seen this in a number of videos, but have seen no explicit way to enable this, but I’m trying to have the labels in my timeline view track along the colour record as I’m scrolling. I’m not sure if I’ve disabled something, or if this requires actually setting up; but this function would help make my timelines a lot simpler and easier to read, if anyone can share some advise. See sample from the timeline tutorial video below.

Is there a way to disable commenting on records? For what we do, the comment feature is not needed, and we have instructed our users to use a field in the base called “Change Note” instead, as that ties in with our integrations through Zapier whereas the comments don’t and the comments also stay forever. However, our userbase is not exactly the best at following clear and explicit instructions. So I’m hoping there’s a way to make it so that we can disable commenting, thus eliminating the temptation to not follow instructions to use the “Change Note” field.

So I have a custom app I am using, written in swift. I am trying to add records to one of my tables. But after doing some debugging I found I was getting the error: “Access-Control-Allow-Origin” = “*”. I did some research and found out it was a CORS error. And some light research and I am not sure really how to go about fixing this.

Hello , I would like to thank you for the aluable documentation and tries in this community my Q is I have a salary of Resource ( 100 $ ) assigned to tasks ( Y - Z ) by Y 60% , Z 40% Resource salary VARY every month ( Jan 100$ , Feb 120 , etc… ) so task Y cost 60$ , Task Z cost me 40$ tasks differ every month to month can be ( Y - Z - M - N ) this is called ( an Allocation ) of the Resources $ salary to the tasks how can I record the allocation process to Tasks ( Y - Z - M - N ) taking the monthly vary into consideration ?

I have a database connected to Jotform and one of the questions on the form is a multi-select field that captures the user’s selection and this is then pushed into Airtable multi-select field. I need to split this field into separate columns. Ie: Col 1: Job category 1 | Col 2: Job category 2 | Col 3: Job category 3 (Selection will be limited to 3) I’ve tried searching for a formula or solution anywhere that would split the selection into separate columns but I can’t seem to find one that fits my goal? Is there a way to do this in Airtable or via Make (Integromat)? Any help would be greatly appreciated! And apologies if this has been posted before :slightly_smiling_face:

Hello. Please tell me about the green and red lines that appear when I open a record. I have an automation using webhook to get the information into Airtable when an appointment is made from the booking calendar. The text information of the booking details goes into one cell which is comma separated. (Automation up to this point) I then add a comma-separated formula to put the information into the other cells. However, even though I have not changed the formulas, I am getting an error that the commas are mysteriously delimited. When I check the difference, there is now a hyphen with a red line where there was not before, as shown in the screenshot. I don’t know why this is there. I would appreciate it if you could tell me.

Hi I have a form that users fill in for feedback of courses attended. In the form they can choose their name from a linked record in the table. I don’t mind them seeing other member of the course in the list as they have been with them on the course. The problem is that, because this is a linked record it shows other details i.e email addresses . How can I hide the other fields? i’m not sure where it;s reading from as I have set up a view and removed all other fields but it doesn’t change it