Solved

I have two tables with customer information that I use for CRM. For every customer record in table-1 there needs to be one and only one record with the same customer name in table-2. The tables are linked by the customer name. The primary field in table-2 is a formula that is equal to the name of the customer in table-1. Table-1 structure CUSTOMER NAME FIELD1 FIELD2 (… sensitive data) TO_TABLE-2 (linked field, to one and only one) Table-2 structure CUSTOMER NAME (formula so it is equal to field TO TABLE-1) … data accesible by a third party TO TABLE-1 (linked field, to one and only one customer in Table-1) They are separated in order to give different view/edit permissions to different people. Manually everything works fine. But I create customers on the go in my cell phone and can easily forget to create the corresponding customer in table-2. Is there a way to automatically create and link the customer record in table-2 when a customer is created in table-1? Thanks!

Trying to get the “)” to display after the “X” in COMX (({SchDep} & “-”) & {Dest} & “-”) & {LdTo} & " (" & {SCAC} results in: 2200-KLO-KLO (COMX but (({SchDep} & “-”) & {Dest} & “-”) & {LdTo} & " (" & {SCAC} & “)”) results in a formula error. I’m also unable to display the date from a date field as part of the formula. It ends up looking like 2019-17-26-T00:00:00.000Z Also, is it possible to formulate two linked records {A} and {B} to display in one cell with the above?

Hi there, I am looking to setup an approval queue for our membership service, whereby applications are brought into the “Applicants” base, and when the dropdown selector for “Approval Status” is set to “Approved”, the record is added to our “Members” base, and deleted from Applicants base. Is this doable? Any idea how I could achieve this? Thanks so much! Adam

Trying to achieve an outcome where: IF Column One is prefixed 381 then Apple If column one is prefixed 382 then orange etc Column 1 381-9287 382-2818 383-2812 Column 2 formula Thanks!

For creating books, I have 3 main tables - Projects -> Titles -> Tasks When I create a Title, I almost always have 3 “tasks” that need to occur. What is the best way to set up a way to replicate this workflow? without having to cut/paste text and worry that I have a setting or pull-down wrong!!

Hey guys, I am wondering how I would go about importing text from another field like “Diamond Plus” and translating it into “diamond-plus”? Any way to do this without just building a really long IF statement? Thanks so much, Adam

>>> a.get_all() Traceback (most recent call last): File "/Users/snatsai/project/airtable/lib/python3.6/site-packages/urllib3/connectionpool.py", line 603, in urlopen chunked=chunked) File "/Users/snatsai/project/airtable/lib/python3.6/site-packages/urllib3/connectionpool.py", line 344, in _make_request self._validate_conn(conn) File "/Users/snatsai/project/airtable/lib/python3.6/site-packages/urllib3/connectionpool.py", line 843, in _validate_conn conn.connect() File "/Users/snatsai/project/airtable/lib/python3.6/site-packages/urllib3/connection.py", line 370, in connect ssl_context=context) File "/Users/snatsai/project/airtable/lib/python3.6/site-packages/urllib3/util/ssl_.py", line 355, in ssl_wrap_socket return context.wrap_socket(sock, server_hostname=server_hostname) File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/ssl.py", line 377, in wrap_socket _context=self) File "/Library/Frameworks/Python.framework/Version

Hey, I’m new to the airtable. In this video, we can see how to apply the auto-fill the data or formula in all fields. https://www.youtube.com/watch?v=5Y-PyB-F4lo What if we can automate this if we have 50+ tables to automate the same process? Is there a way to automate the auto-fill process in every field? This will remove the manually auto-fill the formulas on each table.

Hy Guys, We’re trying to do a formula in order to create a new graph within our dahsboard. However it keeps telling us that: => Y-axis field “Pourcentage_retard” is not numeric The formula that we’re using is: => IF(nb_intervention=0, “0”, inter_retard/nb_intervention) I’m wondering if a need to add a formula to switch to numeric. Thanks in advance!

I have a Base with a Table for each week. Every week, I add a new Table with a new set of data for that week. I need a Summary Table that pulls from the same column in each of the weekly Tables. Any suggestions? The less I have to configure each week, the better. Seems like a simple function!? Thanks!

I am have two tables. In table 1, I have: a (non-primary) field with 3 single select options (let’s call it field A) a field linked to records in table 2 (field B) In table 2 , I have: the table’s primary field, from field B in table 1 (field C) a field that counts the number of linked records (field D) I would like to filter the field that counts the number of linked records (field C) in table 2 so it only counts for one of the 3 single select field (field A) in table 1. I looked around the forum, and some answers seemed to deal with the same issue but I could not get any to work for my case.

I am new to Airtable and trying to use lookup to pull first and last names based on an ID number in a table (called log) that will be constantly receiving new records. I have a second table set up with all of the ID numbers, first names, and last names that is linked, and the lookup set for the first and last name fields. However, with the lookup I am only getting the names for the first occurrence of an ID and they are not loading for any new records that are created. I have the settings enabled to allow linking to multiple records. How can I get it so that the first and last name automatically load for all records.

Hi all, I’m currently struggling with a thorny Airtable formula issue. I think I need to be considering using a nested IF statement or a SWITCH formula, but i’m not 100% convinced that either will work. Here’s my problem statement… I need to analyse the outputs of five columns, each of which is populated by a unique, formula-generated text value. Based on different combinations of these text values, I need to display a different summary sentence. I thought that I could solve this issue by using the following nested IF statement… IF({Biz Rules Provided Summary} = “Incomplete”,“Awaiting Business Rules”, IF({Analysis Complete Summary}) = “Analysis Incomplete”, “Awaiting Analysis”, IF({Screen Designed Summary}) = “Design Incomplete”,“Awaiting Screen Design”, IF({Developed Summary}) = “Dev Incomplete”,“Development Incomplete”, IF({Function Configured}) = “Config Incomplete”,“Awaiting Configuration”,“Function Configured”))))) However, this formula doesn’t work. It seems to get stuck after th

I am looking for a way to use the REPLACE() formula function to replace values in a Multi-select column with different values on a new column. For example: The original column contains column Type of question with multi-select values bug-report, enhancement. Can we create a new column called Type of question (new) with the corresponding new values: bug-report-new and enhancement-new?

Hi All, I’m working on a table that has a formula with a checkbox, my problem is while the formula works I want the value to be currency and formatting options are not available. I would be most grateful for any thoughts on how to accomplish this. Thanks in advance

Hi, I cleaned my browser data and now I am missing two bases in one of my workspaces and a whole other workspace. Why? Only one base is left with a tag ‘bases shared with me’. It is MY base. I had important date in there which I need for work! If it has sth to do with my chrome cookies & temp cleaning, then why one base was left intact? I really need help here! Regards, Magda

Hi, I’m working on automating multiple maintenance tasks in my base, but this one got me stuck … I’ve come to realize I need Zapier and a multi-step Zap (find record, then update record etc.), but I have not been able to figure out how to proceed from there. See my example base here: Airtable DeviceCutExample - Airtable Explore the "DeviceCutExample" base on Airtable. My workflow today: When some criterias are met (the PastDueDate?-field is “Yes” and the DeviceUsedBefore-field is empty) the record shows in a view (Projects --> TriggerView). I get a Slack notification, open the view and cut the linked record from DevicesUseNow to DeviceUsedBefore. So, when DueDate is in the past I need the linked record (in the example base; DeviceB) to “move” from the DevicesUseNow-field to the DeviceUsedBefore-field. And that is pretty much what I want to automate. Seems simple to do manually, but other tasks are dependent on this one being done, s

We have an airtable with several hundred records, and we need to print it to a large format wall display. I am attaching a draft of the formatting we are trying for. Our goal is to output a timeline in this format—in columns of 3-5 entries deep. Our goal is also to have the items print with a color coded header block (see example) for each of 4 different categories. Each entry in the finished print has 5 fields—Name, visual, Year, description, and category. Visuals need to print in full- not arbitrarily cropped.

This ought to be really simple but I cannot suss it. I’ve looked at the help files for functions and also for nested if statements and no doubt the answer is in there, but I’m missing it. I have a little to-do base. Task records have two date fields: Do_On and Do_By. A task can have values in one or both or neither of the fields. I’d like to look at the stuff on a calendar so I need a single date field I can map to the calendar. Do_On takes higher priority than Do_By, so in plain English, I’d like a calc that looks something like this: If both Do_On and Do_By are empty, then return Blank() If Do_On is NOT empty, return Do_On If Do_By is NOT empty, return Do_By I’ve tried various things but can’t make it work. For example I’m told this is invalid: If ( Do_On != Blank() ; Do_On ; Blank () ) Of course that’s not all I want but I thought I’d try just that much, but still, no luck. Can’t tell if I’m supposed to format the date result and I’m doing that wrong or if it’s something else. This

Hi How do I convert the web link below to jpeg on an iPad or do I need to use my MacBook or is there a scenario/module that will convert the web address to jpeg. I have about 300 images that I will need to convert. When I selected the image, it opened up to a larger image, then I copied the link, so I don’t know why the link goes to the smaller one: https://postagestampguide.com/stamps/15606/canada-geese-near-sudbury-ontario-air-1946-canada-postage-stamp Ultimately, I need the web link conversion to jpeg for an Integromat scenario, so that I can add images to my Airtable records. Thank you, Mary Kay

Trying to set 1st field as a formula with IF statement. I currently have: Bill & " - " & DATETIME_FORMAT({Due Date}, “ll”) I have another table for bills paid on irregular date (non due date). Without the Due Date being filled in I get an Error in the formula. I’d like to have the formula show IF Due Date Empty, date paid Thank you.

I’ve been searching throughout the forums but couldn’t find the answer to this question. I currently have an “Interactions” table where I capture the date of the interaction and link it to a contact record in the “Contacts” table. I also have a field in the Interactions table where I select the type of interaction e.g. Meeting, Phone Call, Email, Task. What I would like to do in the “Contacts” table is create a view to capture servicing items. One of those is to capture the last date I held a meeting with a specific contact. Is there a way I could create a field in the “Contacts” table to automatically pull the last date I had a meeting with that contact from the interactions table? I can easily pull the last interaction date with the contact using a rollup field with the formula Max(Values) but I would like to specify interactions that are of the Meeting type only so it doesn’t pull the other types such as Phone Calls, Emails etc.

Not sure how to title this, too early to think of the proper name - but this is what I’m trying to accomplish and I can get one percent to work but the others fill in with Error or NaN. When Gross Profit percent is: 0%: Formula is: 0% gross profit: 1-15% formula reads: 1-15% 16-25%… 26-45%… and so on up to 100% Trying to group all gross profits based on the percent for graphing purposes.

Hi, I am using Airtable for blog management. I currently have a table with blog title, subject, date published, etc., etc., I want to add an SEO checklist to my base. Obviously I can add it in this same table but the size is getting cumbersome. I would like to figure out how to auto-populate a second table with just the blog title, and then the SEO items following. Is this possible? Thanks!

I have a table of projects, and a table of tasks, and I can create new tasks within a project by entering them directly in the column linked to the tasks table. First of all I’m curious if this is the best way to do things, since technically I’m creating a many-to-many join where I can have tasks that are unassociated, or tasks that are associated with several projects, both of which I have no intention of ever doing; I only want each project to have 0 or more tasks that are strictly associated with that one project. More importantly though, when I finish a task I created a checkbox field on the task called “complete” which I would like to cause my task to be hidden from the tasks field in the projects table. I had assumed that creating a view of incomplete tasks in the tasks table (which I did, and it works fine), then checking the “Limit record selection to a view” and selecting the incomplete task view, would do exactly what I want. But it doesn’t, and I don’t even understand what i