Ask the Community

Hi,I am stuck with the following (most probably simple) problem -I am getting a records list of a tableI am filtering the list acc to 3 criteria (name, type, date) this all works fine, I log a correctly filtered object in the consolethen I want to get the value of the column with the name „tac_descr“ (variable set at the beginning of the script) of the found object/row.This should be done in the „active_descr“ definitionPls see the error in the console; no clue what is wrong; I have the correct object filtered (active_immo_tacs) and I just want to display the cell value of the column „tac_descr“ of „active_immo_tacs“. Could anyone pls help me on that? thank you very much - I am now trying to solve this since hours…

I am building a base of vendor records. Each record has a first name, last name, and vendor ID. Ideally, the unique ID would be the primary field. However, when using the "linked records" field in other tables, I have to enter the Vendor ID, which I don't know off the top of my head -- I have to flip over to the other record, look up the ID, flip back and input the ID to get the correct association. Is there a way to use the Last Name in a different table to associate with a record that has a primary field of the Vendor ID?My current work around is to use =concatenate(first name, last name), which is perfect for the above scenario. However, when I import bills from my accounting software, it imports using the Vendor ID number -- so it's the same problem the other way around. If using the concatenated primary field, I need to know how to associate the vendor ID with the correct record when it imports from my financial software.I hope this makes sense and thank you in ad

Hello, I would like to create a CRM from an existing customer list, with an event management function.In particular I have: a "customer" table and an "event" table.Customers must register for the event by submitting a form (which inserts data into the "event" table). When the customer already exists, a tag is created into the "customers" table referring to the event. Or in any case a link between the "customers" table and the "list" table.Do you have any suggestions? Thank you!

Hello how can I use subtraction in Airtable? I do not see Formula in my Airtable. Please help with screen shots if possible to sort out my requirements. Thanks 

I'm trying to put together an automation that will update a date field within a group based on a selected record in that group. I put together an automation that watched a view with only the main records and then pulled all the other records from that group into a list and then updated the record with that main record's date. However for some reason when I went to update the 2nd group with it's own automation, it started updating both. Is there an easier way to do this? Based on the image below, I want the date for CEE to go into all the CEE countries and the date for Benelux to go into all the Benelux countries. 

Was not able to find anything in the documentation or on Google about this:

I have a base that measures how many consultations our firm has booked in a given day. We have all inquiries logged onto a sheet called "Consultations." The Consultations sheet has details of each inquiry including which rep took the call and the result of the call (i.e. consult booked, may call back, etc.) amount other things. We have two other tables, one for the list of all of the results(i.e. consult booked, may call back, etc.) and the other that lists all of the sales reps that is linked to the consultations table. What I am trying to do is create a view for the sales reps that shows their closing rate (inquires / consults booked = closing rate) however, I want to be able to specify a date range to see if they are improving or declining not just all time. The problem is that I can't filter by the date of the records on the consultation table on the sales rep table. Is there a way to do this? 

I built a task management table that tracks, start, due, and completion dates.The start date is logged by an AT automation that pulls from a field called Todays Date. That field is set to PDT in the field options.The due date pulls a unique SLA from a field using this formula: {Start Date},DATETIME_FORMAT(SET_TIMEZONE(WORKDAY({Start Date},SLA),'America/Los_Angeles'),'MM/DD/YYYY h:mm A'),"")) The complete date is logged using the same automation method for start date.Where I'm encountering an issue, is how early or late a task was completed. So duration of time before or after the due date. I've tried a few different methods, but I feel like this one should work: DATETIME_DIFF({Complete Date},{Due Date},'hours') The DATETIME_DIFF formula produces wildly inaccurate results. I've tried troubleshooting by adding an hours adjustment for GMT to PDT, or adjusting

The new record detail layout has basically broken my workflow. The old setup allowed me to resize fields, make attachments bigger, add grids of linked records, etc.Now, I cannot do any such thing, I'm limited in a single column or rows. Can we opt out of this to the old one? This has destroyed my ability to keep building on my interfaces.

Hi, I would like to know if it is possible to make a Mail merge using data that comes from AIRTABLE API and Google docs or Microsoft word template?

Hello everyone,I am trying to follow ongoing contracts on a timeline view. However, the timeline will not display items that don't have a Start and End Date.Following  some other topics, most notably this one, I am trying to find a workaround where an automation automatically updates the End Date to match Today's date.A Checkbox is ticked for all contracts flagged as "Ongoing". The "Find" step locates the ones where "Ongoing" is ticked, and the "Update Record" steps supposedly updates all End Dates with the "Today'scDate" field value.However, as seen on the attached screenshot, I get an input error. I used the "Find & Update" method quite frequently and never got this result before. I usually use "Wh

Hello, I’m trying to create an automation: –TRIGGER: status of the record is changed to “Completed/Published” (I managed this part, I think) –ACTION: the “Published Date” field is automatically filled-in with today’s date (here’s where I get lost) Is it possible to do this, and how? (I tried various things but am getting “test failed”) Next question: Would the user still be able to manually change the “Published Date” field? For example, let’s say our content was published yesterday, but the user only updates their record in AirTable today, so they would need to manually correct the date. Thanks for your help!

Hello I would like to make a simple verification process with a form (where after stored on successful verification further steps follow)In a form the email is queried - which will end up in the same row as another email (from a database) -> can I build a view which filters only by the end of the email address?Field 1 (submitted field)= @123.comField 2( which is in my databank) =@123.com When field 1 ending of emailadress contains something of field 2 -> Success, enters new ViewMaybe I think too complicated, would be glad about help.

Wondering if there is anyone interested collaborating on the creation of a habit tracker base I’ve been working on. The idea is this: Place those paperthin RFID tags in the places where my habit takes place. Reading → Kindle Cover Exercise → On my shoe rack next to my gym shoes. Brush/Floss —> Next to my tooth brush When I do that habit, I just bump the tag with my phone. (This is basically a frictionless way to habit track, which I like) If that specific habit is a Yes/No kind of thing, a checkbox will be ticked in my Airtable. (I’m presently accomplishing this through IOS Shortcuts though I’m sure that Tasker can do the same thing for Android.) If the habit isn’t a simple checkbox, for example, reading – I can have it prompt me for how long I read. Up to this point, all has been relatively easy. Now, however, I’m struggling with some base design issues. Designing the base so that I can see

So I know how to create and restore from a Snapshot.As I understand it, I can rename the restored snapshot with the name of the old (corrupted, that's why I'm restoring) Base, and go on my way.But wait! All the links, forms, and sharing relate to the old base (of course)! So I have to reshare the new Base with all those folks, update links to the Base anywhere they exist, and give people with links to the old Forms, Views, etc, new links. What a pain!Am I missing something? Is there a better way?

How do I auto sync fields with another tab in the same workplace? I need to ensure the fields are all the same so that info can be moved over from one to another when the automation I have made is triggered.

Hey Airtable Peeps! I’m about a month into the process of migrating most of my company’s core google sheet docs into Airtable, and we’re all loving it! Many things for such an awesome product. I’m building out some Interface Designer dashboards for my boss to get a high-level view of operations, and ran into a snag. In the sidebar apps on the table it defaults to sorting single-select fields by their user order, which is the behavior that I want. This is what it looks like: But on my interface, I created a bar chart that shows each record filtered by a single-select column, but my only sort options are ascending/descending alphabetical. So this is a two-part question: Feature Request: The option to sort charts driven by single-selec

How can I set local to the date that every country uses, and not the America only one?

I have tried to contact AirTable support, but can get no response from them so I will post this here.Airtable has a very nasty bug if you change a text field containing a large numeric value to a number (integer) field, it changes the data values.  The attached video shows two fields, the left one is a TEXT field, the right field is just a copy of the left for reference.In the video you will see me change the type of the left field from TEXT to NUMERIC (integer) - See that this changes every value in the field with no warning at all.  I am guessing that it only does this on large numbers, I have not tested further.

I need to revert an airtable back to 7/20/23. It is in the list attached. But the Create button will not let me select it or any other date on the list. 

Hi Folks, I'm trying to build a degree audit for my department, and the automation I built recognizes when any of XX courses is present in the student's record. I then want the next automation to use that same set of course numbers, but not count what automation 1 already identified. I can't figure out how to reference the previous automation though. Any ideas?

I have been trying to automate some reminders for my team, I noticed that the grid view is no longer available in Airtable for Slack automations, I would like to know if there is a solution or I am doing something wrong

Hello everyoneI am currently setting up the following (I am using the PRO Plan):Talent Database (with all Talent Details) = mother baseMaster Project Base (=Template) each Project will get a new base, as for security reasons and different clients we can not include them all in one baseI included a synced Tab (=Talent Database), so one can see all available talents and select the ones for this project. two criteria are relevant: proposed, acceptedMY CHALLENGE:In the end we want the following information visible next to each talent in the Talent Database (mother base): what where the projects this talent was proposed or accepted for. We want to have an automation for this, based on the information within each Project Base. So we know what projects the talent was proposed or even accepted for in the

I must be missing something but can't find a way to change this. I have a standard lookup field with a capability to link to new records. When I'm adding a new  record via new record creation form I can only see the IDs of each field:However for the exactly same field, when I edit existing record and click that same field I get this. How do I get similar view when adding a new record so that I can see additional details for each item.    

I've been banging my head on this one for a while so any outside ideas would be more than welcome!We have three tables.Inventory: contains list of materials and their initial amounts. Each material is treated as a batch material so once it runs out, it's permanently out. Recipes: As the name suggests, contains recipes that can contain multiple ingredients. For each ingredient amount (or rather ratio of ingredients...) and few other details are given. Lookup fields bring some info from inventory for each raw material.Production mix: A right recipe is chosen and how much total material is wanted to be produced. Formula fields then calculate how much of each ingredient is needed. lookup fields bring the names of raw materials from recipe tables.My problem is that rollup does not seem to work over three tables . Basically I would need to take the information of how much of each ingredient the production mix uses and then get the inf