Other Questions

I currently have two date fields, start and end. How do I create a relationship between two rows, e.g. Have the start date of Task B be days before Task A end date?

Hi folks, My apologies if this has already been explained. I couldn’t find a way to add an input to a field. I would like to enter any decimal value on the interface and then go through the calculation process. Thank you :slightly_smiling_face:

I manually entered numbers in a Single Line field, then I changed the field type to Number, and the last two digits of the numbers changed before my eyes for no apparent reason. The change is in the last two digits (14 changed to 20, and 05 changed to 00). Note that I didn’t make a typo - I watched the digits change when I changed the field type to number. I tried making a new number field and copy pasted the values in there, but the same thing happened there. I tried the same with a formula field with the same results. It’s not a rounding error - the number field format is set to integer, and so is the formula field. The screenshot SHOULD show the same number in every field - the “Group ID” field has the correct number. Is there a ghost in the machine?

Hi, I could use some advice on the following use case. One base, four tables: Products Orders Order Line Items Out of Stock Products Orders are linked to its Order Line Items, and each Order Line Item record is linked to 1 Product record from the Products table. Additional lookup data of the Product record is gathered in both the Orders and the Order Line Items table. Now here is the main issue: Product records are automatically (via scripting) moved to the Out of Stock Products table once they hit a quantity of 0 (and let’s assume we manually adjust the quantity of these product records). Once a product record is moved though, the link between the Product record and Order Line Item record is removed, causing all the additional lookup and summed up data of my final Order data to be flawed. Somehow, I need to retain that product data in the order. I’m looking for any type of s

Is it possible to retrieve the possible options within a column’s “Single Select”? Without having a record for each option listed? I have one column with 5 possibilities (right now), and want to retrieve those possible values so I can dynamically build a select box on the front end of my application. I want to be able to change those options in Airtable (add or remove) without having to touch my application. The select box will allow me to create a new record in the table with only the values I’ll allow the table to accept. I’m using only jQuery to interface with the Airtable API, and have been doing well with it (I know it’s not the most secure but it works!)

Hello and thank you for taking the time to help me out! I have two event tables. One for private events and one for community events. Both of these Tables have a Calendar view. I would love to combine these two Calenders into one so that the team can keep track of everything and ensure no overlap. Does anyone know a good and simple way to do this? Cheers! Chris

Hey all, I have a digital display where I’ve embedded a shared grid view. I would like to scale up / zoom in on the embedded view to increase reability. The simple CSS solutions I’ve tried haven’t panned out. Does anyone have a recommendation or proven method for scaling up an embedded view? Thanks, Ray

Hi all, trying to build a table for instrument rentals at my workspace. I posted about this elsewhere thinking my answer lied with automations and formulas but maybe calendar view is my answer? We basically rent instruments to students like a library would a book. I want students to be able to submit a form requesting an instrument, they select a request date and I have a formula that calculates the due date as 14 days past that. I would like instruments to be marked unavailable when requested, this needs to function in relation to the current date (ie, instrument requested for Sept 15-29, today is the 20th, so it should show unavailable) as well as to a future date (don’t want students to double book an instrument say, for October 15th). Would calendar interact with a form in such way and allow me to do such a thing?

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

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

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.

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.