Solved

Hi everyone ! I have a list of bars associated with internal funding codes. Then, on another tab, I have a list of projects and each one of them is associated with a particular internal funding code. On that tab, there is also a column name “List of bars”, where I’de like to have a list or a field including all the bars that were tagged with the specific internal funding code associated with the projet. Right now, I’ve tested automations used “Update record” and even “Create record”. The link works : If I input the internal funding code to a particular bar, it will show up in the list of bars on my second tab. However, instead of ADDIND this new bar to the list, it erases what is already there and only update the latest bar associated with my internal funding code. So, here I am, wondering if there’s is a way to do what I want to do with this. Thanks a lot for the help !

Hello all, I am a learning developer so hopefully my code is not too confusing. I want to create a form in React that feeds data onto Airtable. Using the Airtable SDK I am able to do it when I insert the API key into the code. const base = new Airtable({ apiKey: API_KEY }).base( "base-name" ) However, if I use process.env.AIRTABLE_API_KEY it gives an error saying: Uncaught Error: An API key is required to connect to Airtable. import { useState } from 'react'; require('dotenv').config() const Airtable = require('airtable'); const base = new Airtable({ apiKey: process.env.AIRTABLE_API_KEY }).base( "base-name" ) const table = base("table-name") const Form = () => { const [firstNameInput, setFirstNameInput] = useState(''); const [lastNameInput, setLastNameInput] = useState(''); const [emailInput, setEmailInput] = useState(''); const [interestInput, setInterestInput] = useState(''); const [phoneInput, setPhoneInput] = useState(''); const resetFo

Hi there, I have accomplished a few formulas through my airtable base but I have trouble with this one: In a library, I want to return “not in stock” for items that are signed out and have not yet been returned. In writing this would be: If SignOutDate contains a value and ReturnDate contains no value, return “not in stock”, otherwise “available” IF( AND( {SignOutDate}<>””,{ReturnDate}=BLANK() ), ”notinstock”,”available” ) As I am new to the AND/IF business, I might have severe problems in here already? If not, could it be that the date fields are the problem, they are set as ISO? Any help highly appreciated. Best, Sisi

I know that I am probably approaching this formula wrong, or maybe it isn’t possible with the way MIN()/Dates/Fields work in Airtable - but I figured I would ask the community for a little help on this one. Context: Need to assign work order due dates based off content Air Date. More specifically, I am trying to take the earliest date found for each month then subtract 28 weeks (dateadd -28 weeks), and use that Min Date - 28 weeks as the Work Order Due Date for every record that has an air date with the month that calculated it. Example: Record | Air Date | Work Order Due Record 1 | 04/22/2023 | 9/19/2022 Record 2 | 04/14/2023 | 9/19/2022 Record 3 | 04/03/2023 | 9/19/2022 Record 4 | 04/19/2023 | 9/19/2022 Record 5 | 07/22/2023 | 12/29/2022 Record 6 | 07/25/2023 | 12/29/2022 Record 7 | 07/13/2023 | 12/29/2022 In the example above, the four records have an Air Date in April, but the formula would calculate the Work Order Due Date as 28 weeks prior from 4/03/2023 since its the minimum val

Hello. I have a base that I offer for sale as a template. The purchaser copies the base to their account upon purchase. Is there any way of natively finding out how many times one of my bases has been copied? If this is not natively possible, is there any way of accessing the meta data for this? I’d like to understand if the number of sales correlates to the number of times it’s been copied. Many thanks,

I have 2 tables… Companies CompanyID, CompanyName, ContractIDs Contracts ContractID, ContractTitle, EffectiveDate, ExpirationDate, CompanyID They’re linked together via the final field in each table where 1 Company can have multiple Contracts. I want to create a field in the Companies table to display the ContractTitle of the most recent contract but am struggling to find a solution using Rollups. Of course, I can add a field to Companies using a Rollup that takes the MAX(ExpirationDate) to at least give the latest contract expiry, but I can’t find a way to use that expiry to bring back the single ContractTitle field with that expiry per Company. Appreciate any thoughts at all on whether this is possible!

This might be simple, but I fail to get my head around it. Help, please. We have 2 tables; Profile - name, image, etc Availability - date/time, profile linked record 13/2/2022 4:57pm 20/2/2022 4:57pm 23/2/2022 4:57pm 11/2/2022 4:58pm On Profile table, we need to roll up the Min(values), but only display date/time past NOW. If now date/time is 19/2/2022 4:45om the correct answer needs to be: 20/2/2022 4:57pm

I have a form wit a look up files, so I open the form to add a new donation from a client, I find the client but what I want to do is when I look for the client I want to see their information (address, phone number etc) can you guys direct me to the correct pad pls

It seems I can’t use a variable in the method updateRecordAsync(record,{"field": value) In the head of my script, I ask which field needs to be updated. (ps: I use pseudo-code here to keep my question brief. Everything works, except the last line) input.config({ input.config.field('selectedField', { label: 'Which field do you want to update?', parentTable: 'selectedTable', }), }) Let’s say I choose the field status. Then I would like to use something like updateRecordAsync(record,{selectedField: someValue) or updateRecordAsync(record,{selectedField.name: someValue) However, the code above gives an error: j: Field ‘selectedField’ does not exist in table The code only works when I hardcode the field, which kinda defeats the purpose of scripting/automation… updateRecordAsync(record,{"status": someValue}) question: is there some way to use a variable selectedField in updateRecordAsync or do I need to keep the fieldname hardcoded?

I could not find in the API documentation a way to trigger Airtable’s UNDO actions. Is there a way to do this ? It would surely be of a great help for all users. Thanks!

Hey guys, I’m having some troubles with the blank formula. I build this simple task-manager. The idea is that i can choose a task-startdate and choose with the single select the duration. Then I have a formula which counts based on the single select the right end-date. When there is no date, I get an error, which I would like to remove. This is the original formula for the end-date: IF(Block = "2 Std", DATEADD(Datum, 2, 'hour'), IF(Block = "4 Std", DATEADD(Datum, 4, 'hour'),IF(Block = "1 Std", DATEADD(Datum, 1, 'hour'),IF(Block = "8 Std", DATEADD(Datum, 8, 'hour'),IF(Block = "0,5 Std", DATEADD(Datum, 0.5, 'hour')))))) This is the one I tried with blank, but I’m doing something wrong here… IF(Block = "2 Std", DATEADD(Datum, 2, 'hour'), IF(Block = "4 Std", DATEADD(Datum, 4, 'hour'),IF(Block = "1 Std", DATEADD(Datum, 1, 'hour'),IF(Block = "8 Std", DATEADD(Datum, 8, 'hour'),IF(Block = "0,5 Std", DATEADD(Datum, 0.5, 'hour', IF(Datum = BLANK()))))))) Thank you very much! Best, Viktoriya

Hi, I’m testing the script of Airtable and I’m facing the issue with POST request creation. First, I tested my request with Postman and it worked fine. Then I ran the same request with Airtable script and I got failed. let response = await fetch('https://gorest.co.in/public/v2/users', { method: 'POST', body: { "name": "Tenali Ramakrishna", "gender": "male", "email": "tenali.ramakrishna2@15ce.com", "status": "active" }, headers: { 'Content-Type': 'application/json', "Accept": "application/json", "Authorization": "Bearer 84799e2274fa6626356d26d9364fde5320a5d3f1703b6d33a525a1585cbbce65", }, }); console.log(await response.json()); Could anyone help me on this? Thank you!

I teach a class where students have to share information in a daily form. They get credit for the number of days they submit a form, not for the total number of forms submitted. The form feeds a Daily Submissions table, which is linked to a Students table. Because I didn’t see something equivalent to Sheets/Excel COUNTUNIQUE in Airtable, I created a Pivot Table app in the Daily Submissions to calculate Days Shared. I’m trying to figure out whether I can pull the number of Days Shared from the Pivot Table app back into a field corresponding to that student in a table of students, so I can share a view of table that includes Days Shared. If that’s not possible, is there a way to count the unique days in a table without a pivot table? There is a Lookup field in the Students table that collects all the days, including duplicates, but I don’t know how to dedupe that. Or do I need to do create an interface that displays the Pivot Table app data? Thanks for your help!

Hi Can airtable fulfill my requirement? Please see the picture for specific examples. I need to reserve two decimal digits in the column of “Original Price” in the picture

Hi, I’m trying to make a script to set the single select value when a button is pressed. However, it requires an id. How would I get the id of my single select value? Example of a working script which I’d like to duplicate & set it to another value, the script is fired with a button: let table = base.getTable("©️ Copyright infringements"); let record = await input.recordAsync('',table).catch() await table.updateRecordAsync(record.id, { "Status" : { "id": "sel3MYJB5QL4jKFdg", "name": "Approved internally", "color": "cyanLight2" }, })

Hello, community! I am using the free subscription for this table. In the form that I am creating from the table, I would like to add a section that will allow those filling out the form to be directed to an external link. (Ex: “Thank you for completing this form, if you would like to join our mailing list, please click (XX).” Our mailing list is held via another program.) I thought that the solution was to add a button and then have the button redirect to the external link. But that column does not show up in the form view (because I imagine it’s meant to support internal processes). Is there a way to do this? Thank you.

I’m helping a nonprofit setup their membership system in Airtable. We have a Master Membership table with about 400 member records. Occasionally we get a CSV of member records that have renewed their membership. What do I do to update the Master Membership table using the renewals table? I realize this is a big topic, but I’m just looking to understand how to merge an update table with a master table. Thanks in advance for any guidance!

Hey guys, do you know a way to use a monospaced font on Tables (Grid Views)? It makes things clear since the whole text will align.

I’m trying to work this one out but I don’t have sufficient coding experience to really crack it. I’m looking to generate an image into a dedicated field, based on a record’s {firstname} {lastname} fields. Examples of code to do this are here: javascript - How do I set profile image as first letters of first and last name? - Stack Overflow Can these easily be turned into a script? If it isn’t possible to create an image file, generating unique embed codes per record might be just as useful.

Hi there, I have a question for our PTO system. I like to calculate the workdays between the PTO startdate and enddate minus the holidays + non working days (for partime employees). I want to do this in a linked field because of large number of dates. But I constantly get an error when implementing. I’ve made a table for all days in the coming year I’ve made a lookup field referencing to this table. Then a field with a formula field WORKDAY_DIFF({startPTO}, {endPTO}, {Days in year}) I’ve also tried this advice from Justin_Barret in this topic. But unfortunately it keeps showing an error. WORKDAY_DIFF({Start Date Field}, {End Date Field}, {Lookup Field} & "") Does anybody have an idea? Or can point me in the right direction :grinning_face_with_big_eyes: Many Thanks

So this is what I am using to get my data from airtable import axios from "axios" formSubmitHandler = e => { axios .get( "https://api.airtable.com/v0/" + app_id + "/" + view, { headers: { Authorization: "Bearer " + app_key } }, ) .then(resp => console.log(resp)) .catch(error => console.log(error)) e.preventDefault() } This works very well, however when I try to post something into the same table and now using this: formSubmitHandler = e => { const { name, email } = this.state const data = { "records": [ { "fields": { "Name": name, "Email": email, } } ] } console.log(data) axios .post( "https://api.airtable.com/v0/" + app_id + "/" + view, { headers: { Authorization: "Bearer " + app_key } }, data ) .then(resp => console.log(resp)) .catch(error => console.log(error)) e.preve

I’m trying get all of the records form an api call into an object so I can use the data in other calculations. I can’t, however, get the function to return what I want. I’ve tried lots of combinations of async/await and .then(), but I can’t get it to work. “aTotalRecords” gets filled up with the data, but I can’t get the function to return it. Can someone help me figure this out? Thanks in advance. Here’s the code I have: async function getAirtableData(){ // var Airtable = require('airtable'); var base = new Airtable({apiKey: oConfig.oConfig.airtableAPIKey}).base(oConfig.oConfig.airtableBaseKey); var aTotalRecords = []; // for keeping allthe records base('Polygon Transactions').select({ maxRecords: 500 // view: "Grid view" }).eachPage(function page(records, fetchNextPage) { // This function (`page`) will get called for each page of records. records.forEach(function(record) { aTotalRecords.push(record.get('tx_

I’m trying to copy/paste data from a Google Sheet into airtable (import as a csv may work but for my use case I’d rather just quickly copy/paste, rather than going through the download/upload process). My problem: When I set the field as percentage or number type, the pasted values change from negative to positive. What I’ve tried: I’ve ensured that the “allow negative numbers” is toggled on (and have even tried it toggled off) but no luck. When I set the field as single line text, the number formats correctly but then I can’t use it as a “number” in subsequent formulas since it’s formatted as text. Anyone have a similar problem or able to help?

Hi. Is there a very simple example of how to consume multiple pages when calling GET on the airtable API? I have a simple API Call class, much of which I got from this forum, but there are multiple pages in my data. Here’s my code: class AirtableGet{ constructor(inputSheetName, tableName){ this.inputSheetName = inputSheetName; this.tableName = tableName; // text name of the table in Airtable; ex. "Balance Tracking" /** Airtable Variables */ this.ss = SpreadsheetApp.getActiveSpreadsheet(); this.inputsSheet = this.ss.getSheetByName(this.inputSheetName); this.myAPIKey = this.inputsSheet.getRange(9, 2).getValue(); this.baseKey = this.inputsSheet.getRange(10, 2).getValue(); this.cAirtableAPIEndpoint = this.inputsSheet.getRange(11, 2).getValue(); this.url = this.cAirtableAPIEndpoint + this.baseKey + "/" + encodeURIComponent(this.tableName); };// end constructor /** get request */ getFromAirtable (){ var options = { m

Hey all! I’ve asked the community in my recent post whether or not it is possible to “score” records based on the value in a multi-select field, and I also needed my formula to calculate the total for all values when the multi-select has 2 or more values. Here’s what @Justin_Barrett came up with and helped me a lot: IF(FIND("Global", Locale), 1) + IF(FIND("US", Locale), 0.9) + IF(FIND("UK", Locale), 0.9) + IF(FIND("DE", Locale), 0.7) + IF(FIND("CA", Locale), 0.8) + IF(FIND("FR", Locale), 0.7) + IF(FIND("ES", Locale), 0.6) + IF(FIND("MX", Locale), 0.6) + IF(FIND("BR", Locale), 0.6) + IF(FIND("AU", Locale), 0.6) + IF(FIND("IT", Locale), 0.6) The way that I expect my records to be scored has slightly changed as so I need to refine the formula - I don’t need it to put the values together, instead, I want it to return the biggest value from the list alone. Here’s an example: The score per locale is as before: US - 0.9 UK - 0.9 DE - 0.7 Global - 1 CA - 0.8 FR - 0.7 ES - 0.6 MX - 0.6 BR - 0.