Solved

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!

I have two lookup fields that are an array inside my table. One shows the number of products (30, 30, 30, etc.) and the other show the name of the products (product name 1, product name 2, product name 3, etc.).If the fields have just one product, I can easily concatenate them into "number" & "name" (e.g., 30 product name 1), but that doesn't work on multiple arrays. I'm trying to combine the fields such that the output will be number and name in order (e.g., 30 product name 1, 30 product name 2).It seems like ARRAYJOIN() into a list is the appropriate function, but I can't get it to work. The formula of IF(  ARRAYJOIN({number}),  "- " & ARRAYJOIN({number} & {name}, "\n- ")) produces "- 3030product name 1product name 2" instead of "- 30 product name 1 - 30 product name 2." Any ideas? 

This seems like a very basic question but search hasn't yielded me an answer.How do I set a field with spaces in the name using a fetch() request?  const res = await fetch('https://api.airtable.com/v0/xyz/Estimates', { method: 'POST', headers: { 'Authorization': `Bearer ${process.env.AIRTABLE_TOKEN}`, 'Content-Type': 'application/json' }, body: JSON.stringify({ "records": [ { "fields": { Client: [client.id], JSON: escapedJson, Total: total, Screens: screens, Outside Only: flags.outsideOnly } }, ] }) });

(Thank you in advance! I swear I've tried everything I could find here and no luck)I'm running a (successful) Create New Record automation from a Synced table, so my teammates can use the source data to develop their own additional work (but not adjust the source data itself). Yes, it duplicates a record -- but it's the only way I can deliver the starter content and let them build on.Next step is to run an Update Record automation, so when:Source data record is updated, thenMatching created record is also updatedTrigger (successfully finding the updated records in Source data) & Actions ("received invalid inputs") screenshots attached.

I have fields for "First Name" and "Preferred Name." I want the "Preferred Name" field to default to the value in "First Name," but still be editable if a different preferred name is desired. I also want to implement a similar approach for the mailing address, where the "Mailing Address" field defaults to the value in the "Physical Address" field but allows for easy editing when needed.Any ideas on how to achieve this without duplicating fields? I appreciate your input and suggestions!

I am designing an interface that contains a grid. I attempt to reorder the grid columns by grabbing the dots to the right of the name and manually reordering, but after changing the order it snaps back to how it was originally. I am not sure whether this is a bug or not. It occurs in the standalone Airtable Windows app and web based chrome.

This feels really silly but I can't get the LEFT, MID, RIGHT, functions to work with variables at all. It just keeps giving me an error no matter what I try. It works with a string in the function but not if I use a variable. Can someone tell me what I'm missing? I'm sure it's something simple...//Formula that doesn't work: LEFT({Text Phone}, 3) => #ERROR! //Formula that does work: LEFT("123456789", 3) => 123

Hello, I have a field that is using a formula in order to create a url. the formula is a concatenate to build a url to a form with prefill value. I then want to use it to send a email with gmail. And little thing I do not want to print the url but replace the text with “click here” I tried several things : in the body of the email [click here](record(step1…) I change the formula in the field it self in order to format. the field is ok in the table but when I send it the URL is there and the markdown is not interpretated… I realize that my URL : https://airtable.com/xxxxxxxx?prefill_First+name=Alexandre&prefill_Last+name=Husset&prefill_Email=alexandre@husset.fr&prefill_LinkedIn+profile=https://www.linkedin.com/in/alexandre-husset-61181a/ all the _ just disappear in the email https://airtable.com/xxxxxxxx?prefillFirst+name=Alexandre&prefillLast+name=Husset&prefillEmail=alexandre@husset.fr&prefillLinkedIn+profile=https://www.linkedin.com/in/alexandre-husset-61181a/

We are working with different clients on different Airtable bases. Also internally not everyone is working on every base. We do not want to change this (and include all client data in one base) also for security reasons.But for Management I am trying to do a Base/View/Interface where the Management Team can access e.g. all upcoming campaigns for all clients, without clicking through multiple bases or tabs. Meaning this base should be feeding from all existing client bases. Being able to make changes in this base is not prio 1 (but would be a nice to have though). All bases would have the same setup/columns based on the same templateIf I would sync all client bases to e new tab within my "management view base", would Interfaces allow me to show everything at one glance?Is this possible and if so, how would I do it? 

Hi folks, I know you can prefill dates in forms using URL functions. In this case, I don't need it to happen in a form, but on new record creation. I can use a formula for "today" - but it's uneditable for the small number of instances where it needs to be overridden. It's helpful to have "default values" for number fields, but it seems weird there is no default for date fields. Surely I am missing something obvious?

I'm trying to return a value if the date matches any of a string of dates. I'm trying to make sure dates don't land on company holidays. Thanks!

Hello--I have a base filled with content that we publish every day. I'd like a view where I only see content that is supposed to publish on a Monday though, but the options for dates don't have that capability. Any ideas on how to do it?  Thanks!

I have a long text field that takes the food and the preference of the user.Sample Input:Burgers (Enjoy), Pasta (Ok), Seafood (Nope), Pork (Ok), Beef (Ok), Vegies (Enjoy) I want to get all the texts that are "Enjoy"-ed by the user.Expected Output:Burgers, Vegies What formula can I use to get this output?

Thank you for considering to help me! Here's the process I'm trying to create:A new record is created via a form which will have a start and end date (i.e. 7/3-7/28)Based on the timeframe (above), I would like to set up an automation where additional new records are created (within the same table) for each week within that timeframe. (i.e. a new record with the dates 7/3-7/7; another record with the dates 7/10-7/14; another one for 7/17-7/21 and the last one for 7/24-7/28). There will be other fields that I'd like to copy from the original record as well. I'd like to avoid a script and just use formulas and automations, but am open to a script (although will need help writing one!) if that's the best/only option.Thank you!  

Hello,I am trying to debug why a certain script I wrote for automations failed because it takes more than the allowed 30 seconds. It seems that Airtable JavaScript environment doesn't support parallel execution of asynchronous tasks. Is that correct ? What can I don if I want to perform this kind of code: await Promise.all([ updateRemoteDB(), updateRemoteDB() ])Thanks,Yaniv