Skip to main content

Other Questions

Have other Airtable related questions? Post here!

  • 10,000 Topics
  • 40,701 Replies
10000 Topics
E
Evos_WorldKnown Participant
posted in Other Questions
Query scheduled column to match date/time in Integromat (within 15 minutes)

Hi I’ve found a previous post which was answered by @Justin_Barrett about searching for Airtable rows based on the scheduled date and time. Thank you so much for that, that helped me out a great deal…however I need to get it to around 15 minutes and I can’t work it out. I used your formula but added H:mm to give me the minutes and hours DATETIME_FORMAT(Scheduled, “D/MM/YYYY H:mm”) = “{{formatDate(now; “D/MM/YYYY H:mm”)}}” I was hoping I could schedule a post for the that exact date and time and show the contents but it won’t. Once I had that working, my plan was to get the ‘now’ (date and time) from Integromat and add 15 minutes so it would check the rows for any thing scheduled for the next 15 minutes before Integromat makes the next check in 15 minutes time DATETIME_FORMAT(Scheduled, “D/MM/YYYY H:mm”) = “{{formatDate(now + addMinutes(; 15); “D/MM/YYYY H:mm”)}}” I fully expect this not to work as the first part didn’t. What am I doing wrong?

14
Justin_Barrett
L
Lewis_Dexter_LiNew Participant
posted in Other Questions
As a desktop user, when I close "Find in Page/View" using keyboard esc shortcut, I want my view to *not* move to the last found result #Enhancement #Help #Suggestion

Hi! Thanks for software As title Steps to reproduce issue Open “Find in Page/View” (keyboard cmd + f) Enter query Navigate through found queries (keyboard enter or UI arrows) Close find tool (keyboard esc) Unexpected behaviour After finding the query or navigating to the cell I want I may leave the find tool open while navigate my view. Then later, when I decide to close the find tool, my view jumps to the last found query/cell - why?! Expected behaviour Simply close the find tool, don’t mess with my view – Tested in multiple browsers - same behaviour FYI Google Sheets exhibits same behaviour and has always annoyed the f#ck out of me If you’re reading and: agree, then please vote up (e.g. +1, like), or; disagree, then please vote down (e.g. -1, dislike) - I’d love to know why? Hope this helps and to hear back Sincerely software - OS: Apple, macOS, 11.4 (20F71) software - application: Vivaldi, 4.0.2312.33 (Stable channel) (x86_64)

106
L
B
Bob_ClarkeInspiring
asked in Other Questions
Gantt in Dashboard

I previously used the Gantt app within a dashboard. The app allowed the user to click into a record on the Gantt app and edit the record. The user could also drag the bar on the app interface to set dates or duration for the record. After the Gantt app was changed to a view, we could no longer use the Gantt app. Instead we used the Embed app to make a Gantt view visible within a Dashboard. This works reasonable well with one exception. The user can click on the record and view the contents, just that no-one can edit the record nor drag the bar to change the dates. Is there a work around to make embedded view behave like the older Gantt app?

40
B
K
Katherine_DuhInspiring
posted in Other Questions
New: web clipper updates (Jan 2020)

Hi folks! The team has really enjoyed seeing how you all have been using the web clipper block + extension, and we’ve appreciated reading your feedback over the past few months. With your feedback in mind, today, we shipped a couple of improvements to the web clipper block that should make it even more useful: Linked record fields are now supported, allowing you to select an existing linked record when clipping from a web page. You can now set a specific select option as the default value for single and multiple select fields. Collaborator fields now support clip action user as a default value. (That means that when you use the browser extension to clip from a web page, the designated collaborator field will automatically fill with your name.) Now, in addition to using CSS selectors to capture default values, you can also extract values from meta tags and HTML attributes.

216
D
E
Evos_WorldKnown Participant
posted in Other Questions
Uploading mutiple images to facebook using Integromat

Hi all Is anyone using Integromat and uploading images from Airtable to Facebook? I can’t seem to upload a single image other than using the option ‘download photo from URL’. If I select upload a photo it just won’t work. Now ‘download photo from url’ is ok for a single image but it doesn’t seem to work for multiple images or at least I can’t work it out.

10
E
E
Edo_VigoNew Participant
asked in Other Questions
Show if a record is duplicated

Is there any way to show if a record has a certain field already present in another record in the view/table? For example show that the Airtable link is present 2 times Thx

9980
Kamille_Parks11
J
Jason_FKnown Participant
posted in Other Questions
Need to Figure Out 24 Hours Prior of Date Time

I have a time where an event starts and I want to set a tweet for each event 24 and 12 hours prior. Problem is when I use a formula for the Date -1 it gives me the right date but the time defaults to 12am and if I switch to not same timezone for all it moves it to the day before. Either way I want to be able to say event is 7/1/2021 at 10pm gmt. and I need a cell to tell me the time for the 12 hour or 24 hour tweet so I can run a NOW calc against it in the view to trigger the tweet.

32
J
G
gao_jieNew Participant
asked in Other Questions
How to break send Slack Message with conditional?

I have a Automatoin to send Slack message. But, in some conditional(like last step’s output put a null value for “Send a Slack message Action”), I will not send the message? How can i do?

110
Justin_Barrett
C
Cat_CrawfordParticipating Frequently
posted in Other Questions
Rollup weekly data by Quarter

I’m new to Airtable (and totally obsessed) and I know enough to be dangerous. I’m certain there is an automated/quick way to rollup data from another table based on the criteria in one field… but I can.not.figure.it.out. Table one has financial data with one record for each week. I have a Date field for “Week Ending,” and formula fields for Quarter and Year. In Table Two, I want to have one record per Quarter with a Rollup/Count or something showing my totals from a field which I could then use for further formula fields. I’ve got something kind of working (see pic) but surely there’s a better way! Help!

153
kuovonne
R
rmmKnown Participant
posted in Other Questions
Cannot import from google drive due to survey

Hi there, When I click on import data from csv in google drive to start a base, I am taken to a survey. After the survey, I am taken to a thank you page without the pop-up to select the file. Is this a bug? Has anyone else experienced this? Thanks

01
ScottWorld
J
Jeffrey_BrandtParticipating Frequently
posted in Other Questions
Help with script to combine URL and text

Hi, Using the following script from this post, I created a field that combines a URL and text: let tb = base.getTable(“URL Test”); let query = await tb.selectRecordsAsync(); for (let record of query.records) { let url = record.getCellValue(“URL”); let name = record.name; let text = record.getCellValue(“Text”); if(url) { tb.updateRecordAsync(record, {“Rich”: [${text}](${url}) - ${name}}) } } I have two questions: 1: Can I make this script complete this task in multiple columns? (for example - perform the script for column “Rich” and then have “Rich2” to repeat the script, but using a different URL column.) 2: This doesn’t work if my URL is coming from a lookup - even if the lookup is a URL. Is there a way to get this to work from a lookup field? Thanks! Jeffrey

41
kuovonne
M
Marco11Known Participant
posted in Other Questions
No Recent Update on Local Backup or Offline Mode?

Has anyone received an updates from the Airtable team on where things stand with respect to local storage backups of an entire base and being able to conduct recurring backups? In addition, the lack of offline access is extremely concerning. It’s extremely concerning that an app that I would be relying on heavily to run my day to day practice/business could potentially be offline for whatever reason. How are you guys/gals overcoming these limitations? Do you share these concerns and have there been any recent updates from Airtable staff directly related to this?

215
M
D
Dina_MaqsudNew Participant
posted in Other Questions
View is restricted to specific email domain

I have a user that is receiving the message " You do not have permission to view this content. This view is restricted to a specific email domain." However, when I check the users email domain against the domains that are allowed to view content, the domain is in the list. What other areas should I check to gain access for my user?

60
D
I
Iceshax_BNew Participant
posted in Other Questions
Problem with multiple-selection field ? How to repeat values

Hello. I’m facing an issue with the “Multiple Select” field when adding multiple values (decimals) of the current price of the kW. Sometimes, the kW price doesn’t change for the next two hours, so the value is repeated, but the table only saves one of them… Example: 0:00 - price is 0.12261000 1:00 - price is 0.15979000 2:00 - price is 0.15979000 3:00 - price is 0.14321000 But in the field, it’s saving only: 0.12261000, 0.15979000, 0.14321000 Instead of: 0.12261000, 0.15979000, 0.15979000, 0.14321000 How can I allow the same item multiple times inside the multiple-selection field? I’m adding the records using the API. Thanks.

121
ScottWorld
S
Sharon_VisserInspiring
asked in Other Questions
Determine if dates fall within a range

Hi, I need to determine which of my projects were active in the previous month, and also active in the past 12 months. For the previous month, if we are now in June, I want to see which records were active in May (so I’m not looking for specific dates). For each record I’m looking at, I have a project start and project end which I can use to see when a project was active. So somehow I need to see if the previous month is within those project start and end dates. And ditto for the previous 12 months. I tried to find the answer here in the community and spent a lot of time looking at Airtable date functions, but I can’t seem to figure it out. Thanks in advance!

510
S
Z
Zach_RubenNew Participant
posted in Other Questions
Rollup Field ArrayUnique is not giving me fully unique values. How can I fix this

Hey All! I am using a rollup field with the function ARRAYUNIQUE() in hopes of getting unique values but am still getting duplicates. I have a base with partners and markets, and I want to show all of the partners available in each market. However, when I rollup the values from the market table, I am getting duplicate values. (i.e. if Boston and Chicago both have same partner, then the unique rollup is showing that partner twice. Is there a way to fix this? Does my question make sense? Thank you so much for any help!!

784
Karlstens
A
Alissa_ChisholmNew Participant
asked in Other Questions
Will locking field permissions prevent column deletion

I know locking the column will prevent users from editing/deleting data from a row - but will this also prevent someone from deleting the entire column?

93
A
D
David_TambussiNew Participant
posted in Other Questions
Pivot Tables & Linking Data

Hi, Im currently testing the app to see if we can incorporate it to my company. My main issue is the way that data can be linked between tables. The “link to another record” opcion only let you choose by the name of the record, we often need to link by differentes parameters (other values of other columns with in that record). Pivot tables in excel or sheets are so useful becouse you can arrenge your data in the way you want and various values at a time, and link these results dynamiclly to another table. Pivot Tables app in AirTable dosent work like that, only let you summarize a couple of values and I cannot find the way of link these results to another table. For example, I have 1000 records named with the client username with information about age, nacionality, gender, real name, number of entrys, etc etc. Sometimes I need summarize how male users are, sometimes by their age, sometime by the name (how many “Carlos”?), by an averege of their age related by the nationality, etc etc.

80
D
R
RGCreativeParticipating Frequently
posted in Other Questions
Carry forward a total?

My base records trading days and transactions for a small visitor attraction that is open a few days each week. There are two tables - Trading days… which records the days open and the visitor numbers. Income/Expenditure… which records any cash transactions linked to the trading days. Each transaction is a positive or negative cashflow amount. I roll up the cashflow in a column in the Trading Days table, and can thus report on the monthly cashflow through a grouped view. If income is £10 more than outgoings, the total of the rollup is £10… that’s the “cash on hand”. What’s missing is the ability to show the previous month’s closing “cash on hand” anywhere - which is the starting point for this month of course. It’s effectively the total of the cashflow column in I/E view grouped by month and limited to last month’s entries. So I want to rollup the PREVIOUS month’s cashflow column into a column called “CARRIED FORWARD”. I know, this will show the same figure in every record created this

198
R
M
Mary_HanoverNew Participant
posted in Other Questions
I just joined Air Table - why is my dashboard full of someone else's content?

What can I do? I just created an account but why is my airtable full of content that I did not create? I don’t know what to do? I’m vry confused?

11
Kamille_Parks11
Karlstens
KarlstensBrainy
posted in Other Questions
3D Model Viewer App

With Windows 10, the user can select an OBJ file (3D model) within File Explorer and the model will preview in a simplistic manner, allowing the user to spin and zoom the model. Is there any Airtable app solution available for this feature in Airtable? The current Airtable 3D app is interesting, however it is more about users interacting within a 3D space and concatenates each 3D record into the one 3D space - its effectively useless for simply previewing one 3D record at a time, and doesn’t have a camera orbit feature. All I’m after is a 3D file viewer app experience, where the camera orbits the file, and the user can toggle the orbit, spin the model. Extra points if they can ambient change lighting. I’m hoping the existing Airtable 3D app devs read this and can add this functionality to their feature pipeline.

120
Karlstens
K
Katherine_SkrobNew Participant
posted in Other Questions
Download .pdf from AirTable to Desktop as a .pdf

Until today I have been able to download a .pdf image from AirTable to my Desktop as a .pdf so that I could use the feature on my Microsoft Surface to make notations on the .pdf, then resave it to the desktop and upload the notated document back to AirTable. For some reason, though I can download the document that saves is not in the .pdf format.

20
K
N
Nathan_ThadaniNew Participant
posted in Other Questions
Automation - Sending Email At A Specific Date & Time

Hi Community! I could use some help I’m trying to set up an automation that will trigger airtable to send an email on a given date and at a specific time. The trigger I’m currently using is when a record matches a condition and the condition being when send date is. However, I can’t specify the exact time. Thanks for your hep!

811
Kamille_Parks11
J
Jason_RogersNew Participant
posted in Other Questions
What is Airtable REST API

I’m Fairly new to the coding side of Airtable. There are terms I don’t understand yet. Could someone explain what is REST API? Where can I learn more about it too?

61
kuovonne
M
Moshe_PeretzNew Participant
posted in Other Questions
One to many relationship between bases

Hi guys, I have multiple bases with the same structure. (Meaning - same fields, same data but different clients). I’m trying to build a base that contains all records from all of the bases with a specific status (the status called ‘Send Pitch’). So, I’ve managed to collect all of these statuses from all bases using AT automation and scripting block. The first step is “When record matches conditions” (when the status = “Send Pitch”) and then a short script to add the relevant values into my webhook. let url = "https://hooks.zapier.com/hooks/catch/XXXXXXX/?recordID="; let config = input.config(); let baseID = base.id; let table = base.getTable("SDR Workbench"); let tblID = table.id; let basename = base.name; await fetch(url + config.recordId + '&baseID=' + baseID + '&tblid=' + tblID + '&tblname=' + basename + '&cname=' + config.cname + '&fuptxt=' + config.fuptext); So, one way is good. All of the records with a “Send Pitch” status are sent to my new base. My proble

122
M

Badge winners

  • First Topic
    ABTChas earned the badge First Topic
  • Welcome
    ABTChas earned the badge Welcome
  • Welcome
    danielahas earned the badge Welcome
  • First Reply
    AlineWhas earned the badge First Reply
  • Welcome
    AlineWhas earned the badge Welcome
Show all badges
Terms & Conditions