Other Questions

Hi all, I have a team of people who need to import data into airtable. I dont want them to actually go into airtable and import themselves. An ideal example would be, the user creates a CSV or XLS doc, saves it to a specific place, then airtable sucks it up and imports as new rows into a specific table… Any suggestions or thoughts on this? Thanks!

I have a view with a linked field to another view. When using the Download CSV option on the view the resulting export provides the values of the linked field and not the record ID. I understand that this makes sense but for my use case, I need the record ID’s as well. Is there a way for me to export a CSV of a view and get the Record ID’s instead of (or as well as) the values of a linked field? Thanks! :slightly_smiling_face:

Hi, how can I get referrals from an airtable I am sharing? Meaning getting referrals for every person who starts using airtable in order to use the airtable base I am sharing

hello, Looking for a way to filter all the @mentions with name in a table view? I tried searching for my name but no results. Any suggestions or even integrations with other apps that can help me? Thanks

Hi guys, Is there any formula to get the day (24hrs) before a release date? Thanks!

The PIVOT table in airtable summarises data. But I want to view data in columns dependendent on a given criteria. Please see attached image for clarity. I want the columns based on student names to see all students performance at a glance

I have a large table of entertainers, bands etc and calendars for each of them (around 300). I am looking for an app or a script where someone outside of airtable can search a single date or a date range and see which of those bands are available on that date.

I have a view set up by groups with subtotals. I want to then sort by the subtotals. is that possible? I can’t figure out how to do this and it seems it would be a basic function.

I have a regex that i tested with Regex101 and it worked. Purpose of this regex is to extract the remaining words after “XXXXX-YYY-ZZZZ” But in airtable i got #Error! Number 1. Extracted a pattern Number 2. I constructed regex exactly the same as that in Regex 101 Number 3. I used this formula What am i missing?

I created some automations that create and update a calendar that we plan on using as a shared events calendar in my organizations office. When I created this, I just tested in on a blank personal calendar I created in Outlook. We have since created a “shared calendar” in outlook. But when I went to change the automations to put events on that calendar, it can’t find it because it only shows the calendars affiliated with my email address account. I am an owner of the shared calendar, and tried logging in using the email address associated with the shared calendar, but it just defaults back to my personal account when I log in. Anyone else have this issue?

Hi guys! I have a table called “Production Stage” (reference below), with lots of dates which can be quite tricky to look at. So I created another table “Project Breakdown” with a simpler view and only have Start & End date. I need to fill up the dates in Project Breakdown by linking it from the Production Stage, but by linking it, it creates a record for the entire line (vertically) instead of just in its specific category. For example, a date was created for “Drug Bust Pre-Production End” in Production Stage, and I want it to appear in Project Breakdown but only under “Drug Bust - Pre-Prod End”. I hope this made sense. Is there any automation that can help with this? Would appreciate the suggestions in advance! Production Stage Project Breakdown Table

Hi Airtable community! I have a field in my table where I need a formula that outputs the name of a project Slack channel based on the name of the project. However, since Slack only allows for lowercase letters, underscores and dashes, the formula writing is a little complicated. I need to convert all letters to lowercase, convert spaces to underscores, and not include anything that’s in parentheses. For example, the project name is: FA22 Project Name / Project Detail (Project Subtitle) And the output I need is: fa22_project_name_project_detail Help is greatly appreciated!

Hi, Every day drivers fill out a form to indicate the vehicle they drove (via reg number) and the amount of charge left in the vehicle ‘Charge’. I would like the form to automatically update the vehicle record in the ‘Charge’ section every time a new form is submitted for that specific vehicle. I need it to be intelligent enough to base the update on the vehicle that was selected. Is there any way to do this? Happy to use extensions if it helps, Thanks!

Hello, I can’t select cells to include in final result. Please help with how to fix it. Thank you!

Grouped Records Total Counts Don’t Print. Any Solutions?

Hello! I have a base that shows me 3 things. Employee Name Vehicle Reg Vehicle Number (via a lookup based on Vehicle Reg) Route Number These things are dynamic and change every day. Before the employee starts working we ask they fill out a form confirming their name, vehicle and route number. I have configured name & vehicle to prefill when the employee clicks on a link next to their name. I would like to keep the field on the form that asks them to type route number in. However, I would like their answer to be checked against the relevant record and if answer and base info match relay a message to say ‘Correct, please proceed’ if not, ‘ATTENTION, please seek management, do not set off’ (ideally also not allowing them to submit the form) I would also like to add a lookup field that displays the Vehicle Number on the form (if possible!) Thanks!

Is there a way to organise the view in my bases homepage? So I can put all the budget bases together, all the project plans together etc. So I can find things more easily.

Hi Airtable Community! I’m in charge of an impact assessment program and Airtable is a great tool for collecting and managing the beneficiaries data. The only problem that I’m facing is that we are active in many regions of Tanzania, where the connection is not great or not present. I was wondering if there is a way to collect data via a cell phone and then send it to airtable once the connection is available. Can the Airtable app do that? In the past we have used a survey app called Kobotools to do that, and it is possible through a webhook to send data in Airtable (at the moment I’m using Make to automate the integration). But it would be great if it would be possible to do that directly in Airtable, in order to have a perfect match between the beneficiaries data collected for the baseline at the entry to the program and the midline and endline data collected throughout the participation to the program of the beneficiaries. If I use Kobotools for the m

I use the dedupe app extensively in a few of my bases to ensure we do not get duplicate data after imports. however recently, and I think this has come in after the extension update the dedupe no longer displays all the information on the card instead it will only highlight the field to dedupe against. This makes it difficult to identify which card has the most up-to-date information, or information that can be merged. Has anyone else experienced this or is it something that’s isolated to me, or has there been an update and configuration I need to go through to make it work the way it did previously?

Hello- I am really struggling here and Airtable doesn’t have a solution as of now. I work for a creative design company and need to review large Indesign PDF files to scale but need the ability to annotate directly onto a PDF, anyone know of anything that is an extension to Airtable so I don’t have use a third party application as that’s the whole point of using Airtable to have one platform for all. I have tried Markup hero, Govisually, Miro, none are simple to integrate. Scott

Our current CRM auto populates customer records with communications. When we email customers we also have BCC address that automatically copies the email into the communications section of the customer’s record. I want to switch from our CRM to an Airtable solution, but this is a fairly routine and important function. Can Airtable do this? and if so, how? I find Zapier difficult and bit above my pay grade, so any help would be much appreciated.

The problem is every time I bring up the table it adds today’s date in there what I would like to do is only add the date once when the record is created.

Dear Community, I’m new to Airtable. I have a table that includes parts and tasks. In other words, if Task 1 includes 5 different parts each record will have a value of “Task 1”. The same is true for parts associated with Task 2. What I’m trying to accomplish can be done in Google Sheets using a Query function, but I’ve not figured out how to do this in Airtable. When our company makes a sale of a new Air Conditioning system, there is a product description list from which the sales person makes a selection. Examples: 3.0 ton Complete Gas System HVAC and Furnace - 14 SEER 3.0 ton Complete Gas System HVAC and Furnace - 16 SEER 3.5 ton Complete Gas System HVAC and Furnace - 14 SEER 3.5 ton Complete Gas System HVAC and Furnace - 16 SEER, etc. Each product has a list of Parts and the appropriate Quantity(s) to deliver the job. So, if the first product is selected, there may be 10 parts related to that product - all of which have t

Hi there, I"m new to Airtable and I keep seeing this “Invalid Filter By Formula” error. I’m not sure what parts went wrong but this is my code: Are there other methods to get a single user ? THANK YOU for your help ! THE CODE export const findUserByEmail = async (userEmail) => { const userRecord = await table .select({ filterByFormula: `user_email=${userEmail}`, }) .firstPage(); if (userRecord.length !== 0) { return userRecord[0].fields; } }; The ERROR AirtableError { error: 'INVALID_FILTER_BY_FORMULA', message: 'The formula for filtering records is invalid: Invalid formula. Please check your formula text.', statusCode: 422 } My temporary workaround solution is to use JavaScript filter method - probably not ideal but I haven’t figured out other solutions yet. e.g.

Hello everyone, Does anyone know if it is possible to create a form in Airtable that allows multiple entries in one single form? For example, the form is used for our stakeholders to import details of various interviews they have conducted for a single piece of research i.e. personal details, interview feedback, moderator details etc. Rather than them complete multiple single forms which can be time consuming, I was wondering whether there was a feature that allows multiple entries in one single Airtable form. Thanks in advance!