Other Questions

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 design firms out there who are willing to share their base?? If not, anyone open to sharing a good starting point? I didn’t

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 the activities related t

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.

Hello All, I am using a iPhone mini 12 on the latest iOS 16.1.1 When using {Date Field} on a mobile device and clicking in that field the date picker shows up in Rolodex form. Weekday,Month,Date,Time. However when rolling forward passed the new year or backward into past years there is NO Year displayed in the window! This makes it very challenging to “Pick” a date from years past or future. I know I can manually type it in when going way back but perhaps a “Rolodex” format for the Year as well in the top of the “Pop Up” picker would be nice?! Please Confirm and Advise Thank You Jonathan

Hello, I have searched the “ask the community” and the FAQ and am not finding the answers. I am able to set up the trigger for automations, but I would like to be able to do two things in the action of sending an email. 1.) I would like the email to go to the person listed in the “owner” field. (example: AirtableOwnerEmailscreenshot1) I have tried to put an email address in the “owner” field, but so far no luck. 2.) I would like the message body to include the “month” field. (example: AirtableOwnerEmailscreenshot2) Any input is greatly appreciated. thank you - Kitty

I took over a team a number of months ago that has responsibility for Airtable. The previous owner left the company and is unreachable. We are at our limits on usage and need to upgrade. Additionally, we have users we need to remove from the account. I am currently an Editor on our workspace. We have some Creator roles as well. But, the owner is no longer accessible. I went to the in-app Help and asked my question there. None of the situations seemed to apply (or I misread them). I am a novice at the product. If anyone has been through something similar and has specific suggestions I would really appreciate the help. As additional info, I did open a support ticket. If that is my only option then that is done. I am just hoping there is something I can do before support reaches out.

hello everyone. Does anyone had this problem