Other Questions

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

I’m using a Timesheets table to record employee timesheets. I’m then using an Employees table to rollup the ‘Time Worked’ durations. I only want to see the ‘Time Worked’ for today. I have my rollup conditions set as follows: “only show linked records from the Timesheets table that meet certain conditions: Date is today” However, I’m in Sydney Australia which is +10 hours GMT. I don’t see any way of offsetting this time (as it’s only a filter within a rollup field). How can I make the rollup filter ‘today’ line-up with Sydney’s ‘today’?

Hello- Is there a formula out there that if a cell is not blank or a specific option from a drop down is selected, a attachment is auto populated? Basically I need a static LOGO for my Interface Designer and right now the logo is dragged or added manually with each record in order for it to show at the top of my header. Thanks, SG

I’m wondering if it’s possible to create a field in a form that is “information only”. That is, it does not have a place for the user to reply or take action? e.g. I have created a registration form and I want to give some extra information about my event. But I do not need the user to choose an answer or give any input. I guess I am asking if there is something like a “null” field type.

Hello! I’m looking to create a “Daily Company Dollar Report” using interfaces. So far it’s been great showing projected and closed orders and revenue and popular servies… however, I just realized these will show “to date” records. We would like to look at this daily to see where we are for the month. Is there a way to filter the elements to show me records from x/1/2022 to x/31(28 or 30)/2022 to show THIS month’s status?? I see you can filter “in the past month” but if I’m on 6/15, that’ll show me data from 5/15-6/15 not 6/1-6/15. I don’t want to have to update the filter every month either… a “since beginning of the month” to “end of the month” would be GREAT, but I don’t see that filter or work around just yet. Thank you!

I’ve tried multiple times and I’m still stuck so I’m hoping this community can help. I have a bunch of tables in a base. The main one is called Leads & Clients. There is another called Waitlist which also has a form view. LC has a field called ‘status’ and Waitlist has a question asking ‘have we worked together before?’ I have it set up where a new form submission triggers an automation that creates a new client record in LC if one doesn’t already exist for that client or it just updates one that’s already there. And the automation links the two records across both forms. This is where I’m stuck… I want the status in LC to change to ‘lead’ if someone says no on the Waitlist form to the question asking if we’ve worked together before. Any insight?

Hi everyone, When looking at the data loaded by the airtable website, I see that at least a frame is loaded from Doubleclick.net: I’m surprised to have this advertising business loaded into a app like Airtable, which business model is not about personal data. Am I the only one concerned about this ? What is the doubleclick element purpose ? Thanks for your answers !

Hello Airtable Friends, Does anyone know how to have the actual ‘number of records’ amount show in the middle of the Donut chart block? I’ve attached a screen capture to illustrate where it states ‘Number of records’ but doesn’t show the total sum in the middle of the chart? Many thanks in advance. Cheers, Sam

Hi everyone! I am trying to create a formula to figure out an individual’s age when they graduated from our program. I have their date of birth and the graduation year.

Let’s say I have a form integration connection to Airtable. When someone submit the form, an array of product IDS will be inserted into the product_ids field like [3294239423, 3873298293] (a long text field). Is there a way to use this array to lookup for products, using those ids?

Hi There, Seeking some assistance on how to use the rollup function. I have two tables, one where all the actual data exist ie number of opportunities, one line per opportunity. Can be multiple in a single day. We have a status column to indicate what stage the opportunity is at and in this case i want to rollup status “funded” for a date range…for example month to date. I have setup a table that has my forecast and for each day what the running MTD target is. What i wish to do is measure for each day the difference between Actual funded for the MTD figure against the forecast for corresponding period. Example setup is attached but is showing zero so not working. Look forward to hear of solutions. Cheers

Hello! I run an auction house for a primarily text based MMORPG that’s PG-13 with the use of Airtable. Lately, we’ve received some submissions that are clearly meme/pranks. The problem is, that some of the material that have been submitted have involved nudity and acts that are lewd. Which breaks the rules of the auction house, as well as the MMORPG that the auction house is ran for (It’s the internet. Some players in the game are minors.). That being said, the staff for the game has asked that I grab the IP address of those that have submitted such images/content so that those users can be banned as appropriate by the game’s TOS. Is there a way for me to discover an IP address of the form submitter or figure out whom submitted what?