Other Questions

Hello community, Hope that you may help me with this one. I am trying to build a system that will help my with inventory tracking. So far so good, and there are many great templates and tutorials out there. HOWEVER, I haven’t figure out yet how to solve my issue: From time to time, employees take equipment from our warehouse for a specific project, and I want to keep track of everything. I thought about making a table for each time someone takes something, and then finding a way to reduce the amount of available items from the amount of items that went out from our warehouse. but - I have no idea how to do that. Making a row for each project is not ideal as well, because each project uses several items with different quantitates. Any suggestions or tips? THANK YOU!!!

Hey all, I have two tables that I need to link. Table 1 is a table which gets daily new info. In one column, I have to concatenate. This changes daily with the new information and therefore needs to stay as a formula. In Table 2, I have a sort of database of possible concatenation options with responding values. These two values need to be selected according to the newly created cell in Table 1. In Excel, this could be quickly done via a Vlookup, but I struggle to do this in Airtable. Has anyone had a similar problem and can offer a solution? If you need more info, please tell me. Thank you

Hello, I have a question regard to billing. Is it possible to set the owner in PRO account while other billing collaborators under PLUS account? Sincerely, Michael

Hi! I am building a CRM base (This is my first one!) One of the fields is “due date”. is it possible to mark a record that is overdue for 3 days? Daniel.

Hi all, I have tried for over 2 hours to get this to work, but can’t seem to. I am trying to update a barcode primary key field. but the closest I got was this error message: Type ‘string’ is not assignable to type ‘{ text: string; type?: string; }’.(2322)

Is there any way of moving completed records to a different table so that I can remove finished jobs but still be able to access them for invoicing reasons? A previous recommendation was to filter to exclude certain records but I can’t for the life of me see how to do this! TIA

Hello, When I add a new client, there are a series of about 40 tasks that need to be done and tracked. Is there a way to automatically create those tasks in airtable without having to re-create every single one? Thanks!

Hi I am setting up an Integtomat scenario to backup Airtable bases with Webhook and using Airtable API. I am using blobjson to create and make a call. I keep getting a syntax error. What is the correct syntax for JSON? I have an HTTP module in my scenario, bug I don’t know what endpoint fo I use on the HTTP app. I have two linked tables, so do I use “Retrieve Records” or “Create Records” in Airtable API? Thank you, Mary I can post more info., I sent just going out. Thank you!

I have two columns that I pull data in from to make a linked form. Third column (forms) needs to have “clients name - root form” like “Yoga studio - Yoga Waiver company”. This now links the form to the second sheet, where we keep the status on each project. One client/record often has several documents and each o them needs to have a separate status. Something like “Yoga studio - Yoga waiver Company” and “Yoga studio - Employee agreement” does anyone know how I can auto generate the third column?

Hi All, I have created personal views for users since multiple users are working on the data. They are editing/adding the data in their sheet only and the same is being reflected in the mother sheet which is a consolidated file of all the users data points. Now, we are facing the issue that there are some data points which are being shown in the Mother Sheer but are not reflecting in the user’s personal views. How is it possible? Can this happen if a user deletes the data in his personal view and the same is not being reflected in the mother sheet? What am I missing here Thanking you in anticipation for the help and support.

I have a question about the billing process and why collaborators are so expensive. I used to have a Pro account because I wanted to create a form with our own logo at the top of the page (this was the only reason we needed a Pro account). That said, it was a form for a singing competition. I wanted to bring in a few judges to see certain views created for them as a part of my base and judge entries using the table I set up. When I invited them in, I quickly realized that I was about to be charged $24/month PER JUDGE because I was giving them access to edit my table. I was shocked and so frustrated. $24/month (I didn’t want to pay for the whole year because the competition (free, no money involved at all)) was only a few months. Anyway, I was shocked that I was expected to pay for a FULL ACCOUNT for each of these collaborators. Why?!? Seriously, why?? If I have a pro account, and I invite someone to edit one page of that account, I have to pay for them to have a full account, which mea

Is it possible in Airtable to create some kind of company hierarchy such as: Company 1 (parent) Company A (child) Company B (child) Company C (child) Company 2 (parent) Company A (child) Company B (child) Company C (child) To try and help you understand what I have and what I want to achieve, I have simplified my base as follows: I have an Accounts table: I have a Projects table: I have a Tasks table: What would I need to do to find out (link) which projects/tasks Company 1 (parent company) are working on? As a start, in the Accounts table, I created a ‘Parent Company’ field that is linked to the Accounts table (I’m not sure if this is right or not) but I can’t figure out the next steps. Can anyone help?

It would be great to be able to select the deliminator type for single and multiple select fields. For example if I’m pasting in a list of items that I want to be options and some contain commas it currently breaks those into separate listings. Whereas if I could set the deliminator type to only new lines or semicolons it would maintain the list items as I would like to use them.

Hello! I work in higher ed, and am trying to set up a highly automated CRM base. We’ve used Zapier for ages to create and update records in Google Sheets, and are shifting our process over to Airtable to allow more users access to the data. The primary challenge I’m encountering is in logging interactions. I have a Contacts table (with Email as the unique identifier), and an Interactions table (with things like General Web Form, Event Registration, etc.). So if a candidate fills out the General Web Form, I can have a unique Zap with the text ‘General Web Form’ dropping into the linked records --> Interactions field and it works like a charm. The challenge is at the second point of conversion: let’s say Event Registration. Zapier can locate the record, and then updated it – but If I use the same trick, the integration will overwrite the existing data in the linked records field, so I lose the General Web Form conversion. Ideally, those conversions would stack up in the same field (li

Can a video be attached to Airtable from Dropbox or a link to drop to it?

Hi, Here’s a time sensitive question I’d love advice on from those who know SendGrid & Intergromat. Can you kindly advise on: Using SendGrid block, can we use one or both of the following SendGrid account products: (a) Email tool and/or (b) Marketing tool. (The two SendGrid tools are shown here: https://sendgrid.com/pricing/) Using Intergromat integrations (link below), can we use one or both of the following SendGrid account products: (a) Email tool and/or (b) Marketing tool. (The Intergromat integration info is shown here: https://www.integromat.com/en/integrations/sendgrid) Do both the SendGrid Email product and SendGrid Marketing product both have API connections or only the Email API plan? (See plan options in link in #1 above). Thanks SO much in advance!

Resources Apps support Overview Apps Marketplace Adding an app to a base Managing and organizing apps Browse topics by app 3D space Base schema Batch update Cal import Chart Chime Clearbit Color palette Contact import Countdown CSV import Dedupe Description Embed Flashcard Formstack Hangouts Jira cloud Loom Map Matrix Miro Org chart Page designer Pexels Pivot table Record list Scripting Search Send sms Sendgrid Summary Time tracker Timeline Translate Typeform URL preview Vega lite Vision Web clipper Whereby World clock XML import  

Adding records is simple, but is there a way to have the blank row with the plus symbol appear at the top of the table instead of at the bottom? My users are complaining that they have to scroll to the bottom in order to add a new record.

Hello, i’ve create a database with ingredients, recipes and meal plan tables. I’ve linked my recipe with a list of all ingredients inside this meal plan table, then my goal is to add a multiplier field in the meal plan table to adjust quantity of each ingredients of the list. Is it possible to have a lookup field with a liste of values (number and text) and multiply these values (only numbers) ? Thank you for your help Best Regards Brian

Hello! I have two tables “Episodes” and “Team/Dates”. “Episodes” has a single select field called “Status” with 20 non-alphabetically listed options. When I create a linked lookup field in “Team/Dates” to the “Status” column in “Episodes”, it imports the field as text. Is it possible to import it as a single-select field? Or to somehow retain the sorting order from the “Episodes” single select field? The two workarounds I’ve found so far are adding a numerical prefix to each status (e.g., 01 Script, 02 Storyboards, 03 Edit) or using a formula in the second table with an emoji in front to do sorting. Thank you!

Hi! I’ve been looking around the forum and Reddit for a solution to copy records from one base to another using the scripting block. I just want to know if this is possible and maybe see an example to use as a reference. The idea is to get all the records from Base A Table 1 and copy them to Base B Table 1, without deleting existing ones. I need to have different bases so the data and permission management is easier. Thanks for any help!

When importing a ics file with recurrence I am loosing information I want to include namely which day of the week is used (See RRULE field). How can I get this information pulled in? BEGIN:VCALENDAR VERSION:2.0 METHOD:PUBLISH BEGIN:VEVENT CLASS:PUBLIC CREATED:20200611T184358Z DESCRIPTION:Regression Data Collection\n DTEND;TZID=“Eastern Standard Time”:20200611T163000 DTSTAMP:20200611T184358Z DTSTART;TZID=“Eastern Standard Time”:20200611T160000 LAST-MODIFIED:20200611T184358Z LOCATION:new grid PRIORITY:5 RRULE:FREQ=WEEKLY;BYDAY=SU,MO,TU,TH,FR,SA SEQUENCE:0 SUMMARY;LANGUAGE=en-us:fred END:VEVENT END:VCALENDAR

Hello - I recently created a Custom form using the ‘Encode URL’ component to prefill fields on a feedback form for our members. We email the custom URL to customers but when they complete it, it’s creating a duplicate entry on the grid view in Airtable vs updating the record with the URL we sent. Anyone else experience this? Is there some way to prevent it?

Hello, we have approximately 100 staff operating remotely and we use airtable to keep track of when they are available. Every week they email me in their date gaps that they are available and the location they will be in at the start and end of the gap (e.g. 11 June 2019 London - 10 July 2019 Paris). We need to know when they are free (not when they are working). At the moment they email in their dates and I manually enter them into the system. The dates are constantly changing and updating. So far airtable is great for keeping track of the dates and gaps, but if data entry could be automated at the staff level to enter their dates it would be a great time saver. Is there any way to have our staff be able to use a third party app or similar to edit their calendars which then when they complete an update it will automatically update their view in Airtable? We have a view for each staff member and rows representing each available gap. Columns showing Name, Date free from, location, date

What is the formula for using a birthdate and creating a field to show current age today?