Other Questions

HelloI need help with creating a Laundry Booking systemLooking to create a calendar view with the ability to let people book a time slot to use one of the Washing or Drying machines in my Building.The booking info can then be displayed on another tableI would like to use Frontly to display the data as an app.There are 2 washers and 2 dryers and about 150 peopleI have searched Youtube trying to find a way to do this for over a week now and I have come up empty.Any help in putting this together is very much appreciated.Thank you

Hi there,Simplified explained, I have a newsletter.The email addresses and other user details are saved in Airtable. The content of the newsletter is generated with Airtable automations. I want to send a personalised email to the users asking them if they want to unsubscribe.Rather than them needing to reply me to me via email I would like to add a button to that email if when clicked would update their status in the Airtable record to "unsubscribed".Is this possible?Thanks, Jakob

Hi, I’m trying to set up a form for our baseball league to collect scores from games so we can then do additional data manipulation to calculate win/loss records, calculate total runs for and against etc. The first single select field that I’ve created is to capture the team’s age group. Based on that choice I then want to have a drop down that only shows the teams that are in that particular age group. We’re tracking information on 100+ teams, and I’d like to do this in a single form so we can give our volunteers a one place to go to do their entry regardless of the age of the team. I’m trying to figure out how to populate the second single select to remove the possibility of our volunteers entering a name manually and spelling it differently than we’re expecting or calling the team something different than how we have them in our records. (Think Cards instead of Cardinals)? As an example we could have: 9YO: Cardinals, Rockies, Giants, Mets, Dodgers 10Y

I run a photo studio that photographers rent out for the hour/day and I use Airtable to keep track of these bookings. I like to view bookings grouped by month so I can get a sense of how sales are doing each month. To do this currently, I have bookings sorted by “start date” which is a date field (eg. “01/02/18”). This places all bookings in newest to oldest order (9-1), but everything runs together and and I can get a sum total of monthly sales easily. To address this, I added text a field called “month” to each entry and manually type in the month (eg. “01 January”) when I log a booking. After that, I created a “group by” rule that groups everything by the month column. This worked ok for 2017, but now it’s 2018 and 2017’s January bookings are mixed with 2018’s. The obvious solution would be to add a text field with “year” (eg. “2017”, “2018”) and then group by month AND year. However, it seems dumb to me that I have to manually add month and year to my record when I

I have an Automation set up to append items to an existing Rich Text Field, in the format of a checkbox list. The append Automation works well, except it always leaves a line break above the appended item, making a blank line in my list. The Rich Text Field looks like this (after the append Automation is run): Existing Item Existing Item Newly-appended item Does anyone know why this is happening, or how to avoid it? Thank you!

Hi Airtable community, I am new to Airtable and have landed a major Interior Design project that I hope to use this resource to organize. There are a number of needs that I have that I believe are outside of my beginner level to set up properly. I’m hoping someone out there can help me. Another user @caroline_bolt posted about this very thing but I don’t see any advice from the community. Wondering if Caroline ever got it sorted?! This project is a 5,000 sq. ft. home so I need to track a lot. Rooms and what tasks need to be completed for each *Design Implementation: What phase, dimensions, etc. Purchasing: Supplier, Supplier quotes, Retail price, designer discount, sell price, production timelines, estimated delivery dates, etc. *Existing pieces: If we are refinishing / reupholstering. Tasks to be applied *so much more. *Tasks to be completed Any other interior

I have created a PDF Form for ordering food, where a user can enter number of food items and then the form will calculate the total. Is there a way I can import the data from PDF Form into Air table, atleast the total cost? Thanks in advance.

I used to be able to add a new record on the interface of my Airtable, it used to show up at the bottom and look like this (this is an example of what it looks like in the backend of the database) but now when I look at my “Interface”/frontend it no longer gives me an “+ Add New Record” button, is this a recent Airtable change?

How to automate extension work I have a table when creating an id (auto number,(a record)) I want t its create automation QR code with QR code maker otherwise I do it manually .

Hello guys, how do I validate that the hour is not repeated in the following record? it is for a meeting room reservation application.

I have a grid view that is sorted by date 1-9, meaning it sorts rows from closest date to furthest date. This grid view of mine also has rows which have no dates set (yet) and I’d like to keep those in there BUT, I want those rows to go at the bottom of the sorted list. Right now, the only way to put them at the bottom is to sort 9-1… but then that puts the latest dated rows at the top. Any way to put non-dated rows at the bottom, but keep the 1-9 sort?

Hi Everyone First post, relatively new to Airtable but getting in deep! I’m hoping you all can help and that Airtable is the right solution! I work for a company that makes artworks for artists and I’m hoping that Airtable can help organise what we do as it can get quite complex. What I’m looking for help on is the scheduling of multiple detailed projects. There are all these lovely views - Gantt, Timeline, Calendar - but it seems like you can only view one table in such a view. But what if you need to coordinate multiple projects together? Is that possible in Airtable? If it helps, the basic workflow is: set out a project timeline ie. durations > apply that to a timeframe ie. dates > look at those dates related to other project timeframes > move things around to avoid overloading, schedule more help for busy periods, etc. Hoping there’s a solution… Thanks Jon

Hi there! I was wondering if there is any way to create new records in a table that is synced? I use Airtable to keep track of projects that are happening in our theatre. Here’s how our workflow is built : our main base is called Operation (and it is the only one), in which we gather all the informations about our shows. Then different collaborators add new activities that are related to their department. One thing that is important to mention is that everyone is working in the same base and it is a mess, not to say a nightmare. When someone makes a mistake, it takes me some time to find what is going wrong to fix it. And so many views have been created that it is difficult to establish an effective work routine. So I thought about making changes and I came up with the following idea : create separate bases for each department, in which all the informations about the shows would be synched, and then each staff member would be autonomous by creating and managing

Images are not being displayed in newly created tables. What can I do with that?

hey i have problem with my automation from MAKE and it move duplication of records. i want to know how can I delete duplicates by email? i mean - check for any duplicated email, delete all row. Thanks!

Hello, I’ve got a table set up which is to hold flight data. So I have airport from, to and date/time fields. I would like to have the timezone listed in the time field as it is always local to the origin or destination. Is this possible? When I select show timezone it appears at GMT automatcially but I can’t then change it. Thanks

I am having a hard time understanding the many to many table linking situation and how it can help me. I have 2 tables with the same data columns. I want to combine both on a master table. My issue is when one column is linked to one table then how in the world will you on the next row down get the information from another Table I need? Airtable Master Table Linking - Airtable Explore the "Master Table Linking" base on Airtable.

Before the forum goes down temporarily I’d apprecate please help for how to use OR in a formula field. Example: three fields: Number 1 Number 2 Total I want to enter a decimal number is Number 1 or Number 2 (but not both) and have the result displayed in Total. So far I have managed to get some respone from OR({Number 1},{Number 2}) In Number 1 I have entered 45.00. In Total, however, the display is 1.00 whereas it shoukd be 45.00 tia

Is it possible to embed an entire base (multiple tables) while not allowing hidden fields to be visible?

Hello, I need to create a very simple interface plugged on a single table where I want to apply hierachical filters such as Main Category / Sub Category / Detailed Category and display the line resulting from the applied filter. I cannot use Airtable interface to do so because I do not want users to have to sign in before using the interface. I tried with SoftR, but I could not find a way to implement hierarchical filters. Does anyone know about a no code tool that I could use to do this? Thank you Pascal

I have three tables, States, Cities, Streets. A street is linked to only one city, and a city is linked to only one state. Of course, a state has multiple cities, and a city has multiple streets. How do I get a view/interface to show every unique combination from the three tables, one per row? For example: Texas - Houston - Main Street Texas - Houston - State Street Texas - Dallas - 1st Ave

I have a table organized by educator name. I’m trying to create a column that pulls the FIRST occurrence of coaching from a separate base, so we can see on what day each teacher had their first meeting with their instructional coach. The dates vary widely, so I’m not sure how to write this formula. Each coaching session has a unique ID: “[Coach Name] [Teacher Name] [Type of Meeting] [Date]”. I’m hoping that it’s possible to write a formula that can find all of the unique IDs for a particular teacher, and then show me just the oldest one (which would be the first in the school year). I’m a pretty new user of Airtable, so thanks for your patience with what may be a basic question :slightly_smiling_face:

I am not able to notify the whole channel on Slack using @channel in the field box for automation. Can someone please help?

I have a database of road bottlenecks for bikers in the region. Users of the shared database can only see the bottlenecks, they can’t make changes. The database has views of bottlenecks in and around a specific town or village. Is it possible to also add a form-view where unknown users can send a form with data to be included in the database. The data will only be included after my agreement. In my attempts until now I only can see the design of the form, not the form itself

Hi guys I’m having a bit of a complex challenge with airtable. So I’m making a backend for an app on airtable, the app uses a complex nested tagging structure. I was able to put all the tags on airtable via Parent and Child Tables, then I linked each parent and child according to their relationship, using lookup fields to present all fields on the parent table. Now I’m trying to figure out how to record a Tag on a table, so that on a form a user can type in or select a tag on any nesting level and the record will be tagged with all the parent tags before it, and then in future be able to filter for that record with any of the parent tags. Hopefully, that makes sense and is feasible. Thanks in advance, I tried searching the forums but really didn’t understand many of the explanations being given.