Skip to main content

Other Questions

Have other Airtable related questions? Post here!

  • 10,000 Topics
  • 40,679 Replies
10000 Topics
R
Ramsey_StoneburParticipating Frequently
asked in Other Questions
Auto-match data across tables?

I have a form for a Contacts table that collects specific data. I have another table for Leads that I need to pull this data into. I already have it linked and that works fine. The problem lies when the form is submitted. I would like a way to auto-match this data. For example, the Contacts Table contains an “email address” field. The Leads table is set up to pull the Contact info from the new record into different sort options. As it stands right now, I have to go in and manually link the contact info. I thought that by adding an email address field into the Leads table I could somehow auto-match it. Any ideas? Thank you.

590
R
N
Neil_ThormanKnown Participant
posted in Other Questions
Run a script form within a script

This doesn’t seem to have been asked before, which suprises me. Is it possible to do this? ie use an existing script like a procedure?

62
Justin_Barrett
N
Nancy_JohnsonNew Participant
posted in Other Questions
Frozen application

My phone application has frozen and is showing an orange screen

01
kuovonne
S
Sara_StahlbergKnown Participant
posted in Other Questions
Using Linked Records for Project Assignments

Hello Community! I am having a little trouble configuring something in my base that I’m hoping you can help with. Essentially, my team runs clinics in the community (daily, different locations). We have the following set-up: Table 1: Clinic Schedule Table 2: Personnel (organized by staff type) I’d like to figure out a way to assign staff to clinics in Table 1 using a linked field, but in a way that allows a process of elimination - meaning that if somebody has already been assigned to that particular date, they cannot be assigned to more than one clinic. The caveat here is that we obviously need to schedule those nurses for multiple days in a row. Is there a way to set up my base to support this? Thanks in advance!

30
S
E
Eric_Bryant1Participating Frequently
posted in Other Questions
Automating sorting for Screenplay scene numbers

Hi, I use Airtable to track information for film and television production. I frequently need to sort a list of scenes by scene number, but scene numbers often have letters added to them, which screws up the sorting. Example list, which I would want to sort in this order would be: Sc. Number: 1 2 3 A4 4 5 A5 B5 C5 5 6 6A 6B 7pt1 7pt2 8 A9 9 10 The logic (for those unfamiliar with scene numbering) is that once a script is officially released to the crew, the scene numbers are locked. Then, when scenes are added, they add letters to indicate the scene. So if it’s a scene that comes before scene 6, it would be A6 (and if there are more than one scene added, it would be B6, C6, etc) If the scene is added after scene 6, it would be 6A, 6B, 6C, etc. And then sometimes a scene is split up for production. Often when there is a phone call happening it’s only written as one scene, but when filming, both sides of the call are filmed, so the scene gets split into parts. Ex: 7pt1, 7pt2. And it

638
B
U
Uyen_Tr_nNew Participant
posted in Other Questions
How to merge cells

Hello everyone? I there any way to merge cells and split cells in Airtable? Like in Word or Google Sheet? I want to combine two cells into one? What can I do?

2296
M
K
Krystal_TobiasParticipating Frequently
posted in Other Questions
Sharing a base (read-only) will have live updates?

I tried sharing a view to a group of co-workers, but they could not see live updates unless they refreshed the page. If I shared the entire Base - Read Only, would they see live updates to entries? Thanks!

31
ScottWorld
M
metaphysicalfudNew Participant
posted in Other Questions
Math formulas in markdown?

Hi there, I have a pretty simple question. I have a database that includes some math defintions and in the long text field (rich text enabled) I would like to have for example pi*r^2 as a formula but using symbols. Can I do this in markdown in airtable? Thank you!

412
B
N
Neil_ThormanKnown Participant
asked in Other Questions
getCellValueAsAString

Hello community - I’m a week on form ‘Hello World’ as far as scripting (and coding in general) is concerned so apologies if this is basic - one of my issues is knowing correct terms and without them it’s hard to search for answers. I’m creating a script app that adds a record to a table called ‘Characters’. The new record will incorporate some info from other records on the same table so to feel my way I’ve done: dynastyNow = record.getCellValueAsString(“Dynasty”) motherNow = record.getCellValueAsString(“Name”) fatherNow = record.getCellValue(“Spouse”) countryNow = record.getCellValueAsString(“Country”) output.text(dynastyNow) output.text(motherNow) output.text(fatherNow) output.text(countryNow) It all works as expected except fatherNow - which returns: nothing if I use getCellValueAsString and ‘null’ if I use getCellValue. It must be because the spouse field is a linked record field (the others are either single selects or single line texts- how do I interogate the linked record to pr

890
Justin_Barrett
A
Admin_MasterNew Participant
posted in Other Questions
Is there a way do mass deactivate forms on a base?

Hello ! I am deactivating quite manually and inefficiently many forms that have been created on a base by clicking on each one of them and desabling their shared view link (share form menu) Is there a way do it in a faster or mass deactivate forms on a base ?

42
A
D
Diego_Suarez_LoNew Participant
posted in Other Questions
A gallery view (or a standard grid view) in which I can see a column with a little thumbnail of the image from a link

Hi there, First question in this forum , first of all thanks in advanced to the Community and Developers for such a tool. I have a table that has different rows according to the image I want to select from my links. The images are not directly uploaded but are in Google Drive so I get links such as https://drive.google.com/uc?id=1-6HRbJh-x_ivBbhO5hdanGnlD1K7XCL- I wanted a column to display a little thumbnail with this image loaded. Is that possible? I have tried with Gallery View but seems that I may not be understanding the point. Thank you

342
D
N
Neil_ThormanKnown Participant
asked in Other Questions
Let instruction within a function

So new to this and posted some code in another thread - its’ been pointed out to me functions would save some repeats in my coding and make them easier to read and correct. But I’m missing a subtly - the let instruction within my function results in this error - yet the same instruction (commented out in the screenshot) seems to work just fine - what am I not grasping?

310
kuovonne
S
Steve_SingletonKnown Participant
posted in Other Questions
Shared user's firewall blocking attachment viewing

I created a base and shared it with someone trying to access it on a bank computer. Understandably, the bank’s IT infrastructure is highly locked down and as part of that, presumably in their firewall set up, this user is unable to view attachments. She shared her screen yesterday with me and I can see that when clicking on a PDF attachment she can see it for a second but then gets a pop up saying the content is blocked. She can otherwise access the base just fine, so it’s not that they have blocked Airtable.com altogether. And when I have an attachment loaded the URL is still an Airtable.com URL, so it seems there must be something embedded in the PDF viewer code or attachment server that is triggering the block. She’s going to ask her IT people about this but does anyone know if there a URL unique to my base serving the attachments, such that she could ask them about whitelisting just that URL? I’m going to give her the base URL and and see if their firewall can whitelist PDFs fro

51
kuovonne
P
Pevi_AhmadNew Participant
posted in Other Questions
Billing Issues about collaborator

I have added 3 collaborator accounts, I have also received a bill and have paid the bill. but I accidentally deleted the 3 collaborators, if I am invited back to be a collaborator in the same workspace, do the 3 collaborators have to pay back?

00
P
J
JD_NelsonNew Participant
posted in Other Questions
Aggregate Chart Count for Dates

I have a table full of records. The records are added each week and stamped with the date they are added in a column. When I chart this, I get the total number added each date that is listed; but I want to show an aggregated chart which has the full number of records and how much each week has ADDED to it. I’ve seen a few linked reports with rollups that seems confusing and a bit overkill. In Excel charts there’s simply a “show aggregate” button on the graph… is this not a thing people do in AT?

100
J
R
Rob_WatsonNew Participant
posted in Other Questions
Calculating an ETA for Customers

I think this is a long shot, but I hope the community can come through. I operate a service business that requires me to travel to client’s homes. I currently have a client table that includes names, addresses, etc. that table has the Google Maps App installed as well and locations are shown on the map. In the same base I have a table of upcoming jobs which pulls in client names and addresses from the client table and a manually entered “sequence” field that numbers the sequence of jobs for the day. That table also has a checkbox field for when a job is completed. I’d love to find a way to create a public view that will show customer first names, maybe a house number (redacting other address info for security), and use the map app to calculate an ETA to the next job based upon when the previous job is marked complete and the distance to the next destination. I’m aware if isn’t a simple ask, but I’m not even sure it’s possible with airtable’s capabilities. Thanks in advance for helping

41
Justin_Barrett
R
R_Felciano_QIAGKnown Participant
posted in Other Questions
Sorting columns in matrix block?

Hi all – Is there a way to force a sort / ordering of the columns in the matrix block? They appear in somewhat random order. I have column names representing months in a year, and I’d like them sorted chronologically. Ramon

94
Kevin_DiBenedet
D
David_CarrollNew Participant
posted in Other Questions
How might I dynamically carry over only items that have been rated to another table?

Exploring using Airtable for naming. I have a table with a large list of name ideas (col 1). Other columns include category, notes and vote (rating / single star toggle). Only a handful of these name ideas will be voted for / picked, so I’m wanting those that are to automatically populate a second table. Is this possible? Or is there another way? PS filtering by rated is not a desirable solution.

114
D
A
Alberto_MannilInspiring
posted in Other Questions
X-axis as continuous dates?

Hi everyone, new here. Im trying to graph continuous dates on the graph block. Airtable only uses the dates on the record and skips any dates for which there were no records created.It’s very easy to do in Excel, but am unsure if Airtable Can do it. Help?

176
W
I
itoldusoandsoInspiring
posted in Other Questions
JPG PNG & attachments uploaded via API - disappearance failed uploads - ANYBODY was able to resolve issues?

Anybody who was able to resolve the issue with or without contacting Airtable Support. Was Airtable support able to address is with a permanent positive result? My workflow in Integormat: Airtable > Remove BG > Google Drive > Airtable Drives me nuts. Just a few months ago it worked on 100 images fine when I was doing the uploads on one day. So I can’t tell if it worked for me other than the workflow worked in 2019 reliably. Nothing changed about my Integromat workflows (but as precaution I created a 2nd new integromat workflow to see if it fixes the issue…) The images are uploaded as images but for some reason Airtable considers them as garbage and delets them because it is unable to process the thumbnail. The uploaded file initially shows as a generic grey thumbnail. In most cases Airtable erases the file within a few seconds, in other cases it leaves there in the same pitty state. If I quickly download that generic icon file, and then manually upload it, the upload works f

3914
I
D
Dev_FlowpayNew Participant
posted in Other Questions
Show modal dialog from SDK blocks

Hello, Is it possible to create a modal dialog that shows over whole screen from SDK blocks? I can creade Dialog from SDK blocks but it shows only over my App on right side. I would like to create confirmation dialog that shows over whole screen, like delete record confirmation. Is it possible with SDK blocks?

30
D
V
Valdemar_TKnown Participant
posted in Other Questions
Typeform images to Cloud and to Airtable

Hello, We are using Typeform to collect responses, which eventually end up in Airtable. Responses come with image links, due to limited storage in typeform we want those images stored in some cloud server e.g. Amazon/Google and once stored in cloud we want Airtable record to update the links to cloud stored links. What solution would you suggest for this? Typeform links look like this:https://api.typeform.com/responses/files/9f880b3c05bfc8db096c4cf291a5f15feb37efd0a99378ce1eb00d6299ca7da8/IMG_8486.JPG We want to upload it to cloud and update Airtable record with the cloud path.

145
Andres_at_Conne
F
Fabian_BoudinNew Participant
posted in Other Questions
Need help with Substitute/If

Hello people, hope you can help me to solve my problem. I’m currently using a formula to substitute some character for cleaning my cell : SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Telephone,".","")," “,”"),"-",""),"(",""),")","") and after this step , i’m using an other formula : IF(LEFT(Telephone,1)!=“0”,CONCATENATE(“0”,Telephone),Telephone) it works perfectly but the question is : how can i do the same thing in one formula ? For exemple : (06-07-45)43.56 26 i want 060745435626 (6-07-45)43.56 26 i want 060745435626 Sorry for my english, i’m french :grinning_face_with_smiling_eyes: and thank you for your answers.

123
J
K
Kentarou_DobashParticipating Frequently
posted in Other Questions
External database

Is it possible to export the data operated by airtable with CSV etc.? Is it possible to migrate to an external database immediately?

3416
K
L
LuxyNew Participant
posted in Other Questions
Sorting of columns

Hey, is there a way to sort the columns of a grid view by name? Best, Andreas

30
L

Badge winners

Show all badges
Terms & Conditions