Solved

Hello All 😊I am using an automation to send  a slack channel reminders to fill out an airtable form each month.I would like to embed the form in the notification. Is this possible?I've copied the 'Embeded Code" given by airtable into my automation but when receiving the slack notification, the form does not show. Is this possible? 

Hi!I have a date field and a formula field (today MINUS date field) and another formula field that countdown (3 MINUS subtraction between today and date field) - I included photo of these fields. This is because the customs allows only 3 days for import the product. So I want an alert (countdown from when the customs contacted me that the product is at the customs).Now I want to add another date field (let's call it date field #2).I want automation (or formula field) that when I enter date in date field #2, formula field stops the countdown. Is it possible to do that with automation or another formula field? And also, how it's done? 🙂Thanks a lot guys!

I'm wondering if there's a way to allow users configure fields from within an interface? e.g., my use case is that a certain user needs to be able to adjust Kanban columns on the fly by changing available values in a single-select field. They could do this easily in a regular Kanban view in the base, but is it possible to do this somehow in an interface?

Hello, I was curious if it’s possible for a formula to return the Day of the Week from Date Field? So, if my Date field reads, “9/27/2022,” is it possible for a formula to understand that this date is, “Tuesday?” Thanks.

hello!i'm trying to send emails via the outlook automation. everything works like a charm, apart from the emails not arriving at all. so it doesn't work at all 😞 unless the receipient of the mail is an address with the same domain as the one i am sending from, that seems to work. but if i try to send to a gmail address, i simply never receive the email. does anyone have any idea why this might be? very sad.

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…

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!

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

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?

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 will be using Make to update a table with information gathered in the field. This includes new photos of assets. There should be only one photo in the attachment field, with all old photos stored in a separate field. I don't want to just replace the original attachment, as these photos are still needed. I want to be able to do the following:Upload the new photo into an attachment field ("Photo") using Make.Once the photo is uploaded, the previous attachment is moved to the "Old Photos" field. This field can have more than one photo stored in it.Is there a way to achieve this using scripting or some other tool?

Hi,I'd like to ask people more advanced than me to see if there is a way to do this.I have 2 tables: a Contact one and an Articles one.Each one has a multiselect field that hold the same data: Contacts select their interest (i.e. Sport, Tourism, etc) and Articles are tagged based on their topic (Sport, Tourism, etc).What I would like is to find the Articles for each Contact: a match would be considered if at least one of the Contact's interest matches at least one of the Article topics.I found a way to do this via code in a script, but scripts have limitations and I have around 5k contacts and around 10-20 articles to search for. Ideally I would like to do this with formulas or linked records or something in the UI.Otherwise I'll just resort to Make.com.Let me know if you have any suggestions or ideas!Thanks,Stefano

Question, I need a filed called START to pull from different fields that have dates:For some reason only the Game Development date is being pulled, any idea's? SWITCH({Stage},IF({Stage}='READY FOR GAME DEVELOPMENT',DATEADD({GAME DEVELOPMENT},'','DAYS',IF({Stage}='READY FOR CREATIVE DESIGN',DATEADD({CREATIVE DESIGN},'','DAYS',IF({Stage}='READY FOR PRODUCTION',DATEADD({PRODUCTION},'','DAYS')))))))

Trying to build a Multi-series line charts. I found articles from 2022 announcing it as a feature in interfaces but can't find any information about how to do it. I don't see an option to add an additional data set. Does anyone know how to implement this? https://blog.airtable.com/interface-designer-product-updates-1/Thanks!

I have a field that shows the week of the year, but I break my records up sometimes by leaving some fields blank. How can I get rid of the #ERROR! message that is shown whenever there is no date (or week) in that field?Here is the formula I use: DATETIME_FORMAT({Date to be Posted},"w")

hello, newbie question. someone who uses softr with an account and who sends and receives data by softr thanks to a personal space must have an airtable account? for example if softr is used as a platform for users who register and create an account in softr to provide, use, operate and retrieve information that will be recorded in Airtable. THANKS

I’m following up on a previous solution ScottWorld provided for another user. I apologize if there’s a better way to link to the old closed post. Anyway, the goal is to Automate the END TIME based on START TIME, and DURATION. The formula Scott suggested was: DATEADD({Start Time}, {Duration}, ‘minutes’) When I put this Formula into the END TIME formula field exactly as is, and the DURATION field empty, the END TIME is automatically set to 5 hrs after the START TIME. When I enter “3:00” (3 hrs) into the DURATION field, the END TIME is automatically set to 7 Days and 20 Hrs later. Obviously, I’m misunderstanding something.

I want to set up various automations with reminders (slack messages) or updates for the team but not spam them with an overload of updates.So far I only found how I can trigger Slack messages for a certain trigger but I want to avoid sending a message for each trigger.How could I "collect" all messages for one user and only send them a slack update e.g. once per day/week, with every update this person was mentioned in or task status changes that are relevant for that person?Thank you very much 🙂 

Hi everyone,I'm trying to solve a workflow/formula problem I've run into.Goal: I am building a task tracker, and it's important we have a history of steps already completed for each task. I have built a table that lists the tasks, and one of the columns is for "Most Recent Update," where team members can enter a description of the current status of the task (e.g., Jon talked to Kathy, and they want to present it during the next meeting).Issue: I want to somehow automate the transfer of any new/edited text in this field to an ongoing list of all the previous "Most Recent Update" edits. In my head, this would be a bulleted list in another column that has a bullet added to it every time the "Most Recent Update" column for that task is updated. I don't want to just have a column with an ongoing bulleted list that folks edit as the interface version of this table needs to be user friendly, and I want to be able to show just the current "Most Recent Update" text without the history in some i

Before there was a screen for that, but I cannot find it anymore!

I want to change single select field (named "Status") let's say from "status A" to "status B" of a product when the checkbox field (named "Checked") in checked. Both are in the same table.I already try it with automation but the error appears. What am I doing wrong here?  

Hello everyone,Looking for some help on a problem I'm trying to resolve in Airtable. Context and goal of the databaseI'm building a database of our members. The first table lists our members and their level of membership and the second table lists the training courses we offer.Back on the first table, I then inserted a lookup column to say which training course the member has taken. So far so good, everything works.Here is how it looks like so far (sorry, all in french) : Our end goal is to send to each member, at the end of the year (when it's time to renew their membership), a list of all our trainings, and for each one, show them which ones they took part of or not. If they took part in the training, it would say "Yes" and if not, it would say "No". We plan on using the page designer extension to build that report.To do that, I added a lookup column that lists all activities offered so I can insert them in the "page designer" extension. Here is how it looks at this point (

Hey all,I am stumped and looking for some help. Here's the situation; I have linked record called subgroups (a string with an integer i.e. Pacific 6) that will be occasionally updated when the person is moved to a new subgroup. I want to keep a running record of each group a person has ever been in, so if they are in subgroup X, then moved to subgroup Y, then moved to subgroup Z, the record keeping cell would now contain "subgroup X, subgroup Y, subgroup Z" but I cannot figure out how to append the new information each time a record is updated instead of replacing or concatenating with just one other record. My automations keep failing but I am really green with automations so I'm not sure if it's even being built correctly.So far, I've tried the following:Using a formula with a change trigger in the form of a I/O single select and reference cell with the original group (called orig) - IF( Select ="Changed", Subgroup & ", " & Orig)​This just leads to a record with the orig

Hello, Quite new to Airtable, I have an issue with an automation.We are a non-profit that coaches People, who create Projects. We have a directory table called "Annuaire" where all the People are, a Projects table where we list the Projects and a Prospect Projets table for people who may be interested in our courses. The prospect table has a form, so people can enter their info by themselves. To keep things simple, the Prospect table has info related to the person (which would go in the Directory table) and the project (which will stay in the Prospect Projets table for now). The automation I have in mind is the following : 1. When a record is created, the personal information create a new record in the Directory table2. It updates the category (but that part is not a problem3. Then, the created record in "1" is updated to link the Prospect Projets to the "Annuaire" field in the tableI've tried the following automation : But as you can see, I

I am hoping there is a formula to achieve this... but not sure. I want to automatically generate the formatting that is in the "IDEAL" field on the right, that way this does not have to be done manually.Any help/thoughts would be appreciated!