Other Questions

I import data into a table, and one of the fields is a booking number, which is unique.How can I make this field unique, that the import doesn't import the same ID including all the other data several times? Thank you,

I designed a base and had someone I hired on Upwork make a base on my free account. Now I want to start my paid PRO ACCOUNT - However the dialog box says " Your paid account will start in 7 days"  I need it to start now because I need to add more extensions than free allows....  PLEASE HELP

I’m in the process of creating a form the interested clients can fill out and submit. One of the fields is a Number (Integer) and I wanted to know if there was a way to give a maximum value. We don’t want to accept the entry if the value in this field is over 100. As far as I know, there is no way to pop up a message or to prevent the entry from being submitted. We would not want the client to proceed with all of the actions driven by the form if their numeric value is greater than 100. I know I can use a formula to determine if the value is greater than 100, but I don’t know how I could use that formula in a form. Thanks in advance.

I require a client to advise me of the show name, ep & series number and duration of each ep they are sending me.I've created a form which works great but only for a single entry. I need them to be able to do bulk sending of this dataI know I could create fields for Ep 1,2 3, etc and separate duration fields for each ep to help capture the detail via a Form but this seems inefficient and some TV shows have 100s of eps and multiple seasons. Is there a better way to approach this which allows for a Form to capture the ep number and its corresponding duration for an entire season of a show? 

Hi,I use a numeric field and sort my linked records in the Interface Designer based on the numeric field. I have some automations that set the number of new records and users can also manually renumber records. This works well for creating records one after the other. However, I want to be able to insert one or more records between two records and keeping the sort order.Example: I want to add one or more items between items 2 and 3. I get stuck!

Is there a way to synch with Mapsly when a record is deleted in Airtable?

My VA has been trying to import files from Google Sheets for days but always ends up having the same issue.Each time she asked to log in to Google Sheets to import from there she ends up having an error 400. We have been cleaning cookies and all but nothing seems to work - See video recording of the error hereAny help/ guidance or how told solve this would be extremely valuable.Thanks

So my title may not make much sense, but here is what I have going on.I have a base that has 2 tables. I have a building table and I have a Tasks table. I have them linked in that some tasks are needed in multiple buildings, so when a task is created it can be assigned to any building that needs that task. However, what I want to be able to do is make a building specific note for each task that only shows for that buildingAs a hypothetical example: I create the task "add signage" and it can be assigned to building A, Building B, Building C, but not D or E, etc.In addition on the "tasks" table I have a "notes" field, and a "status" field for each of the tasks, So I can say "label needs to say "welcome in"" or something like that and know if it is "to do" "in progress" or "done". Here is the part that gets sticky; when I am looking at the buildings page (and it is linked to the tasks page, and have notes show (with a lookup field)) it will show me the

Hey All,Plugged this automation in and initiated it/turned it on yesterday. It worked once, and had no errors. The next day, it was supposed to repeat (it's set to repeat every day) and it didn't work. (There's plenty of records that satisfy the conditions). Any ideas? Thanks.   

I’ve read many Count Records threads, haven’t found my answer. Table A lists organizations (schools) I’m tracking. Schools have attributes such as public/private, updated/not updated. Once a month or so (automated if possible) I want to count how many schools meet various criteria and record in Table B So Table B will be: Fields: Date, Public Updated, Private Updated, Public not Updated, Private not Updated, etc. Records: 1/1/2022, 200, 400, 100, 200 2/1/2022, 250, 450, 50, 150 3/1/2022, 300, 500, 0, 100 Automation? Script? Rollup? Also—even if I could find the calculation that would give me those #s, I can’t use a calculated field because it will be current, obviously. I need to the calculation on the 1st of the month and then paste # into those fields. Thanks in advance!

The 'Enable rich Text Formatting' feature doesn't work in some base but not all.Even if it's activated, I can not see any modal to format the text.I tried with different computers and my phone. I still have this problem.

I would like to send an email to an specific email address with a google sheet as an attachment and have the info in the sheet updated in my table.Thanks a lot for any help

Hello,I hope everyone is dong well. I am building an application using airtable and Stackerhq.To keep it brief, I use the autofill function in Stackerhq to autofill a form and the submit those values to Airtable. I think Airtable is not accepting autofill values by default, hence, the form fails to save. I will post a video here as well. If anyone can help me enable permissions on airtable that will accept autofill values from Stackerhq. I am not where these permissions are or what the next steps maybe. Thank you!Video Below:https://www.loom.com/share/c7a48efdeb784725a30d019cbe43d31f

Does anyone have a fix for this? Just randomly out of the blue Rich Text Formatting has stopped working for my main table that I use. By not working I mean that if I write something in a Long Text field (with RTF enabled) the little popup to do bold, italic, paragraphs etc no longer comes up so I can't bold my text or anything.If I make a brand new table then it does pop up in the new table, but I don't want to have to move all my data to a new tableI've tried clearing my cache, logging in and logging out, checking and disabling all my blockers/firewalls to make sure nothing was being blocked, restarting my browser, restarting my pc, etc. I'm guessing it must be some kind of bug or I've accidentally hit some kind of option in my main table that I'm not aware of? 

What is best practice to sort records for inclusion in a map ?  I used a multiple choice checkbox but cant get anything to work.  I have a database for dealers for a product and one of the fields is "STATUS" this is a multiple choice field...if it is checked "ACTIVE" (active dealer) I want it to show on the map, but not the others.....   Please help a newbie to Airtable

Hi! I’m getting this “Bundle Validation Error” thrown for the date fields when using Integromat to sync data from Postgres to Airtable. Not sure how to handle this one since there’s not any detail explaining the error. Anyone have ideas?

I'm using the chart extension to visualize some data. Nearly all of my questions on the form have 5 answer choices but I have a few questions where no one chose an answer. For example (strongly disagree, disagree, neutral, agree, strongly agree) where no one chose "agree". I'd like the chart to show that agree is a 0 while also displaying the true values of the others. Any suggestions? Thanks!

Hi, I have a table in airtables that has the following columns1.persons first 2. last name and 3. regular hours worked 4. overtime hours worked 5. hazard hours worked.I would like to transform the different type of hours worked columns into individual rows per person so for example I am starting with the followingFirst NameLast nameRegular hoursovertime hourshazard hourssarabrum40410and I want to transform it to the followingFirst name

I would like to create a project such as Login form where the user can send its data, then the form validate these data before storing them in some table and case there is some invalid data, on the same form display a message to the user, like a normal web page flow.I would like to know how I can do this, and if possible without getting a billing plan. 

Hi, I would like to be able to give each of my planned 400 fields a Description that can be sorted alphanumerically (so I can sometimes view the fields in a specific order I want to see them in, which the Field Names themselves are not necessarily already in. Is there a way I can do this when importing a 400-column table template from Excel, or is the only way to add Descriptions one-by-one once I've got the columns all set up in Airtable?Thanks!

Hi Airtable Community -I have table A which has a column that stores links to records in table B.  When I am in an expanded view of a record in table A and I click on the linked entry to open the linked record in table B, what determines what view is used for table B?  Is there a way to specify what view the linked record should open in?  I only want to display a few fields on the table B entry and I'm unsure how to do that.Thanks in advance!

Use case: RSVP form linked to individual attendees’ Airtable records created in a separate table. Each record pertains to a unique person. I’d like the RSVP form to automatically link to the original record. I’m working with two tables, ‘Anchor Table’ which contains hundreds of records related to individuals not involved in this use case and dozens of fields including private information, and ‘RSVP Table’ which is for the purpose of organizing an event where specific attendees’ are involved. I’ve created a filtered view for pertinent attendees’ and hidden all unrelated fields in Anchor Table and linked these records in RSVP table. When I create a form in RSVP table using the Linked Record field as a drop down, the preview in the selection shows thumbnails of attachment fields in the record that are hidden from the Anchor Table view. How can I change the fields in the form selection field to hide this?

Hello everyone,I'm trying to create something similar to what I do with spreadsheets, it's like a product catalog but using multiple rows on a single entry so I can use different values for each variation of the  same item. (image attached)Is it possible to do something like this in AirTable?Or if anyone got any suggestions on how I could do something similar to this in AirTable, I would appreciate it very much.Thanks everyone! 

I’d like to be able to share a link of one of my records in Page Designer view. Printed PDFs aren’t useful to me but being able to send the client a quick mock up of the record in a url would be incredibly useful. I’ve investigated the Embed block but that doesn’t fulfill my needs. Thank you for any help in advance

Is anyone else experiencing this printing bug after the last update? I see [object object] for options under Field sizing and Font size. It's causing issues with my print views.