Other Questions

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?

Hello. I am having some trouble with automations for email reminders. I am using the formula below to create the condition that will be used in the automation. When entering the start date and time, I can’t seem to enter this information quickly enough without either a) the date appearing as a partial of the real date (eg “9/1” instead of “9/16”) and thus triggering an email immediately, or b) the auto-populated time for the date (the current time) appearing and thus triggering an email. I can tell this is happening because the start time field appears in the email header as “9/1/2022” instead of “9/16/2022” for example. Is there any way to get the system to give you a few seconds to enter things before jumping the gun? Thanks! IF({Start date}, VALUE(DATETIME_FORMAT(SET_TIMEZONE(NOW(), “America/New_York”), “YYMMDDHHmm”)) >= VALUE(DATETIME_FORMAT(SET_TIMEZONE(DATEADD({Start date}, -30, “minutes”), “America/New_York”), “YYMMDDHHmm”)))

Hello. I want to make the receipt based on the form that user have been input. I have add new table for the name and price. Is it possible to do with basic plan? If yes, how do you make it? For example user will input [ TV - 1, Washer - 2 ] and the next page, the airtable will calculate the total price and print as receipt I would appreciated if anyone can help me solve the problem. Thank you.

Hi, I’m using a dynamic PDF tool (ELEDO) which gets info from Airtable to populate a contract. Sadly, this tool can’t loop through a list of record and extract informations I need. In particular, I have a link field of which I need to extract each individual record to populate fields which its linked content. I’ve look into the automation but there’s no option to split infos of my linked field. The closest think I read was this article but the link inside is dead and I don’t want to create new tables but populate fields inside the same table. The entire Use case is this. I have a children table I have a parent table -I have a link field which contains the list of children inside a parent record I want to split the link record into other field: child 1, child 2, child 3… which

When having longer field names (eg Email address: private and Email address: organisation) it’s guesswork which field is mentioned in the popup. Yes, you can hover over the field names to see, but you can not hover over the corresponding field names to the right. This is very annoying. It would be great if the width of the popup is bigger or if you could resize it like we can do with eg the formula field.

Hi there, I posted a topic earlier. When I edited it right after, the Akismet moved it into spam. Is there someone here that can please move it?

Hi there, I am trying to obtain data from an airtable link. I only have a basic link (not API) and an API key. example link: Sign in - Airtable example key: keyMYCOOLKEY When I use the link above, I get a HTML page back with data, but I can see it asks me for login. This causes a JSON syntax error on my end because my system can’t process the HTML when the data does not exist within it that it needs to see. When I use the link and change the app, tbl it viw characters for testing I get a page not found back and then I know that the original link should actually give a result - just need to have a way to “sign in” using the API key. If I add the API key at the end of the URL, it makes no difference. If I pass the api_key as Bearer with curl via a local Test P