Solved

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 !

Hi there! :grinning: Thanks in advance for taking the time to help me out. I’m new to airtable and I’m currently evaluating if I can use it for my small business to do the budgeting for my projects. I actually think what I’m looking for is too much of a spreadsheet functionality which isn’t supported by airtable as a database tool. But I would love to be wrong because it would make my life so much easier if it was possible: I’m trying to calculate the costs of each of my departments and usually just have a long list of items and staff. Some fields I need to be the percentage of the total costs (and update automatically if the total sum changes). For instance I would like to have a field with contingency costs of 5% of the total sum. Am I right assuming that there is no easy formula that can do that? And I would have to follow a complicated workaround with rollup fields and a linked table instead, because you can’t use summary values in formula fields? I feel like I’m really in a pick

Hey guys! I would like help to develop a formula that would give me the day “02” closest to the date of a specific field. For example: If in the {Purchase day} field the date is 02/25/2021, I would like the formula to show me 03/02/2021, if {Purchase day} is 05/14/2021, I would like the field show me 02/06/2021. I hope I managed to explain. Thanks in advance! PS: I also need help creating a formula that shows me the “02” day of the next month if the day of {date of purchase} is greater than 02. I’m trying to automate credit card billing. I’m racking my brain a lot.

I have an asset that is linked to an owner with a % holding and to many valuations. I want to view the data for a selected owner, with a current value of the asset calculated from that owner’s % multiplied by the LATEST valuation - ie from the valuation record with the latest date. Filtering is easy enough and rollup field looks promising but there seems no way to use the latest valuation record in the calculation. I need to select the person and then print or export the results that values their entire estate by combining latest asset valuation with % owned. Is a custom app needed (that feels unlikely given what I want to achieve would be trivial in SQL)? interfaces don’t seem to do it and views neither as far as I have been able to determine so far. It seems like something that would be used frequently but I’m in my first few hours with AirTable so a pointer to a help article would be great, thanks in advance!

Hi guys, in the spirit of Christimas I’m in charge of a support group for people in need. We have got a lot of applicants who really need our help to make sure their kids are going to get a gift this year. I’ve got a ton of gift cards in a single column in excel, and I’d like to distribute all the gift card codes to the recipients. Now here’s the kicker: the recipients have different amounts of kids, which means they need different amounts of giftcards. I’m trying to figure out an automation that links a number of times from the recipients sheet to the gift cards code sheet, while never linking to the same code more than once. The route I’d go would be to make a formula field which counts how many links are in a ‘link to an another record’ field, and if there’s less than the number of children in the family (a manual number field), then it keeps adding a new link from the gift card sheet. But the last part is not really doable in automations, as I see it…? Worst case: I’ll do it by han

I share View links with different stakeholders so they can see records that fall under their department. I want to be able to have a View or some other easy to way to see what records they edited so I can review any changes that were made. Since they are typically making the edits after clicking on the link and not signing in, the Last Modified By usually shows as Anonymous. This has made it hard for me to filter since any records submitted through my form also show Anonymous. So I’m trying to find a way either to be able to specifically view edits made through the shared links or perhaps on the flip side make it so that records submitted through the form don’t show Anonymous for Last Modified By so those wouldn’t be populated using a filter showing Anonymous changes.

For video editing purposes, how can I input timecode into a field? The format could be either: H:MM:SS (hours:minutes:seconds) MM:SS (minutes:seconds) In the article Supported format specifiers for DATETIME_FORMAT I found “Preset timestamp format”, but that’s a timestamp. My desired format is time duration, similar to a stopwatch. Thanks!

This is so simple, and yet no matter what I try, nothing works. :confused: I want the due date to be 2 days after the creation date. I’ve tried a hundred variations of: DATEADD({Created},+2,‘days’) …to no avail. What am I missing??

If I choose a record in the record picker that has information in a connected field and then choose another record where that field is empty, the information of the previously chosen record shows up. Any ideas?