Other Questions

Hello Until I perform the upgrade, is there a risk of my data being deleted from the base? Or data may not be saved?

Is there any limit to the number of fields in a base? Also is there a limit to the number of entries that can be put in a Multiple Select field (I am wanting to transfer (one at a time) some 80,000 records from a desktop database which has approximately 250 fields and in the process rethink how i want the information presented. Whether the finished layout will also have circa 250 fields i don’t know but what I don’t want to find as i progress that I have reached AT’s limit.) tia

Hi, My script is working OK but make some red marks where shouldn’t be (i think). the script is quite complex and divided into parts, designed to work in different bases, related to old tables inventory and cleanup, so I avoid hardcoding Table/Names outside of beginning const values Here, it marks red for ‘FinalTableX’ not existed in base, but not marks if I put ‘FinalTable’ existed. I think that’s incorrect behaviour, because that piece is intended to “check table, create if not exist or use existing”, maybe remains from past months, before great breaktrough with create table by script. I think, same with fields. Commented function also cause marking FIELDS, i changed it because i suddenly need second field to be Multitext. Including text source const FIELDS=[‘Name’,‘List’,‘Info’,‘button’]; const ROOTTABLE=‘FinalTable’; let tableNames=base.tables.map(table=>table.name); if (!tableNames.includes(ROOTTABLE)) { //createRootTable; const tableId = await base.createTableAsync(ROOTTABLE

How does AT sort (address) numbers that also have a suffix letter? For example, 2A, 2B, etc. To overcome the sorting problem for addresses in a Filemaker desktop database I use, I have a separate field alongside the address number in which I enter the address number in numerical formal only and use that separate field for sorting. For example, 2.1, 2,2, etc. tia

Hi everyone ! I have a personnal plan plus and 1988 dollars credits on it. I want to upgrade to the Pro plan (20 dollars, paid yearly). The only thing is that i’m afraid to lose my beautiful credits if i upgrade … So i want you to ask if the credits are saved when you upgrade your plan :thinking: Thank you

Hi so I’m pretty new to airtable and I was wondering the following: We have a CRM with a Leads Table and a Sales Calls table. The sales calls now have linked fields to the names of the leads. But I would like to be able to adjust the status of a lead in the Sales Calls table as well. However, I see that when I use a lookup field, it only get the status from the Leads Table, and I’m not allowed to adjust the status in the Sales Calls Table. Is there a solution for this, so that the two are linked and I’m able to change them in either table? Thanks!

Hi! I decided to try all the airtable automation power and upgraded to PRO plan. During 1 hour I realized that such automation is not necessary for me now and returned to the free plan. After that, I lost all my credits. How is this possible?

Is there an app or block to track the activity of other collaborators using the same base? It’s my base, but I’m wondering if I invite other collaborators if I can track their activity. Thanks

Is it possible to prevent collaborators from editing Dashboards that have been created using Page Designer?

Hi - First time posting and not a beginner but no where near a pro at airtable but I am trying to include the images of my rental products in the list that populates on my form. I have a field where visitors can request individual or multiple pieces of equipment and it would be great if they could see the product they’d be renting. I’m not sure why it shows images on the backend side of Airtable but then when you go to the front facing link, it only shows the text. I have included screenshots of what I’m talking about but can anyone shed any light on if including images to my rental products is possible?

I have a list of people and their dates of birth. I’d like to know if that birthday falls in the current month. Right now, I have a column, the formula of which is IS_SAME({55th Birthday},TODAY()), which indicates if that birthday is today, but I’d like to see everyone in the list who turns 55 next month. So, in September, the October 55th birthdays are indicated; in October, the November 55th birthdays will be flagged; and so forth. Then, I’d like to have a column which shows the first business day of that month so that, using Zapier, I can pass that date on to my CRM. So, in the view I’m going to create, I’d like to see, in October, everyone who turns 55 in November, and I’ll want a column with the first business day in November.

Hi all, we’re trying to create a bar chart using Vega-Lite app. This is where we at right now: { “$schema”: “https://vega.github.io/schema/vega-lite/v4.json”, “title”: “Test Corporate”, “width”: “container”, “height”: “container”, “data”: { “values”: [ { “tratti”: “EXECUTIVE”, “field”: “EXECUTIVE”, “type”: “nominal” }, { “tratti”: “ORGANIZZAZIONE”, “field”: “ORGANIZZAZIONE”, “type”: “nominal” }, { “tratti”: “RIPETITIVITA VENDITE”, “field”: “RIPETITIVITA VENDITE”, “type”: “nominal” }, { “tratti”: “FINANZE”, “field”: “FINANZE”, “type”: “nominal” }, { “tratti”: “ATTIVITA”, “field”: “ATTIVITA”, “type”: “nominal” }, { “tratti”: “CERTEZZA QUALITA”, “field”: “CERTEZZA QUALITA”, “type”: “nominal” }, { “tratti”: “NUOVE VENDITE”, “field”: “NUOVE VENDITE”, “type”: “nominal” }, { “tratti”: “STRESS”, “field”: “STRESS”, “type”: “nominal” }, { “tratti”: “PRINCIPI BASE”, “field”: “PRINCIPI BASE”, “type”: “nominal” }, { “tratti”: “AIUTO”, “field”: “AIUTO”, “type”: “nominal” } ] }, “mark”: “bar”, “enco

I am using a sales CRM template. Have completed a small email shot to apron 80 contacts and I want to update the contact records to show this contact/interaction. Struggling to understand how to do this. All help appreciated …Ray

I have a base that tracks students, grades k-12. I have a status field with a label of the student’s grade level. I would like to have a formula that changes the status to the next grade level at the start of a new school year. For example, a student whose status is Kindergarten for a given year to be changed to 1st grade the next school year.

Is there any way yet to export a table with formula fields staying intact? I need to export a table that has roughly 50 formula fields.

Would love some troubleshooting advice. I have always been able to manually drag records to reorder them in grid view. Suddenly I’m not able to move the records. I searched help, and the community questions, and saw that I should look at whether I have a sort indicated or locked. I looked, and I don’t. Anyone know what else I can do to be able to reorder records again? Thank you!

Hope this is the right area to ask for help. The link at Airtable Final Starting Sheet - Airtable Explore the "Final Starting Sheet" view on Airtable. displays a golf starting sheet nicely on a laptop/tablet or desktop but fails miserably when viewed through a smartphone. Any cunning tips to have a decent display on any platform?

Thanks in advance for any insight from the AT community! I have a base that includes a bunch of school enrollment information. Some is static/historical, and some is updated monthly. There is one table that with the list of schools as the primary key, and those schools are linked in another table for monthly enrollment tracking. From the latter is a form that schools complete to enter their monthly enrollment information. The form submission has a “Date Created” field. I want to be able to provide the updated enrollment total based on the MOST RECENT entry date. Because different schools provide there updates on any given date of the month (and some haven’t submitted since the previous month), I can’t just filter by date because I will lose some data. For instance, if I put a filter on the date for the last month, it won’t catch a school that last submitted five weeks ago. For example: Monthly Registration Tracking (School names are linked to the Schools Table) School A - 6/8/2021 - 40

I have a view of records, sorting the amount ($) field from max to min. I only want to show the top 3 amounts in this view. How do I constrain the view to show only the top 3 records?

Hello, can I use date DD-MMM-YY date format like I can with Jotform? Some services will only use the American date format, so I like to use MMM for the month letters, otherwise it’s very easy to mix up the day and month. Tomorrow for example is 10/9/21 - that’s 10th September, unless you’re American then it’s 9th October… sorry, I mean October 9th. I know I can use “friendly format” which shows the full length of the day and month (i.e “Friday, 10th September, 2021”) and cuts off half the date unless the column is unnecessarily wide. I’ve looked at this thread but it doesn’t mean much to me: Date format hints and question on localized date formats for users Custom Apps I noticed the date value provided is structured as M/D/YYYY. Is this consistent across all users? Or does this change depending on regions? ie. D/M/YYYY for EMEA Airtable users, M/D/YYYY for US Airtable users, etc. This might be a new Feature Request, but it would be awesome if CellRenderer ca

I have a base with a few thousand rows and I have a column that is single select type. Is there any way I can automatically populate that entire column with random values from the single select list (about 15 possible values stored there).

Hi, Airtable community I have tables from multiple vendors. Each table has the same fields. I have to combine the records from each of these tables into one table. is there a way to combine multiple tables into one table? One thing I tried to sync table but multiple sync option is not available. Thanks, Veeral

Hi Can anyone help please? I have just found Airtable’s own Extract Base Metadata Script which is amazing! I am using it to build a library of all data across my bases by syncing to a master base. Have found that when it runs it amends but does not delete any fields that have been deleted. Does anyone know how I can add this to the script as it runs? Deleting records in the new table works and then running script but no good now as all my new added fields with reference info will go. Thanks, Maria

Hi. I am using Airtable Desktop app on Macbook Air M1. When I expanded a row to view in details, there were hidden fields that I can’t scroll to the bottom. Below is the example screenshot. Anybody else having the same issue? How can I solve this issue? Thank you.

How can I configure my expanded calendar view beyond hiding fields? How can I move things to the top of my calendar view without affecting my grid view? Wish I could just drag the field that I want to see in my expanded calendar view but I don’t see how to do that