Other Questions

Hi there, I have a conundrum that I hope someone can please help me with! It’s all about the final “/” Basically I want to extract the last part of a file path + filename string, to leave only the filename. The path and name can all be different lengths, and have different folder depths. The key is to take everything AFTER the final “/” Examples below… /Volumes/my_drive/documents/pictures/A001.jpeg /mnt/usb/pictures/123456.tiff /Server/over_there/no_really/this_one/what a long path/Big File.mov would parse… A001.jpeg 123456.tiff Big File.mov Any ideas please, fantastic Airtable community? Thanks!

Here’s how Airtable is sorting my text col: 2XY 11A This logic seems to be unique to Airtable: 11 is after 2 (not 1 is before 2, as expected). This causes problems trying to match a sorted list in Airtable with the same list sorted in another program. Is this a bug, intended behavior that can be worked around, or something else? Thanks!

Hey there,I'm new to Airtable and want to count all the checked boxes in one column. Anyone know how to do this? Please help! Thanks in advance.Dorus

My database disappeared. It's not in any deleted folder. When I log in, Airtable acts like I'm a first-time user. Help!

iPhone iOS: new version forces edit field to disappear when keyboard is opened. 

I swear this is the most basic problem ever.The **bleep** promo on my side menu is covering all my work spaces.The Airtable bot and I...we don't vibe. Can someone please help me

Not sure where the correct place to put this one is. I am trying to get a formula or automation to update the period field in the attached screenshot based on the cadence. I have tried using automations, but it essentially circular references itself and won't allow me to select the Period to replace with Next Period, because Next Period is calculated based on Period and Cadence. I have tried using a forumla in stead of an automation to make the Period date a live field but it only updates to the current month not the quarter and when the month is a non quarter ending period.I have an automation created to create tasks on a new tab based on the period date monthly, but tasks that are quarterly don't need to be added until the last month of the quarter.  Essentially what I am looking for is a way to have task 1 be monthly and update to the last date of the month every month so that the automation will create it monthly

I'm attempting to read the current status of a single select field, what I'd like my script to do is read the status of the button and simply return that status as a string. For example, if I manually set the button to "Doing" and run the script, my script should return "Doing" from the console. My airable is setup with a single table called "Item Status" that lists all the records in the table. Each record has a "Current Status" field, a single select field with "To Do", "Open", and "In Progress"   // read the current status of a record let table = base.getTable("Item Status"); let queryResult = await table.selectRecordsAsync({fields: ["Current Status"]}); console.log(queryResult); let record = queryResult.records[0]; console.log(record.getCellValue("Current Status"));   The problem is when I run this script it returns more data then I want.   

Hello, my workflow uses Integromat to create new records on Airtable. I have an attachment field, to which PDFS are uploaded to. Up until February 9th, a thumbnail / preview of the attachment was always displayed in my table. However, since the 9th, both the thumbnail and preview of the attachments always show as a generic document icon. I have to click the attachment to actually view it in full. Was there some change that makes previews & thumbnails no longer available as of Feb 9th? All the records prior to the 9th still have working previews in my base. Is there something I can do to get this feature back with the more recent records?

Not sure how to make suggestions to Airtable developers, so I'm putting mine here. Am I the only one who would think it'd be cool if we could reorder the items in a linked field's cell? The way that, say, one could reorder songs in a playlist in Spotify? I know we might be able to do so numerically or alphabetically, but I'm talking about custom reordering. That would mean being able to decide the order in which ingredients are put into a dish or the order in which products should be listed in a catalog, and then easily change your mind later–without having to delete the list and start adding from scratch. Just a thought.

I’m struggling to get my head around how to draw a line chart in Vega-lite that displays multiple fields. I can get one field working, but am hoping someone can post an example of syntax required to do something like this (example from random values in Google Sheets); Appreciate any help on this. Reading through the Vega-lite documentation is leaving me cross-eyed. :frowning: Extra points to show how a line can change colour as its value gets highter or lower. :grinning_face_with_big_eyes: EDIT: Ok, making progress… point data in 3 different graphs. Now to see if I can layer them. { "title": "Data", "repeat": ["Value A", "Value B", "Value C"], "columns": 1, "spec": { "mark": "line", "point": true, "encoding": { "x": {"field": {"repeat": "repeat"}, "bin": true}, "y": {"aggregate":

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?