Other Questions

Hello, I have table B which acts as a delivery data base showing all deliveries to have occurred. I have table A with each row representing a client and a URL field within the row for a form which populates a delivery into table B (this forms is from table B). When the form link is clicked from the client record in Table A we then need to choose what client the form is being submitted for through a linked record. This is an issue because there is room for error. Is it possible to repopulate the form with the client name from Table A - I cannot find a way so any help would be appreciated.

Hi all. I’m evaluating Airtable for use as a task and activity management solution. Part of the solution is weekly reporting on the status of ongoing projects or tasks, across a team of ~50 people. We have a Projects table which contains records for each project or task: Team members post incremental status updates against items in Projects using the Activities table: For weekly reporting purposes, I would like a Grid view grouped by Project, which shows only the most recent Activity (sample below): I have been trying to construct a Grid view of the Activities table, grouped by Project, with a formula field to identify the most recent record, against which I could filter. I have been unable to devise a method that works. In order to display as desired, it will be necessary to identify the most recent Date within each Group of Activity records. There are some problems with this - MAX() returns only numeric values as far as I can tell, and MAX(values) is only useful in a rollup fiel

I’m using airtabe with a app Nobull of Finsweet to insert the data to webflow. In this way everything goes right. But I’m stuck with rich text element. The airtable don’t support images. How can I send images inside rich text element to webflow?

I have problem with automation where a trigger is new arrived order and the values which do not show in email triggered by new order arrival. This is an example of my email when someone makes new order: As you see, there are properties which I inserted for each record, but when email is being triggered, the message does not have values, although I have done everything correctly…This is example of email received: “Hello, We have received new order from for pellet: for number of pallets to load: 0 on date: . The transporter is: and his truck registration plates are:. Buyer instructions: . Documents attached by the buyer: Delivery address is: . Telman, the price for pellet is: and amount for invoice is: 0. Please, make an invoice for order nr: 29and upload it to the system, which will then send it further to client and we will have a record about it. With kindest regards!” Can anybody tell what is wrong?

Hello Airtable community, How to use IF and ENDIF conditional statements in Sendgrid app with html ? I tried : {% if {name}== null or {name}== ‘’ %}NO NAME CONTENT{% else %}WITH NAME CONTENT{% endif %} but all the code is shown.

I’m brand new to Airtable and use a Macbook. I somehow moved a column over to the Primary position when I was trying to swipe between windows and now I can’t change the Primary column back. Any suggestions as to how to reset the Primary column. I have tried to copy the column and delete the existing primary column, but the delete option is greyed out. Thanks in advance!

Let’s say I have a list of Artist / Track / Link and I want to store it in Airtable. I know that would be easy with a 3 column table in some base. But let’s say I wanted to add notes to some of the rows. For example, for some rows I might want to add extra information about the track. This would be for some rows but not all rows. I know I could use a table with 4 columns, like this: Track | Artist | Link | Notes But if most of the Notes fields are going to be empty that seems like an odd/inefficient way to do this. What is the best way to do this? Thanks much.

I have 2 tables, both with email addresses. In Table #1, I would like to be able to show (e.g. a checkbox) if an email address appears in Table #2. Is this possible?

Hi, I’ve been stuck with this for almost 2 days now and have exhausted all experimentation and research. Looking for any help I can get. I have a field in Airtable called @EventRegistration, which is a linked reference field but allows linking to multiple records from another table. In Integromat I’m using the Update record module for Airtable and what I want to do is that each time a new form response is submitted, I want to add an item , i.e. append a new linked reference item. Unfortunately, I can’t seem to find a way to do this. With each run, Integromat simply updates the original linked record when instead I want to keep appending to this multi-reference linked field dynamically. I cannot predict how many items will be added. I just want items to be appended when my scenario is triggered but instead Integromat overwrites this field with the latest value from the current run. How can I have Integromat append to my multi-reference linked field instead of overwriting it? Thanks in

Hi, We are building a freelancing platform with different tabs : USER, PROJECT, ect… For those different tabs we have common criteria such as Country, Expertise, Hard skills, Soft Skills, Language ect… How to build the Airtable to get this list always the same (& updated) between USERS & PROJECTS ? Thank you in advance for your valuable support. Anthony

Hi, I am wondering how null cell values are structured in query results. For example, when I iterate over the query results from a selectRecordsAsync() function, e.g. with a .forEach(map(x => {...})) function, when I hit a null value, the script errors. It’s easy enough to skip over these null values by wrapping the functionality in condiional e.g. if (x !== null) {...} but how do the arrays containing the query results represent the null values? Are the null values empty objects, or empty array indexes? I tried to emulate the data structure in node: > let m = [{}, {id: 1}, {id: 2}, {}, {}, {id: 3}] // <-- empty objects > console.log(m.map(a => a.id)) [ undefined, 1, 2, undefined, undefined, 3 ] > let p = [, {id: 1}, {id: 2}, , , {id: 3}] // <-- empty indexes > console.log(p.map(b => b.id)) [ <1 empty item>, 1, 2, <2 empty items>, 3 ] Is what node reports as <# empty item(s)> a null value, i.e. is the query result returning an array of obj

Hi I am working on a database that control a fuel tank. Every record show the input or output of litres that is done on the tank. I have done a form to quick access and entry data. But i would like to add on that form a field that show the real amount of litres on the tank

Does anyone know if the Unique ID can be configured when creating a synced table to Salesforce (with the AirTable ‘out-of-the-box’ connector)? The table Primary Field can be set, which I presumed should be the unique field within the Salesforce report for future syncs. However, when I select to set the primary field to be a custom column from the Salesforce report (which should be unique), then run the sync, I get an error that there are duplicate Opportunity values (which is not the field I set as the Primary field in sync configuration settings, and is not the unique column in the SFDC report). Curious if anyone else has hit this issue?

We paid until 10/31/21. What’s the best way to transfer ownership for a team when a staff person leaves? For example: When I login as my co-worker who’s leaving and try to change the owner, his email and the credit card to my email address where I don’t have an Airtable account, I see this error, “invalid password,” though it’s his password. Or should I: login to my account and request to have access to all his files according to his settings? create a new account under an email that goes to our team instead of individual staff? Should I get an invoice for a year for Pro ($240) under my account or his? How do I request one? Thanks for anything you can do by 10/31!

Hi there, complete newbie here :wave: I am working on a new base to follow up on comments left on our social media channels by different users. One field includes the username of the person who commented, and other fields will contain the comment, date of the comment, our reply, follow up by customer support etc. I would like to add a field next to the username where I can see if the person has already left a comment before - for example, by marking “yes” or a checkbox emoji :white_check_mark: in that field if the username can be found more than once in the base. Is there a way to do that? :eyes:

Our Airtable tracks the progress of legal documents through client submission, business team review, legal team review, client review, then completed. We want accurate reporting on the cumulative number of days that a document sits in each status. The challenge is that our process is NOT linear - documents may go to legal team review status, then to client review status, then back to legal team review for a few more days. We can’t anticipate how much back & forth will take place, so we can’t iron out the process to be linear with additional status columns. When we use automations to timestamp each status change using the Last Modified Time field and the DATETIMEDIFF formula, we get incorrect data, since a second move to legal team review status, for example, will overwrite the first date(s) that the record was in legal team review.

long story short we are working with another company and one of their employees keeps changing a public view filter which is screwing up automations. Is there a way to see who is doing it?

Hi Everyone! I’m new to Airtables and am struggling with creating a due date based on a last inspection date, and frequency of 365 days. I need the due date to auto calculate when the inspections are due. I’m sure it’s a very simple formula but I struggling. Can anyone help?

Experienced airtable users, I need some Airtable brainpower to help me sort out the best way to create this table(s) to hopefully achieve what I’d like to do. I think, in summary, what I want to be able to do to achieveis have two tables that can talk back and forth, as opposed to one way, along with table 1 have a way to trigger creation of a record in table 2 and maybe also vice versa. Update: I was able to use Automation, and “When a record meets condition” trigger and “Create a record” as the action for this piece. :slightly_smiling_face: And somehow, I assume by linking one to the other, when I enter a date in “Group 1 Discussed” field of Table 2 - if it’s part of a record that is linked to Table 1 - I’d like that to populate the similar field “Group 1 Discussed” in Table 1. Is that possible? If so, what is the best way to go about this? I’ve provided a lot more detail below in case it’s helpful. If you have a suggestion of something that might work better that the way I suggest

Hello, I’m setting up a form where people can write their own keywords in a long text answer block, but I would like to have those keywords converted to Multiple Select in another column upon import, without having to do anything manually. Is this possible? Thank you, Z

Hello everyone ! I am sharing with you a « funny » problem that keeps my neurons busy and now depressed. If only I could : Create a form where a Roll up could be displayed as a Single Select in a form Select existing records through a form & update them CONTEXT : My team wants to schedule committees, composed of 8 timeslots (2 committees / month). We need people to book a timeslots to present their topic (among available ones of course). We want to open the booking on a quarterly basis. The Committee Table is configured as follow : [Date] Field : Date Primary [Single Select] Field : Timeslot (A, B, C, D, E, F, G, H) [Single Select] Field : State (Blank, Requested, Planned, Confirmed) [Text] Field : Requester [Text] Field : Topic The table view is grouped by Date for the team to easily see the agenda of each committee. THE PROCESS WE WOULD LIKE (BUT CAN’T) APPLY: A requester : Finds a “date / slot” combo (aka state is blank) Blocks an available slot by : Leaving his name Notifyi

Hi there I want to remove the ability to download CSV files to local machines (keeping everything in the cloud) but I still want to be able to copy data from my airtable database. There is no default option to do this. I can see if I turn off the Download CSV it automatically disables Copy too. This isn’t helpful if you’re trying to keep data in the cloud while still being able to use the information. Any tips anyone? Or is this a setting that can be added. All the best

Hi all, I am trying to use the automation feature to create 4 new records in my table at the start of each month. I would like to use the month the records are created as part of the record name, written out alphabetically, follow by some custom text. For instance, the records automatically created in November would read “November Totals” I currently have the trigger set to…“Trigger type: At a scheduled time” —> “Interval Type: Months” —> “Timing: Every 1 month on the 1st at 12am” —> “Starting: Today” For the action i currently have… “Action: Create Record” —> “Table: Totals” —> “Field: Monthly Report” When i select next trigger time and run a test, it creates a record that reads “2021-11-01T06:00:00.000Z”. I tried using datetime_format() to no avail. Am i able to create a custom text using the created date using this automation?

Hi everyone I would like to know if anyone has a solution to make attachments in Airtable private. Looks like all attachments hosted in Airtable are public. I have a Bubble App that is private and uses Airtable as a database, I wish that users outside the app or not logged couldn’t see images hosted in my Airtable base. Thanks

I have a date field (Publication Date) and a negative number field (Days) for the amount of days before that content is usually submitted for that publicaiton. I’m using the following formula to get the submission date, avoiding weekends, which works. DATETIME_FORMAT(WORKDAY({Publication Date},Days),'D/M/YYYY') My question is, is there a way to use the computed date and Publication Date in a Timeline view? The computed date would be the start date and the date field would be the end date. Thank you! p.s. I was forced to choose a tag and Timeline wasn’t an option so I went with Gantt!