Other Questions

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 with the automation tool, but I

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: This appends A to the first of the multi submission

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 return a HTML with the correct JSON data. How can I approach this, so that the correct data is returned while also using the API key? What I have done I tried using https://api.airtable/app… with curl and passing Bearer and the API key. This

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 are populated with records inside the link record Any idea ?

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 PHP, then I only get back Found. Redirecting to /login How do I use the link and API key as they are and pass them correctly to get HTML data back, which contains the data required, instead of having the login issue? The aim is that

I’m looking for a way to create a calendar for our courses in airtable. I have our courses loaded in to the database with the start and end date but I need to be able to tell it certain things like, this course meets every Monday AND Wednesday. Is there an easy way to do this while also telling Airtable that it will occur every week until the given end date.

I am looking for an extension or integration that will allow me to chart data within a record and compare it to data in another record. For Example if record a contained the following data 1,2,3,4,5 I might get a plot of that data on the y axis with a standard x axis which might be 6,7,8,9,10 etc The second record might have the data 2,4,6,8,10 that would appear as y data points and again the standard x axis would be used. Please do not tell me to turn the table sideways this would not work for numerous reasons. Here is a very small example of the data I would like to plot i Wishon S2S Blue 45 A Wood 1 808 839 853 831 789 Wishon S2S Blue 45 A Wood 2 784 823 837 831 829 The text in bold is the record name and the remainder is data. The record name would identify the line and the data would be plotted as data points where the x axis would be labeled 6,7,8,9, etc

Hi, I am using Airtable as our database and CRM. Is anyone else doing this? These are the “user stories”: When I click on a contact to send email, open a window where I can select from a template, customize, and then click send. Sending should send through my gmail account If I receive a response, it should go into Airtable The contact should then be added to my Lemlist for follow-ups based on the Template selected Thanks! Tim

How do I get my projects (which is a primary field), to be linked to my tasks records? For some reason when I link two tables, they do not appear on the table to be linked. Here is the project tab, with the projects being the primary field Here is the Tasks field where the project field should be linked to I add the linked “tasks” field from the Tasks table And the linked field from the Projects table does not show up in the Tasks Table

I have a a base that has a set IDs (600+ unique IDs). I need to update their status’s weekly but the report to update has over 9000+ IDs. I only want to update my 600 without adding any other records to it. Is that possible with the CSV import extension?

I’m trying to create a field (Bulletins) that will return one of three values, based on the presence of one of three phrases in a record’s long text field. Basically: If Comments contains Advance Notice, then populate Bulletins field with Advance Notice If Comments contains Time Sensitive, then populate Bulletins with Time Sensitive If Comments contains Update, then populate Bulletins with Update I’ve tried a couple configurations to get it to work and can’t quite get there. Any help would be much appreciated!

We use Airtable to “process” company data (ie. add additional information about a prospect). I have interns enter a view called “Data Processing” where each row represents a company, and there are several fields for them fill out before clicking a checkbox to mark the row as complete. Each intern has their own Airtable login, so I’m wondering what’s the best way to track “companies processed per intern?” My first thought was to create a multiple select field called “Processed By” where they would select their name from the list, thus marking the company as processed by them, but that seems a bit tedious and error prone. Is there a way to automatically populate a formula field with this information? Such as “capture who the last editor was within a certain view?” Or “who checked the checkbox in the 'Data Processing view?” Another similar example: the interns must write “icebreakers” for companies as well. Today once they’re finished writing their icebreaker, they click the checkbox to m

Hello, it is possible to use the Sumproduct formula for Tier Pricing in Airtable? I am trying to calculate the revenue for a marketing agency and it´s based on tiers depending on the total amount of media spend, in Excel it looks like this, example: =(SUMPRODUCT(–(sum($D205)>={0,99999,200000,9999999}),sum($D205)-{{0,99999,200000,9999999}},{0.2,-0.025,-0.025,-0}))