Ask the Community

I have an object that I output from another script using the Output.Set(key: value) method. The value that I’m passing is an array of json objects. It seems that there are a lot of objects to transform the object but I would prefer to just pass the object to my script to iterate over the object and use dot notation to get the values that I would like.  I don’t see anything that just lets me keep the object as is and pass it through input.config only transforms or operations like length? Is there no way to pass an array or object??

I want to create forms to get reviews from some products I sell and for that I have created a Table which consists of the following fields:Product (linked to the corresponding "Product" record in the "Products" Table)Q1Q2...QnI want to be able to send form links with the "Product" field prefilled (using its RECORD_ID), so that the reviewer can easily know which product he/she is reviewing. However, I don't want the reviewer to able to change that value in the form and select by mistake any other "Product" record. How can disable the possibility of changing a prefilled value in a form?I have tried using the option "Limit record selection only in view" to another view, but it is not working.

Hello everyone, I hope you can help me! I am creating an product database for internal purposes. I have created a Softr interface and I want to have a customer chat bot to can answer basic queries such as “Does this product have x feature?” “What is the price of this product” etc… I have managed to create everything with the help of Chat GPT (I can’t code!) but once issue remains, when I try to trigger a database search, it constantly returns with “I can’t find this product”. I have searched the console, it says it cannot access the database because authentication is required and returns an error 401 or 403. I have checked the token, the database ID all and everything is correct, so I am a bit at loss! I am the owner of the database. Hope someone can assist with this, thanks in advance for any advice!

I have a base that is largely used for planning.I have a lot of automations. Often one action sets off a chain of 4-5 automations.Because I use this base for planning, records get deleted often as part of my workflow (i.e. I change my mind).An unfortunate, unexpected irritation with this is that reasonably often, an action will set off an automation > I delete the record before the automation is finished (these are usually simple automations "if Record A Field A = x, update Record B field A" - most are not long and convoluted).And so, I have a significant and frequent number of "failed automation: record not found" emails and notifications.Is there any way to prevent this happening?

What is a good website  to parse data from a pdf into airtable. For example if I wanted to parse info from a rental application (contact info, lease info) into airtable what is the best website to do this

Hello, I’m new to Airtable, (trying to help a friend build an efficient solution) and I’m looking for some advice. We have a form with a rather large multi-select field. Users must enter their name, date and select any number of options from the multiselect field. The information comes into the table in the way you would expect: But in order for it to work with my friend’s processes (and existing tables) they need a way to break the record up (ideally on form submission) into multiple records: I found a way to do it with automations. I created an automation for each Option to check to see if that option has been selected, and then create a new re

Howdy good people!Hoping someone can advise with a product code lookup scenario. Our team sells training subscriptions. New subscribers submit airtable forms to notify of catalog onboarding. Each subscription is tied to a certain product (9 product types currently). Product name auto-populates in a multi-select 'Product' field upon form submission in an 'Offline Subs' table. Each product has a set unique code stored in another table (Product Codes). We need to auto lookup and match the product name with corresponding product code and auto populate this in a 'product code' field in the 'Offline Subs' table (see attached). Playing around with lookup fields and can't see an automation option, imagining that this will require a script to achieve?I don't have any coding/scripting experience so hoping someone can share a similar successful script or use case experience. Any assistance greatly appreciated. 🙂

It is possible to use a wireless barcode scanner attached to an iPad to enter data into an Airtable. I need to do an inventory of over 17,000 items and want to scan the barcode of each item into a table. It would be much faster if I could just scan the item - record is created - and it advances to create the next record. Much like you can do with a scanner an Excel. I know I could just use Excel and then import it into a table in my base but I was just curious. Using the camera to scan each barcode would not be and option due to time. Thanks Brian

Good DayI have generated a base and from that base a form. Once submitted the form automatically adds the information to the base. When the new record is generated in the base I want to send an email to the person submitting the form. There is a field in the form where the person adds there ID I used that field in the To part of the automation and I am getting an error.  The below is the layout of my  automation In the Body of the text is a member number that is automatically generated when the form is submitted.When Generating a Preview I get an Error Message 

Hello AirTable Fam, I am trying figure out when a form is filled out and it’s linked to a client, their email address can be populate into another cell. Any help would be greatly appreciated.

Hello,I have a base and I want to create forms that allow some to suggest new entries into the base. Once the suggestion comes through I would approve it then merge it into the base. However I need to know who that person is and limit access to the form to okta users. Whats the best way to go about doing this?

I have a Master Inventory of all line items for a project. We then create Material Requests where we collate a number of these line items (maybe a few hundred) per vessel sailing. I need a way of effectively viewing the Inventory and selecting a checkbox or similar, then allocating these items to that Material Request. This creates a new record for that item. I can go into my material request currently and select individual items that are added, but cannot find a method of bulk selection and allocation.   

Feeling a little stupid because I can’t figure out how to do this. It is a simple task on a spreadsheet, but I have failed in all my attempts to get it to work. I am managing a construction project and I have creating 2 tables, One for electrical costs and another for Sprinklers Cost. I then created a third table, which I call it Dashboard. The intention with that table is to show the sums of all costs from the other tables. For example, on the sprinklers table, I have a column (Quote) with all the costs I have incurred so far. I did the same thing on the Electrical table. On the Dashboard table I have created a record for Sprinklers and another for Electrical, and for each record I need to show the sum of the costs for the tables Electrical and Sprinklers As per the images attached, I want to be able to show the value of $14,300 (sum of all costs on the column “Quote” of the Electrical table) on the record of Electrical #200,

I have a very simple automation that runs every 15 mins. It finds rows from a table that have data in a specific column and then uses a repeating group to send a slack message to each of the channels listed in those rows it found. This typically works 90% of the time but usually a handful of times a day it errors out for Slack API rate limited. Sometimes it errors out with 4 groups that it found but will also error out with 1 group. Experiencing similar issues related to the repeating groups for slack messages.  Any help is appreciated.  

Hi there, I am looking at creating a line graph in the interface. Is there a way to show multiple teams as the lines?  What I am hoping for is X axis to have the months and the Y axis to have the number and each month to populate the number is this possible?  Thank you 

New to AirtableJust cannot get this to workThe first 3 records….all the same - adds up to 22.In what I hoped would be a summary table - one record the same as those 3 using the MTOX fieldbut this is all I get 

Hi everyone! Our library uses an Airtable base for approving programs, some of which are one-time and others are repeating. We’re running into a problem where we’re sometimes overbooking on a single day (this is across multiple branches, so we have the room, but we try not to host too many programs on one day) and we’d really like to see all our programs on a calendar view. The problem is with the recurring programs. Right now, the base is set up with a text field where programmers put in their dates (e.g. “every third Wednesday from 11-12”) but obviously Airtable can’t read that. We could set up individual date fields for each occurrence, but some of these programs are staples, held dozens of times a year and would necessitate dozens of date fields. As a work around, I tried making a separate “Calendar” table with the dates as primary fields, and then in the main table, the date field became a linked record field. In Calendar, I created a calendar view and that techni

HelloI have two tables Customers and Orders. They both have a CustID to link the order to the customer that placed it.I need to import a CSV file to Orders and this includes the CustIDI can import as a regular field but can't figure out how to import it and have the Link to the customer tableThanks in advance for any helpMike

Hi AllI have a Base A with Table 1 and Table 2. One of the fields in Table 1 is a linked record field to Table 2.I also have Base B with Table 1 synced to this base.Rather than showing a linked record from Table 2 in the field in Base B Table 1, a text field with the entry in the primary field for Table 2 appears - is this expected behaviour? If so, how should the setup be structured to show the linked record? If I have a Table 3 in Base B that has a linked record field to Base B Table 1 and I want it to have a lookup field to the linked record field already in Base B Table 1, is that achievable?Thank you.

Hi, I am new here. I have some columns like name, email, job title. I have 3000 rows of these data. I want to send personalized emails to all of these 3k users with their name and job title. How can i do it? Is there any automation or extension available which can help me with sending these email automatically?Thanks for help.

Hey guys ! i have an interface for my customer with a form and other data. He wants the form to be prefilled with the same message “long text field” in the interface. See the screenshot. it it possible to do that? and how? Thank you

We are currently using dedupe to identify duplicates in our records.Since our records is growing, we need to do it in automated way everytime there's a new record coming in.Here's the scenario:When a new property address will be added, there should be an automation that will automatically check the current records that we had, and it will tag this new property address if it's a duplicate or not.We just want to have an accurate solution if there's a new entry coming in, it will automatically mark or tag as duplicate.You can just imagine a Google Spreadsheet, if there's a duplicate it will suddenly highlight the column with duplicates.Do you think it's possible?

How to make new inventory items automatically link to the corresponding room in our building by linking or with a formula or automation.When a new item is added, how can I make that item auto populate in another tab by room (multi select)?This is the base. We have a robust inventory with “ALL ITEMS” and items by room. We want each item entered into “ALL ITEMS” to populate in the room selected via “multiselect.This shows the multiselect tab. Any assistance is greatly appreciated!

Hello there, I want to create a form in Softr, connected to my Airtable DB, where my employees will input their availabilities for “next week”, so I need to generate automatically the “next week” concept. I have created a table “weeks”, with the following columns :Week number Year To generate the concept of “is next week”, I want to create a date field “today” that updates automatically on a daily basis, and then in the field “is next week”, put a formula. However, I don’t know how to automate the update of the date at “today’s date” . Can you please help ? :) 

I've registered a new OAuth integration record on my dev instance of Airtable, however when trying to perform the first step of authorization by getting a code I am presented with the following error:There was an error during grant authorization. Close this window and try again or contact your system administrator for details.