Other Questions

Hello, i have an address field in my base and i am looking to create some filters to categorise items by country, in some addresses i can see the name of the country at the end but others not, here some examples : Greater Milan Metropolitan Area Warsaw, Mazowieckie, Poland Paris, Île-de-France, France Künzelsau, Baden-Württemberg, Germany Stockholm, Stockholm County, Sweden Geneva, Geneva, Switzerland Vienna, Vienna, Austria Greater Milan Metropolitan Area Newcastle, Northern Ireland, United Kingdom Ottawa, ON Calgary, AB Seems to be not possible by default in AT even with the map extension.

I was wondering if there’s any script that allow me to check/ uncheck the box? I can only do one but I want to make a toggle checkbox. This is the script for check only let table = base.getTable("Product List"); let record = await input.recordAsync("Interest", table); let recordId = record.id; await table.updateRecordAsync(recordId, { "Interest" : true, })

Hi! My name is Dúnnia. I’m from Brazil, and I’m using AirTable for about a year. But now we are having some problems with the forms. It seems the corrector changes our text and turns in something not understandable in Portuguese. I need help çause clients are asking for money back. I’m waiting for your response.

I have a question very similar to the one posted in How can I add percentages to airtable dashboards?. I have a table with 50 rows (per company), each of which has a projectComplete Y or N. In my interface I have 2 numbers elements that count the total number of Ys and Ns. Let’s say those numbers are 10 Ys and 40 Ns. I’m trying to figure out how exactly to produce a number or chart that will tell me that the overall Y completion percentage is 20%. Surely there must be a way to do this in the interface screen without some hack that adds a new column to your dataset? Even if the only answer is a hack I can’t really see how I could construct that in my dataset. Thanks for any thoughts!

Hi, I’ve created custom extension, but my custom extension can’t automatically run and can’t run in background when my base opened, is there any way to make my custom extension can autorun and run in background ? Thanks

I would like to normalize my base data model a bit and separate out parts of logic into their own bases - everything about People in the People base, Projects in the project base, and so on. I am just learning about setting up synched tables and had a question on security. Leaving the data out there with simply a unique URL - but otherwise open - is really a non-starter. I saw where I could set a password on the synch share link, but then the synch stops, rendering the feature useless. Am I missing something? Is there some way to secure the synch between the source & destination?

Hi Community, is it possible to upload binary data to an Airtable Long text or other field? I need to save the data & use it later. I don’t need to save an image or attachment, just the binary data. Thanks

Hi folks, I’m trying to create a matching system based on goals/objectives so i’ll automatically send introductions for those who are matching so they can grab a coffee IRL. These coffee meetings are 1-1s. I’m not sure if I should use script(s) and/or formula(s) and/or a rating field and/or a scoring. I’m far from being an Airtable expert. I’d really like to create something simple as it’s a very early-stage MVP. Complexity will be needed later on, but not now.

Hi brains trust! Need some guidance here as what I think should be simple is proving not-so. I’m trying to track gifts given over time and those that are recurring annually. I have created a column for OCCASION (single select from a list of pre-determined occasions to track), a column for OCCASION DATE (manual input) and would like to add a third column (RECURRING OCCASION) for those occasions that have static and annually reoccurring dates - i.e. Christmas. Would like to include Easter, Father’s Day, Mother’s Day in this column too - returning a date for the 1st day of the month in which they fall (not too worried about specifics here as dates change annually and figuring out a formula for that would fry my poor neurons). The idea being that any event recurring annually I would simply have to select from the OCCASION column and the RECURRING OCCASION column would auto-populate with the specific date. I would then create a view to show each year’s budget by month, inclusive of all even

Hi, I have issues opening a record by scanning the url of the record. When I scan the QR code (generated from a record URL) the airtable app opens but doesn’t load the page (or it takes a long time). If i just go to the airtable mobile application and I click on the record, it immeadately opens the record. I only have 4 tables in my base, each with 10 records Link is: Sign in - Airtable Can someone help me with this? Am I doing something wrong? I’m new with airtable. Greetings, Corneel

We’ve been looking for ways to extend our record limit in Airatble for quite a while. This crossed my radar today - https://www.getpalette.com/ Looks interesting … Has anyone tried it yet?

Hi, I can’t seem to figure out what’s wrong with my formula. I’m trying to convert a UNIX timestamp which is in a Single Line Text field, into a corresponding date field. My UNIX is in a field called _eventTimestamp and value is 1663598125000 stored in a Single Line Text field. My date field has the formula DATEADD('1/1/1970',_eventTimestamp,'seconds') and the formula results to 4/30/54687 2:16am I can’t seem to figure out why that is. I checked the UNIX timestamp online and it shows me the correct converted date It’s probably a blindspot but I can’t seem to figure out why I’m getting a weird value for the date in Airtable. Any help would be much appreciated. Thank you. Update 1: I even tried converting the UNIX timestamp to a numeric value thinking the DATEADD needs to add a number and so I tried the formula DATEADD('1/1/1970',VALUE(_eventTimestamp),'seconds') …but I still get this odd date 4/30/54687 2:16am Update 2: SOLVED For anyone interested in the solution, I finally figured

What’s the alternative for “=importrange” (GoogleSheet) - basically import data from a CSV file via URL

It seems this topic was discussed in 2020… with no real resolution. I’m sharing a gallery view with fans of my products. On the desktop, they get simple search, filter and sort options. On mobile devices, including tablets, those options are not available. A workaround whereby the user forces the browser to load the desktop version does actually work. This seems seriously lame… and makes the shared view nearly useless since most people are on mobile devices. It’s been over 3 years since this came up… why is it still this way?

So I have been working on various integrations using Integromat for my Destiny Search Project system. I have come to a roadblock and looking for some help… I have an Attachment field in Airtable that has a .csv file in it. The file is formatted with the same fields as a table in the Airtable database. I want to be able to export the data from the csv then import it back to the other table. The issue I am having is figuring out how to use the Parse CSV tool in Integromat to run through the file from Airtable.

I am having trouble linking two tables. In the first table I have a primary field called “company”. A second field here is “email”. Each “company” has several “emails”. In the 2nd table, I have a primary field with “company”. Another field is “files”. Each investor has several “files” linked to it. I am copying investors in a separate column that I am then linking to the first table. The problem is that the link only works for the first instance that “company” shows up in the 2nd table. Is this a bug? Any work-arounds?

I want to be able to filter out users from being assigned tasks that are due on a certain date if they submitted a time off request that overlaps with the due date. For example if a task has a due date that is due on 9/20 and one of my users submitted a time off request from 9/18-9/22, I want the assignee column to not show that one user. Anyone have any idea how this can be done? Airtable - Maintenance - This is my base right now, and for this base, a task is a “Work Order”. The worker column links to my user table and I’m struggling to connect the time off requests together.

I’d like to use Airtable for project management. External stakeholders often ask for a Calendar View to see planned work. We do not work on Saturdays or Sundays, so I make sure weekend dates are registered as “Holidays” in the Gantt Chart settings. My problem: Is there any way to automatically prevent tasks from appearing to occur over weekends in Calendar View? I send out calendars and people automatically assume I am expecting them to work over weekends. What It Looks Like Now… What I WANT IT To Look Like…

I’ll try to describe this as best as I can- I have a table set up for signage requests our staff can make for our event. One field asks the size. Since we have specific sign holders in house I want this field to reflect our inventory of sizes. So if someone selects 1 of 5 sign holders that is 22" x 28", can I make it so only 4 more records can choose that size after? Is this or something similar possible?

The Airtable Monthly Digest for September includes an article for content teams that describes 5 templates. It shows screen shots of them but as far as I can see it doesn’t have links to the bases. Do I need to sign in/sign up to see the links? Are the templates on Universe? Am I missing a hyperlink? Seems silly to describe templates that aren’t available.

Continuing the discussion from Seeking a Volunteer Airtable programmer : Please take a look at this old post and reach out if you can help!

Hi I am trying to create an airtable with resources, rate, jobs no. quantity, amount and total. To do this I have created a master of inventory type with rate against each item. Eg: Small Carton $ 5, Large Carton $10 etc. Now I want to use that data for different jobs numbers. In each job i want to track the different types of resources used, quantity used, cost of each resources and total cost of resources used for each job. Eg: Job no. 50 - Small Carton $5 x Quantity 2 = $ 10 Large Carton $10 x Quantity 2 = $ 20 Total Cost = $30 Eg: Job no. 51 - Small Carton $5 x Quantity 1 = $ 5 Large Carton $10 x Quantity 2 = $ 20 Total Cost = $25 Eg: Job no. 52 - Small Carton $5 x Quantity 0 = $ 0 Large Carton $10 x Quantity 2 = $ 20 Total Cost = $20 Could you please help. Thanks Ajit

i’m seeing some very strange behavior in one tab of my base. my colleague duplicated the tab from another tab that was called “9/15 NYS Budget” and then renamed it. in the new tab, whenever you right click, instead of the options saying things like “delete record” or “insert record above,” it says “delete budget” and “insert budget above.” i made a copy of the new table including duplicating records and the behavior goes away. it’s not really impacting our functionality, but it’s very strange and caused some concern for my colleague! any thoughts? anyone seen something like this before?

I am importing data from a Squarespace form. I changed one of the questions from a free text input to a dropdown and now the data is no longer populating into airtable. Tried a few workarounds but stuck with an empty column on the table…

Hey all, Hoping a relatively simple question! When you add a linked record column, it gives you the option to add multiple lookup columns (associated with that record). Is there anyway you can add multiple lookup columns AFTER you’ve created the linked record?