Other Questions

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 midline and endline, the data co

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 the same product name in each of those records. The goal is to

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. const allUsers = await table.select().all(); const filterUser = allUsers.filter( (user) => user.fields.user_email === userEmail );

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!

Hi, Is there a way to rearrange the data in my gallery view. At the moment the ‘title’ of the card (“Cognitive Restructuring” which is the table’s primary field) appears below the attachment preview. Is there a way for the title to be at the very top of the card? Thank you!

Hi, I’m managing tasks that must be done for example each first monday on each month. actually we are creating the task manually. Is there a solution to be able to create a new task on the next first monday of the next month when the previous one on marked as “done” ? Monday is only for example it can bee the last thurstay of the month too. Thanks

Hello! I am wanting to create a field that will automatically add either “Week 1” “Week 2” “Week 3” Week 4" or “Week 5” depending on which week it is in the month, i.e. this week June 26th would be “Week 4”. Is there a formula I can use to create this? Thank you!

Hello everyone! I’m new to Airtable and I still have trouble using formulas, here is what I’m seeking to do: I would like to know if a row in a table let’s call it table1 repat itself in another table (table2). To do so if possible I want to have a detector in table3 and two other fields linked to table1 and table2 so it would be automated. I think the automation is too complex for me to do, so I would appreciate if someone has an idea on which formulas to use or even know if it’s possible to know if a row repeats itself in another table. Thank you for your help!

I am running Airtable on Windows 10. When I try to print to pdf, A4 size, the print to fit option appears not to work, i.e. fields are printed off the edge of the page. This happens with both the Foxit PDF printer and the PDFCreator printer. I ahve also tried Letter size, but same result. Any thoughts? Neil

Hello: I am trying to use Page Designer to generate reports from various records and tables, but for certain records with large amounts of data I need more than one page to display everything. Is there another app that would work better? I would also like to create a report with a static URL for each record so non-Airtable users could view their data without signing in.