Solved

I have a column which has multiple linked records as Contacts in. Then I have lookup fields for the contact information (email and phone number) for those linked records. I am trying to make another column as a concatenate formula which shows “{Contact Name 1}, {Email Address 1}, {Phone Number 1}”. But because I have multiple linked records in a column it is instead coming up as “{Contact Name 1}, {Contact Name 2} {Email Address 1}, {Email Address 2} {Phone Number 1}, {Phone Number 2}”. Is there a way in the formula for me to limit how the information populates by linked record vs information requested?

Hi, How can I hide data in column for specific colleagues with editors role? For example, my table have columns A, B, C, D I want that editors can view and edit A, B,C columns But column D will be hide for them And only I as a creator can view and edit data in column D

I’m working on an app that will have a free tier and a paid tier, and I’d like to add a button to let users sign up to a paid tier from inside the app. What are the general guidelines regarding building sign up and payment features into AirTable apps?

Since finding Airtable, we have been actively creating many apps to digitise our businesses. So far we pretty much have a base for each app. Some apps are for a specific company of ours, whilst some like HR and Tax/Assets are apps that apply to more than one of our companies. We use Stacker as the interface for most users. We have come to realise that there are some data that might make sense to be thier own base(s). Contact (suppliers, customers, staff, everyone any company comes into a transaction with) is one example. Products is another (things that all companies buys, and in some cases, maintain as assets). So, I would like some advice if it does make sense to create these two data sets as their own Bases and sync one-way to any destination base that needs/interacts with them. It would presumably mean that Contacts and Products become it’s own separate app, and anytime a new Contact or Product interacts with any of the other apps, a new record needs to first be created in th

Hello, I’m trying to create a new block, but npm install -g @airtable/blocks-cli is not working The error log: ERR! stack at maybeClose (internal/child_process.js:1021:16) node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:286:5) node-pre-gyp ERR! System Darwin 19.3.0 node-pre-gyp ERR! command “/usr/local/bin/node” “/usr/local/lib/node_modules/@airtable/blocks-cli/node_modules/.bin/node-pre-gyp” “install” “–fallback-to-build” node-pre-gyp ERR! cwd /usr/local/lib/node_modules/@airtable/blocks-cli/node_modules/nodegit node-pre-gyp ERR! node -v v12.18.0 node-pre-gyp ERR! node-pre-gyp -v v0.13.0 node-pre-gyp ERR! not ok Failed to execute '/usr/local/bin/node /usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js configure --fallback-to-build --module=/usr/local/lib/node_modules/@airtable/blocks-cli/node_modules/nodegit/build/Release/nodegit.node --module_name=nodegit --module_path=/usr/local/lib/node_modules/@airtable/blocks-cli

Hello all, I’m trying to figure out a clean way of writing a formula for a Lookup table that can hold up to 4 variables at any time (A,B,C,D). Based on these variables, I want the formula output the following: IF(Lookup contains: “A or B or C or A,B or A,B,C” - in any given order), output “Inhouse”, but if D is also present, still output “Inhouse”. If only D is present, then output “Foreign”. Is there a clean way to write this? Thanks so much in advance!

The processing (or calculations) I need to perform are currently done in a Google Sheet. The calculations in the sheet are straightforward but have about 20 steps, and the final result is a string (an array) in a cell in the Google Sheet. I want that result in a cell back in AirTable. I am sure there’s a way to write a custom script with Javascript in an Automation and write result to the cell. I’ve started, but I’m not strong with JS. I would like to explore other more low/nocode ways do these calculations. I imagine there exists some other low/nocode SaaS tool that you can build a little black-box app with build business logic and calculations and spit out a result. In summary, here’s what I’m currently doing that I need to automate without Google Sheets: Row in AirTable has 5 values. I manually copy those 5 values into a Google Sheet, which does a bunch of calculations, involving creating a 12-period time series with about 20 rows of partial calculations, ultimately collecting the

I am trying to build a table for my husband’s business that will show the commission earned for each of his employees. He has a column for Grand Total of Sale, Salesperson Commission %, and Salesperson $. He would put in the Grand Total and the Salesperson commission percent but needs the Salesperson $ field to populate. I know this is a very easy formula for all of you but I am obviously new to this. Thank you in advance for all your help.

I have a Timesheets base with a “Timesheets” table that is filled when my workers submit timesheets each month. I have a separate “Rates” table (in a different base) that is synced to my Timesheets base and table. In this Rates table, I have a list of rates connected to each of my referral partners, including a start and stop date. If they do not have a stop date then that rate is considered active, if it does have a stop date than that is not an active rate. My problem is that I am currently manually syncing the Rates table Referral partner to the Timesheet entry, and it’s too much work and error prone. The whole point of doing Rates in a different table was to not break that past timesheet entry’s as you can see here: Financial reporting dynamic changing past data - #3 by Justin_Barrett I am looking for a script that can automatically detect what record selection to make in the Timesheets table from the Rates table, connecting my referral partner to the timesheet. The identifier can

Hi, I’m trying to update a record and select specific options in a multi-select field via Integromat and need some help. One of my preceding modules in Integromat gives me an array of destinations. Something like this: Destinations = [Africa, Asia, Australia and South Pacific, Central America and Caribbean, Europe, Middle East, North America, Polar Regions, South America] In Airtable I have a multi-select field with these exact options I referred to this thread, but can’t get Integromat to put the original multi-select values directly into the multi-select field as suggested by @ScottWorld. When I try this, I keep getting a “Cannot parse value for field Destination Options”. As you can see from the image above, I am using an iterator to iterate through each value in the Array and pass on the Update Airtable Record module hoping that on each iteration, the next item from the Array, i.e. one destination at a time, will get ‘checked’ in the multi-select field in Airtable. Am I going abo

Hi beloved Airtable Community! I’ve got an issue with a VALUE formula. I have a Rollup field that does a ARRAYUNIQUE job from a Lookup Field which is formatted as a % (i.e. 36%). The output I get from the Rollup field is a string (i.e. 0.357142852346992). I tried various ways to convert it back to a number like: Within the formula of the Rollup, try VALUE(ARRAYUNIQUE(values)) Create a new formula field that performs VALUE(ROLLUP FIELD) But both outputs give me “#ERROR” I’ve read some articles about VALUE behavior but not sure to understand how it might help in that particular case. Would you have any hints? Thanks a lot, appreciate it!

Hi All! So here is what I’d like to do. I have a base with four tables. All look precisely the same in terms of fields (types and names). For your understanding, the first three tables are lists with data about particular individuals. And the last table includes all individuals. My goal is to create a field on the fourth table that will let me know by the person’s “Name” (which is the first field) in which table he/she is located. But, some of the records repeat themselves in different tables, so I’d also like to know if the record is in “table1” and “table 2”. Thanks In Advance, -Bar.

Hi, i’m strugling with it 3rd day and read many docs about querying with fetch on JS, but seems like my understanding of web stuff is not enough. I used similar method for fetching from API with JSON, or from simple html site parcing text, but here I can’t achieve desired goal. Site is a base of clients, sorry but for now I didn’t have approve to disclose real name. https://search.somelongdomain.com, reloading to https://search.somelongdomain.com/ClientSearch.php?Accept=Accept it contains form with “Name”, “LastName” etc, then “Start Date”, “End Date” and two buttons, Search and Reset. After submitting “start_date”, “end_date” i press Search and have list of Clients registered within this period, 20-50 names for 2-3 days, and that’s my desired result. output loaded as https://search.somelongdomain.com/NamePick.php, it’s a form with name table and checkbox near each, but that’s ok, i know how to extract my data from any type of text format is html text, site looks a bit old, it doesn’t

Hi, I’m looking to set up automations to remind me of due dates. I was using a datetimediff formula, but it says NaN. I want to take todays date-the due date and have it show how many days until the due date, then I was going to schedule an automation to send out whenever tasks are due in 3 days or less. The formula I’m using is: DATETIME_DIFF({Today’s Date}, {Due Date }, ‘days’)

Hi there! I’m not sure what the best solution is here and I would love your input. My company writes books for service professionals who want to help more people and gain credibility/visibility. We (I say we, it’s just me right now) use the same process for writing the book for every client. This process is date-dependent and everything is dependent on several things that come before it. Eventually, we will be adding more writers and assigning them to different clients’ projects. I have created a template of the process and I enjoy looking at it in the Gantt view. Very satisfying. My first question is: Do you think I should just create a separate base for each client or can I put all the clients in one base, potentially having 5-10 of the same process happening at any given time? Ideally, I’d like to see all the client’s projects in one view so I can see where we are, who is doing what, where there are any delays and what needs to get done in one view. How would I do that? Right now my

Hello! I’m not great with formulas, but I’ve spent hours on google and airtable forums trying to figure out how to do this. Let me see if I can explain this well. I have a string of text and I’m trying to find the first name of the person listed in the text. The text looks something like this: Hi Stylist, You have a new reservation. Customer First Name: John Customer Last Name: Doe Customer Phone #: 1234567890 Customer Email: johndoe@gmail.com Location: Salon Date: Thursday, December 9, 2021 Service: Package 1 Employee: Stylist Time: 1:45pm Yours Truly, The Team I just want to grab the First name only from the string and I can’t for the life of me figure out how to format the formula. Any help would be much appreciated!!

Hi, Folks. I had created a form for collecting data. I put in example link. Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. I didn’t set up any option in my form. But the form link dosen’t work that customer can not fill in the form. The link moved to log-in page. How can i fix it? Best, Daniel

Hi Dear, I try to create a table for Calls (duration, caller name, description, some statistic data about the caller (sex, age, location)). I have another table with Regular callers, who calls us frequently, with all the their statistics (sex, age, location). In the Calls table there is a linked field to choose the regular caller. I would like that if I choose a regular caller all the statistic data I already recorded in the regular caller table to be copied in the Calls table. But lookup fields are not good solutions for this, because if the caller is not a regular one (regular caller field is blank) I need to give these statistics here manually. In case of lookup the system does not allow it. Is there a solution for this? Thanks a lot Tamás

I have a view that is grouped by a single select field called Program Name. In this view I can see a count of records per Program Name. How can I create a script to give me a count of records grouped by program name? Ultimately I want to create an automation that will email me a summary of records by Program Name. I cannot do a linked field as the Program Name is a single select field chosen by a form.

Hi, I have a base that has two tables with linked records. Table1 fields : Name, Number, Sum (linked to table2) Table2 fields: Name, record, Table1, Total (roll up value of each category of name) This works beautifully manually, for every new record i create in Table1. But has been failing in automation. This is what I am doing: Trigger on new record creation: Note: in table 2 I have a row with unique “name” from table 1. In this action I am trying to find the record with name == name of the record created. And finally, Update the field “sum” in Table1 with the record found in previous step. The tests pass, but actually fails when a new record is created. Screenshot below. Apparently, it’s an invalid filter on the record. It appears simple and at this point I do not know how to fix it OR why it’s not working. Can any one assist in getting this to work please? Thank you.

Hello everyone! This is probably a simple question, but I could not figure out the answer. I have an Object and two arrays: const arr = [1,2,3]; const arr2 = []; const obj = {}; obj.id = arr[0]; obj.fields = {}; obj.fields["Array items"] = arr; arr2.push(obj); console.log(arr2); //array contains 3 items as expected arr.length = 0; //empty array console.log(arr2); //array is empty As I understand the Object instance keeps only a pointer to the array. Is it possible with an Object to keep a copy of array contents and how to achive that? Thank you in advance.

I am experimenting with Webhooks to move data back and forth between bases. I just want to make sure what I am seeing/doing is necessary. When I setup a test POST from an external tool to test the webhook, any data elements defined the JSON are created as values in javascript editor. However, I would prefer to read the entire json object as new fields may become necessary. What I did was create an object that looked like this: { "theData" : "Anything" } I tested the webhook and “theData” was available to the script editor. I then created a more representative object like this: { "theData" : { "fieldOne" : "Some data", "fieldTwo" : "More data", "fieldThree" : "and even more data" } } This works fine and my code is working. Is this how I have to set it up? If I send the second structure as a test, the script editor forces me to select one of the nested fields. I cannot select the top level key. It’s not the worst thing to have to do but it does seem like a bit of an extra step.

Hi! I’m trying to make an automation that will notify me when an entered record shares a field with other entries within a certain time. Essentially, we track issue tags and want to know if there have been 3 issue tags in the same state within a two week period (the state and receipt date are tracked as fields on the issue tag). My thought is to make a formula that counts how many entries within the past two weeks share a state with the given entry, and make that the condition for the automation. My question is, what formula (or group of formulas) would I use to look at other entries? I can’t seem to find formulas that look anywhere except inside entry that the formula outputs on. If I can’t do it with formulas, is there an app that will help me? Thanks

I’m a casting director. I have a table of Artists with their info and I have a table of Shows. To each Show I can assign multiple artists (they are linked). But I also need to assign a specific role to each artist involved. The kinds of roles are different for every Show, each Artist may be part of multiple shows. It is easiest for me, conceptually, to enter info per Show: Title, Date, (Venue and 6 more fields of info), what artists are involved and what roles they play. I don’t want to enter Title, Date, etc. repeatedly for each Artist in the Show.

Hello, I am building a base where I list fabrics, a little bit like a catalogue and each product (one product=one record) and have a set a fields for each to provide information on the product. One important information is the price, however sometimes the price is in €, $ or ¥ and I want it to be a number field so I can filter according to a value. For example if someone wants to look for a fabric costing between $0 to $5. The problem is that those 3 currencies do not have the same values ($1=¥ 6.5), so I had to create 3 different fields for each currencies but it makes the table quite heavy and harder to read (since there is always an empty field). I am trying to find a way to display the price only in one field whatever the currency. I would like to be able input the price and chose the currency and both would be display in one field. I tried this one is : “enter the price here” (number field) one is : “chose currency here” (single select field) and the last one is a formula field