Other Questions

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.

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?

Hi, I’m trying to make a script that counts the number of records based on the date created field. I don’t need any other information, just a count and would prefer not to have to make a view since my base is already cluttered. Any help would be greatly appreciated!

Hi, I am new to Zapier and the Box integration with Airtable. I was wondering if there is a way to automate the following: Every time a boxnote is created within a specific folder, search to see if the company this was created for already exists in our Airtable. If it does, update that record with today’s date. If not, create a new record Every time an existing boxnote is edited, update that company’s record with today’s date.

Hi, I am trying to automate an update of the “Date of Last Interaction” field in multiple linked companies (records) in my ‘Companies’ table with information from the “Date of Interaction” field in my ‘Interactions’ table when an interaction (a record) is added into ‘Interactions’. I was able to successfully update "Date of Last Interaction with the day the record is created/edited following this forum post. However, I want to update this with information pulled from the “Date of Interaction” field in my ‘Interactions’ table instead. I have attached some pictures and the code I used. let config = input.config let records = input.config().triggerRecords let table = base.getTable("Companies"); for (let record of records) { await table.updateRecordAsync(record, { "Date of Last Interaction": new Date(), }) }

I use Airtable as a database of–call them–accounts. Using Google Docs, is it possible to create a summary sheet of a single record (my account) that might list info as follows. Account A Feature 1 Feature 2 Etc. I would only want to create it for record in the base. I saw Google Docs mentioned in conjunction with an automation. I would want mine to be created one demand. Is this possible?

Hi community! I’ve been now struggling couple days with finding a solution to a problem that to my mind seems pretty easy to solve. So basically I have a billing list table to where I want to bring more info to from another table. In a separate table I have the information of our subcontractors and their prices. Also our clients have different prices so we need to bill them based on their contract price and then also check which subcontractor are we using so that we can get the values “Client’s price” and “Subcontractor price”. The ideal situation: I search first for the product (the names of the products are of course the same to all clients) and then when I select the client and the subcontractor it would automatically fill the info of the client’s price in one cell and the subcontractor’s price in another. I’ve searched for other similar answers in the Q&A but can’t seem to find exactly similar problems from others. I also thought about doing this

First time posting here as a new user of Airtable and I’d really appreciate some help - Context: I have two tables - Submission and Final. Submission data is fed from a form which is completed by customer for each book. A customer will usually enter multiple books which then roll up into one submission that populates the Final table (i.e. one submission = one invoice). It was working great when I roll up using a unique ID (Invoice ID) made up of the customer’s initials + date. However, occasionally a customer will want to put in 1+ submission on the same day. So I end up with duplicate invoice IDs that then all roll up into one invoice - which I do not want. I want to separate these same-day submissions and send separate invoices (emails) for each. Right now I’m trying to append to the invoice ID like how I would do it manually, e.g. GS-091522A, GS-091522B, etc. But I’m unable to figure this out as an automation. This is what I have:

Hi Airtable Community! I am a new user on Airtable and I am struggling to split incoming data, that contains multiple data points contained in a single cell, into multiple rows. Example Below: Current format: | Household | Household Member First Name | Household Member Surname | HHM Age | | HH1 | John, Jane | Smith, Doe | 18, 19 | Desired format: | Household | Household Member First Name | Household Member Surname | HHM Age | | HH1 | John | Smith | 18 | | HH1 | Jane | Doe | 19 | Any ideas on how to achieve this? Thanks :slightly_smiling_face: Ryan.

example URL = Sign in - Airtable example API = keyMYCOOLKEY This is what I have and what I am working with. The system that I have set up connects to the above URL and gets HTML back… Don’t know if that is correct, but the end goal is to retrieve JSON data for data import. The issue is that when I use the URL, it displays the HTML page but says it needs a login. At no time does it require my API key. A PHP curl test reveals : "Found. Redirecting to /login?continue=%2FappiKlBfTyvFfarTu%2FtbliOpnbcxQauIudo%2Fviw7uPlqwOjhTydwt%3Fblocks%3Dhide&redirectSource=liveapp" When I use a bogus app/tbl/viw, then it returns an HTML that says the page cannot be found. To summarize, the URL seems to be working that I have although it needs a login in order to

Hi, i created a table for Purchase Orders (POs), and a sub/child-table for the Order Lines (OLs). Example: PO-1 OL-1 OL-2 PO-2 OL-1 OL-2 Etc What formulas or workaround do you recommend me to get a column at the OL table with the Order Line Number automatically starting again from 1 each time that the first line of a PO is created? Thanks in advance!

Hi, I’m new to Page Designer and have created several reports that will be printed to PDF and emailed. I see I can share the table via a link with a colleague for a quick check but not the resulting one page report. Is there a way if they don’t have Airtable account?

Hi I have a main base where I store all member information. I have another base where I have other information but not every field in the main base. If I change the information in the main base I want it to change in the other base. How is this done in Airtable?