Other Questions

Hi, I’d like users to add new multiselect options when filling out a form. I’ve seen this discussed here. It’s for internal use so there’s no concern of the table getting filled with messy data. Thanks!

Hey all, We are using Airtable pretty heavily for our VC, Development Studio and our clients MVP’s, with the new interfaces features we are able to build out awesome dashboards in a quarter of the time it would take us with bubble or other no code tools. Using airtable with bubble in this way is super powerful. We’ve looked at stackerHQ for precisely this purpose quite a lot of times but it just didn’t quite fit, airtable seams to have nailed it pretty well. The only issue we are facing is bringing our dashboards client facing (for our VC), it’s a bit cost prohibitive to have 2000 users signed up to our airtable account. StackerHQ does this really well and I wanted to know if anyone has a solution for this or if Airtable is planning to do something here. We use clickUP for our project management but we want to bring our project management into airtable. ClickUp does users not too bad, their concept is that you buy one seat and you get 5 guest seats. Still wouldn’t do exactly what we wa

I have used the block “Page Designer” to create a 3x5 label which I would like to then print to a rolled label printer one at a time or as needed. We will affix these labels to the front of our job folders for internal use. Has anyone used a Rollo Label Printer – Commercial Grade Direct Thermal High Speed Printer or something comparable to accomplish this? It appears this type printer is used mainly for shipping purposes, and I am worried airtable will not communicate well with it for printing purposes. Any help or guidance would be greatly appreciated!

I’ve built a database of grants and funding opportunities, and a survey that asks users the questions to determine their eligibility for the various grants. I have a table that lists the grants and how the various questions have to be answered to determine eligibility. I’d like to create a table that populates which grants a survey respondent is eligible for when a survey response is submitted. How would I go about doing that? My first thought is that it would be a formula, ie if Survey Q1=X, Survey Q2= Y and Survey Q3 = Z, Awesome Grant = Eligible, Awesome Grant = Not Eligible. But Airtable doesn’t allow formulas across tables. Then I thought an automation, or a junction table, but neither of these seem to be the answer when I dig deeper. So, rather than struggle for another couple of days, help?

Hi–I thought I would keep this thread alive. Why are tsqueries not vectored? Does Airtable want us to create triplicate tables all linked by separate primary fields just to perform a simple search when adding linked records? Blockquote Hi everyone! I would like to know if it possible to search in all fields of a table while looking for a linked record (in another table). I tried to do that but I get results only from the first field.

Hello, community! I have the Airtable base of 10 000 companies - company’s name is used as primary field. The tax unique number of companies are in other field in Integer format. Every week in Excel format I receive many companies data with their tax numbers with important information (status of work and comments) which is not updated in Airtable. Excel file is updated periodically with actual status and comments. To integrate this file to Airtable is not possible as it is managed by other company. How to add important information (status of work and comments) about companies from Excel to Airtable base, using common identificator (tax number)?

How to automatically and regularly upload Excel data to airtable

I am designing on system where I need to fetch data from the tables from Airtable. Can someone let me know how the reads are charged in Airtable ? Can I go with a solution in which if the user opens the page, the data is loaded from Airtable Or Should I go with Daily Sync to a local database? Please advice

I’m certain this is a lack of understanding of JS or synchronous/asynchronous operations on my part, but: if I want to call Airtable.base.create through the Node.js module and actually get the created records (or error) returned to be used elsewhere, how would I do that? Currently, my code looks like this: export async function createRecord(record) { base('example').create({ "field": record["field"] }, function(err, record) { if (err) { console.error(err); return; } console.log(record.getId()); }); } I can get the information logged to console just fine, but I’m not clear on how to properly return it or assign it to a variable and use it elsewhere.

Hi all! I have trouble wrapping my head around a database I’m building for a client. The concerned DB is for equipment rentals and my problem is making clear what’s available at a given date for rental. In the Rental table, I have a field for the outing date and another for the return. When a new rental is made, we would need to enter specific in/out dates and see the equipment available for those dates. Any idea on this?

Hey, I am a project manager for an event venue. I use airtable to create day sheets for events that function as to-do lists for the day. My team regularly refers to the kanban view. What I am having issues with is I group the events in Kanban by date. Every stack in kanban view is a day. What I am having issues with is when you use filters to filter out events that have already happened, the stack for the day still shows up as an empty stack. This means either uncategorizing old past events or deleting them. Deleting them is not an option as we often have repeat clients, and uncategorizing them messes up the workflow because then uncategorized has a bunch of stuff in it and cant be a landing spot for new entries. Any thoughts?

I’m trying to create a formula to do “high to low” and “low to high” features on our website. It is not working right. I wanted to show just the cheapest if there are multiple rooms available in a property but it does not work right. Here’s the formula that I did. IF(IF(IF(IF(IF(IF(IF(FIND(“$895”, {Price (from Room Details)}), “$995”, “$895”), FIND(“$995”, {Price (from Room Details)}), “$995”), FIND(“$1,095”, {Price (from Room Details)}), “$1,095”), FIND(“$1,195”, {Price (from Room Details)}), “$1,195”), FIND(“$1,295”, {Price (from Room Details)}), “$1,295”), FIND(“$1,395”, {Price (from Room Details)}), “$1,395”), FIND(“$1,495”, {Price (from Room Details)}), “$1,495”)

I have read multiple posts on the subject, but none seem to quite answer my newbie questions. I have 2 tables: Animal and Priority. Animal table contains a list of animals and a link to a list of priorities in Priority table. The animals are grouped by Priority, which automatically sorts by Priority Name in alphabetical order. However, what I want is to sort by Priority Order. I’ve tried sorting by Lookup Fields, but that does not change the ordering. Basically, I want to see a list of animals ordered from Must Have, Nice to Have, Undecided, and Definitely Not. Animal Table Priority Table My workaround is to use a formula in the first column in Priority table to combine Order and Name like this: Animal Workaround Table Sadly this makes the tables very hard to read. And I have many more tables that require this type of grouping and ordering. Is there a way to accomplish what I want without using the formula showing “1 - Must Have”, etc.? Thanks in advance!

I’m wracking my brain trying to figure out how I can make this work. I have an Items table. I have a Locations table. I have a Location Records table that joins the two. An Item has many Location Records, and belongs to a Location through its most recent Location Record, and it has a history of all its past Locations through the sequence of all its Location Records. In the Items table, I can Rollup Location Records–>{Date}–>MAX(values) to pull the {Date} out of the most recent Location Record. But how can I pull the {Location} out of the most recent Location Record, so that I can display an Item’s {Current Location}? I can Rollup Location Records–>{Location}–>ARRAYJOIN(values). I was hoping the {Location} value from the most recently added Location Record would be the first in the array – then I could use: LEFT( {Location Rollup}, SEARCH( ",", {Location Rollup} ) -1 ) to parse out the first value from the array. But, of course, this isn’t the case – ra

Hi If I prefill Event Date using the following URL – It dose’nt populate the date in ISO Format. Please suggest. URL: Airtable Business Tickets Approval - Airtable Fill out the "Business Tickets Approval" form quickly and securely on Airtable. Formula used: CONCATENATE(‘https://airtable.com/shretOBZs7fKCPqk7’,'?prefill_Business+Ticket+Approver+Email=’, {Business Ticket Approver Email},‘&prefill_Event=’, Event, ‘&prefill_City=’, City, ‘&prefill_State=’, State,‘&prefill_Tickets+Requested=’, {Tickets Requested}, ‘&prefill_’**&**ENCODE_URL_COMPONENT ( ‘Event+Date’ ) & ‘=’ & ENCODE_URL_COMPONENT ( {Event Date} ), ‘&prefill_Venue=’, Venue ) Also I want to send the prefill URL to approver for approvals and I configure email automation the Prefill URL is breaking down to this? Please suggest? https://airtable.com/shretOBZs7fKCPqk7?prefillBusiness+Ticket+Approver+Email=rama.motwani@wwecorp.com&prefill

What happens to record links, interface and syncs, if i restore a snapshot … how can i restore it back to the same base ? Will i copy and paste all records back into the main base ? How come a free plan cant restore a snapshot but the creator can only do this ? I also have not deleted records but found some missing when I was inserting new records and even though I’ve clicked undo until there were no more actions, I still could not find the recrods

How to implement AMP emails to send forms with airtable. Does Airtable provide extensions to do the same

Show synced records and new records all on one timeline view Hello everyone I greatly appreciate any help in advance, I just need to be pointed in the right direction The Idea: Create a top level company holiday planner, including dates for holiday, sick leave and public holiday. Sync planner table with a lower level base, lets call it project planner. This will include projects, business trips etc. The end goal is to be able to view synced employee holiday planner and the local projects all on one timeline. With holiday data only changeable from its own base and all project data changeable The Issue: When using the sync table function, no additional records can be added to the table in the project base. I created a second table just for the projects records but also cannot find way to show both tables on one timeline. Any idea how best to do this? I was wondering if its possible for an automation to add, modify and delete a record to the the project table every time a change was made

Wanted to share a table and give them the rights to add comments to the table (in pre-defined columns for each individual). Right now I can only share “read-only” rights as I tried to share an editable table and was suddenly charged for 2 additional licenses. Could do this process via Google Sheets (and share the sheet with family members), but I like the format for Airtable. Any thoughts??

how do I extract the numbers before the first delimiter"|"?

My department tracks work tasks in Airtable. Occasionally someone edits something by mistake. The editor account can prevent changes the fields. Is there some one way to prevent a user from editing another user’s record. Example: Chris can edit any record he creates but cannot edit or delete records created by other users.

IF({Company Name}, {Company Name}&“:”&IF({Training Date},DATETIME_FORMAT({Training Date},‘MM.DD’))&““&{Main Instructor for course}&””&{Course Catalog},BLANK()) Is it possible to add two checks inside the if like a "IF({Company Name) and {Date Started}) to that whole statement so that if both are active THEN it proceeds, otherwise Blank?

We’re using Airtable to manage tasks assigned to specific people. Can each of those assignees export a calendar view that shows only their tasks?

Hi I have a table synched to google calendar. I would like to extend the “synch range end date” referred to here > Airtable Sync Integration Google Calendar | Airtable Support Can this be done as an edit or will I have to create a new table/synch Appreciate your reading the question. James

Here’s a short Loom video that explains my question with examples: