Solved

Hai everyone, how to write formula on primary key column to capture Recorded time. I know there is column with type created time, but for primary key I’m not using so I think will be better if use for recorded time but with formula Thank you

Hello All! Sorry for the extremely general topic… but I feel like I might be missing something… I have a team of employees and we work in a distribution business. I am trying to create a unified platform so that my employees can enter information regarding quotes and pricing. I am somewhat familiar with database structure, so the mechanics of creating the application are fairly clear to me. The piece that I feel I am missing is this: Is there a way to create a user-friendly input method without giving users access to all of the backend mechanics? My concern is (from past experience), users will tend to enter things in the wrong fields or overwrite data accidentally. Other applications I have used (AppSheet, most recently), separate the backend data from the UX components. Is there something similar with Airtable? Do I need to use a 3rd party application in order for users to enter / interact with data? I have tried using the “Interfaces”, which are very nice, but my understandin

I’m building a content marketing tracker and I’d like to be able to add an analytics and reporting status which automatically triggers 30 days after a piece of content is marked as published. What would be the best way to handle this in an automation?

Good Day! I was wondering if I could get some help with a scenario: In the scenario a particular individual could have multiple records linked to them within another table. In the scenario let’s use contracts as an example. 1 individual could have multiple contracts with start and end dates, along with an attachment. In the “Master” table we can quite easily look up the Start and End Dates based on a MAX(VALUE), but my question is this: How would I go about linking THAT SPECIFIC contract to the given dates without showing all other contracts?

I have the Pro Plan via a recent upgrade. Previously under this Pro Plan I added and used the Nobull app. Today I discovered that the Nobull app is deactivated. When I try to add it again, I am told “This app is available on the Pro Plan” and that an upgrade is required. I have encountered the same issue when trying to add another app. I understand that this post is a support request best sent via a direct contact to Airtable. I did so, but hoping for any comments as I await Airtable’s response. Thanks!

I’m creating a custom app which uses a date input field. My computer clock is set to GMT+2, ie my time is 2 hours later than GMT. When I toggle the GMT setting on the date field, the local time appears 2 hours behind the GMT time when using record.getCellValue: Local date time (GMT setting off): ‘2022-01-01T10:04:00.000Z’ GMT date time (GMT setting on): ‘2022-01-01T12:04:00.000Z’ I can’t understand why the local time is earlier than gmt when it should be later. Also, I can’t understand why the local datetime string is being formatted as a utc datetime string, as this doesn’t follow ISO8601. When I use record.getCellValueAsString, it returns the string ‘1/1/2022 12:04pm’, regardless of the gmt setting. I notice that the datetime string returned by the REST API seems to change in the same way as record.getCellValue, even though the docs say that only a utc datetime string is returned. Any help/insights appreciated.

I’m trying to use DATETIME_FORMAT to format a date calculated by a formula to the way I want it to be displayed. I have to use DATETIME_FORMAT rather than the settings button because I’m inserting it into an automated email, which defaults to YYYY-MM-DD format instead of the settings. It seems like this should be possible but I keep getting an error. Here’s my current formula: DATETIME_FORMAT((DATEADD(TODAY(),14, “days”), ‘DD-MM-YYYY’) The center formula DATEADD(TODAY(),14, “days”) works properly on its own, so I know it’s something about adding the formatting piece. Is it possible to do this in one formula?

Hi everyone, Please advise how to create a formula for a field (let’s call it “CityCount”), which would automatically display the number of records in this table which have the same value in the field “City” as a current record? Here is an example: there are 3 records in the table with City=London, thus each of the record should have CityCount=3. If I add one more record with City=London, then each of such records would get updated with field CityCount=4. Any help or ideas appreciated!

Hi all, I am trying to adapt a script from postman where I successfully tested my API call. My issue is that the API secret key needs to be encrypted when I send the request but this requires Crypto-js. Is there a workaround available in Airtable scripting block to make this work: var CryptoJS = require('crypto-js') // the Authorization header needs to have this very particular format, which the server uses to validate the request // the access key is provided for the server to retrieve the API key; the signature is encrypted with the secret key var hmacString = (method + '\n' + onNonce + '\n' + authDate + '\n' + headers.get('Content-Type') + '\n' + path + '\n' + queryString + '\n').toLowerCase(); var signature = CryptoJS.enc.Base64.stringify(CryptoJS.HmacSHA256(hmacString, secretKey)); var asign = 'On ' + accessKey + ':HmacSHA256:' + signature; headers.append('Authorization', asign); For reference the above code is from here : onshape-clients/postman at master · onshape-publ

Hi all, I use the phone field a lot in my tabs but I don’t live in the US and so what I get is a very odd and inconvenient formatting of my clients phone numbers. For instance I want to call a french number which should be formatted as follow : 06 01 23 45 67 it shows in Airtable as (060) 123 45-67. When I’m using the app on my phone I can just click but I’m also making a lot of calls from my office. So I manually type numbers and the formatting is very distracting and I always have to double check before making a call. My collaborators have the same problem and while it doesn’t look like much it adds up to a lot of lost time. Is there a way to change the number formatting ? My iphone does it automatically as I type numbers in so i’m a bit surprised that I can’t do it on Airtable. Thanks for your input.

Hi! I have a sort of complicated situation and I’ve been able to figure out what i need to do, but not the way to actually accomplish it. I have a base with three tables in it: Jotform (A) | Supplies (B) | Split Requests (C) Table A is bringing in responses, Table B is a list of every unique item that has been requested in the jotform, and Table C is where I will split up requests with multiple items in Table A to separate ones. In the Jotform, people can select multiple items in one form submission. even though someone might send in one form submission, that submission might include 50+ items. The jotform takes the info for each item (data points like item,qty,notes) and separates them by comma, and each item by a line break. that’s my way in with parsing out the data. I need to take a cell that might say: Apples,50,red apples Apples,49,granny smith Peaches,23 Oranges,44 and split that into separate requests in Table C. then i need to link that record back to the original record in Ta

Hi! I am creating a task list template that has certain tasks that need to be completed 20 days prior to event, 14 days prior to event, 12 days prior to event, 2 days after the event, 7 days after the event, and so on. I’d love to be able to pop in the Event Date and it autopopulate real calendared DUE Dates based on those parameters so that I can use it over and over for each new event without manually typing in each due date for every single task, but am struggling to figure this out. Can someone please assist me? I am new to airtable and watching lots of tutorials!

I’m trying to simply copy text from one column to another. Only about 20% of the records are being copied over. However the console logs each name correctly… Im using this script, which i’ve edited for my own use from here: Using a script to add values from one field to another Scripting app Hi @Jens_Schott_Knudsen1 - try this script: // set the table let notesTbl = base.getTable("Notes"); // get the table records let notes = await notesTbl.selectRecordsAsync(); // loop through the records for (let record of notes.records) { // set variables to the record values let notes = record.getCellValue("Notes"); let notesHistory = record.getCellValue("Notes History") // set variable for today's date let now = new Date().toLocaleDateString("en-GB"); // define the new… // set the table let table = base.getTable("Inventory Item Summary"); // get the table records let itemCode = await table.selectRecordsAsync(); // loop through the record

Hi There, New to airtable and loving it so far. I am wondering if its possible to add a column to my table that only I can see but when the table is viewed when its embedded on my website no one else can see it. I am trying to eliminate the use to my second spread sheet for details my customers don’t need to see in their order.

Hello dear community. First time asking a question and learning the basics of scripting. One part of my script asks the user for a value like this: let SessionPrice = await input.textAsync (‘Input price per coaching session’); Then I’m trying to insert that value on a currency field with: Let CreateField = await MainTable.createRecordsAsync([{Fields:{“UnitPrice”: SessionPrice}]); And I get the error: j: Can’t create records: invalid cell value for field ‘UnitPrc’. Cell value has invalid format: must be a number I guess its because its a ‘text’ string and I don’t know how to convert it or make it a ‘currency’. In advances I’ll appreciate your help. Thanks…

Can I use integromat to change the filter settings of one particular view? I use different views to trigger certain integromat scenarios and it would be great to be able to trigger or turn off scenarios via integromat changing the filer settings of an individual view. Thank you for your wisdom, friends.

Has anyone been able to make an api call to remove.bg from scripting or a script within an automation?

Question: How can I capture how long a record has spent in a Single Select field option throughout its lifecycle? Field Information: Field Type: Single Select Field Name: Status Field Option: “Awaiting Information” Context: Record enters table (Status automatically changes to “In Progress” through automation). User changes Status to “Awaiting Information” when appropriate. When user is finished, they change the Status to “Complete”. Goal: I want to see how long we are waiting on other people for (on average) when fulfilling these requests. I wasn’t sure if this was a formula or automation question. Thanks!

Hallo everyone, During these holidays I am evaluating Airtable as our company new CPRM. Trying different functions… We prefer to create event in our Outlook calendar and would like to create and update records in AT CPRM base Activities table. I found the way to create record via automation. I am having issues on updating the record when the event is changed in Outlook calendar. Could you please indicate me the way forward or around?

Thanks in advance to anyone who even scans this query! :blush: I have a rollup field that is flattening an array of dates - that’s working great! What I want to do is produce this same information showing only the month. For example, I have this list (a flattened list of dates from 3 different records showing only unique dates): 13/09/2021, 20/09/2021, 27/09/2021, 04/10/2021, 06/10/2021, 13/10/2021, 20/10/2021, 13/12/2021, 29/11/2021, 22/11/2021, 15/11/2021, 08/11/2021, 25/10/2021, 20/12/2021, 09/12/2021, 01/10/2021, 08/10/2021, 18/10/2021, 22/10/2021, 29/10/2021, 05/11/2021, 12/11/2021, 19/11/2021, 26/11/2021, 10/12/2021, 17/12/2021, 03/12/2021 I want to create a formula that converts this list of dates into (just the month of each date as an array): 09,09,09,10,10,10,10,12,11,11,11,11,10,12,12,10 etc… If I extract the month before producing the full array of dates, of course, it only ever gives me 1 instance of each month which is not what I want. I’ve been trying to work out the

Hi! How to determine the number of records / entries in a table via API using curl / php / pyton? Imagine a table with 12304 entries. Our current stumbling block is the API limit: we can only get 100 entries at a time via the API using PHP. In this regard, we have to make a lot of requests page by page. Then count the number of pages and multiply them by 100. Is there a more elegant way? Thank you!

Hi, I am trying to figure out why I keep getting this error message: The Impact Value is the average of the Confidentiality, Integrity and Availability column. (Confidentiality+Integrity+Availability)/3 The Risk Value should be multiplying the Impact Value with the Likelihood Value. But I am getting an error message with this basic formula {Impact Value}*{Likelihood Value} Please help.

I would like to ask the community for input and ideas on a problem I’m facing, which is: How can I track business travel expenses in a AirTable Interface (from Table: “Trip Tracker”) using receipt data from a different table (Table: “Expense Tracker”)? The table “Trip Tracker” is a kind of dashboard that lets me track the status of multiple items for every trip (dates, host, invoice amount, team members, etc.). I created an Airtable Interface that is very, very useful for me to keep status on trip details in a helpful presentation. The table “Expense Tracker” is going to have one record per expense, and keep track of all of the expenses for each trip so I can reimburse people, and bill clients. I would like to populate the “Trip Tracker” interface with a table (i.e., grid) of all of the expenses for the relevant trip from the “Expense Tracker” table. Ideally, this would be a grid of the expenses with rows and columns displaying from “Expense Tracker” table within the “Trip Tracker” in

Suppose I am trying to grab some records from table 2 using a set of linked records from table 1 with an automation so I can show a list or gallery of these records in an email. For whatever reason no matter how I do it, Airtable will not let me use an autonumber field to do this. I’ve tried it both as a primary and non-primary field, I’ve tried using a formula, I even tried creating a formula that gets the record ID and then seeing if Find Records could find that (which resulted in an “unkown error”). I don’t know why any of this is the case when its essentially performing a sort of janky database join. I’d appreciate any suggestions for workarounds. If you are curious what exactly I need this for: I have a series of equipment reservations. I want to list the equipment details in an email detailing the reservation. The trigger needs to be a form on the reservation table.

Hello ! I’m new to airtable and struggling to write a formula that allows me to extract dates from a field. I have tried many different formulas found online but nothing matches my case. I have a SPRINT column that hosts in each field a set of dates: 2022-01-03, 2022-01-10, 2022-01-17… (can go up to 53 dates). I would like to extract from any of the fields in the SPRINT column the FIRST date (2022-01-03) and send it to another field in a new column named START. Then, extract from any of the fields in the SPRINT column the LAST date (2022-01-17) and send it to another field in a new column named END. Do you think that is possible and if so could you help me find out the correct formula ? Thanks !