Solved

Hi,I’m trying to create a field that tells you when the next due date of your credit card payments are, based on what their monthly due date is (e.g. 5th of every month) and today’s date. I know I’m creating a string that looks like a date and not a date itself, which isn’t a problem for me.My issue is that the comparison I’m using to check if the Payment Due Date is before today, a simple comparison of values really, is returning one wrong result! I created extra formula fields to see where things went wrong, and I cannot for the life of me figure out what the issue is! Basically, when I compare the number in Today against the Payment Due Date, with this formula: IF(DATETIME_FORMAT(TODAY(), "DD") > {Payment Due Date}, "yes", "no")  I get an incorrect result (Payment Due Date 5 returns “no” when it should be “yes,” because 22>5). I don’t get it. Does anyone know what’s going on? Thanks a lot!  

I have a single select field in an interface that allows users to enter new values if what they need isn’t already on the list.  This will grow over time and it would be a lot more useful if it was in alphabetical order, but I don’t want to have to go into the field properties every day and click the alphabetize button.  Is there any way to automate this?

Hello everyone, I’m designing the content layout for my team and I want to group relevant data items under common names like what we can do with “Grouping” button in Excel. For example, I have these data points: Overview: Company Name, Country, Status, Sector, Sub-sector, Stage (I want to group these four data points under the “Overview”) I also want to collapse/expand the view (with the “+” button as shown in the image) Thanks a lot for your help!

I have a multiple select field called “Weaknesses” in which a client can select different areas they’re struggling in with the language they’re learning. I’d love a formula that takes their responses and transform it to 1 word weaknesses and puts them together in a grammatically correct sentence. So... If they say “I can't stick to goals”, then I want the return to be “Goals” in the formula field. If they say "I can't stick to goals" and "I'm not great at speaking" it should return "Goals and Speaking." If they say "I can't stick to goals", "My habits and routines could be better", and "I'm not great at speaking" it should return "Goals, Habits and Speaking."What I can get it to return is a response of “Goals, Habits, Speaking,”I’m starting to think that’s not possible, and just want to see if maybe I’m wrong. Here’s what I have for a formula currently. REGEX_REPLACE( REGEX_REPLACE( TRIM( IF(FIND("I can't stick to goals", ARRAYJOIN({Weaknesses}, ",")), "Goals, ", "") &

Hi All,I’m relatively new to Airtable and I’m struggling to figure out how to structure the formula to do what I want. I know roughly how to do it in Excel, but really struggling to translate how it’d work in Excel to Airtable. There are multiple things I need the one formula to do, any help on how to structure one or more parts of the formula would be appreciated.Formula is in my “Modules” tab, but looking up data in my “Tasks” tab “Module name” field in both tabs is linked with a “Link records” type of field in the Tasks tab Each Module has multiple tasks (they’re sequential, with no more than 1 “In Progress” at a time) and I’m wanting the Modules tab to have a field that displays what Task is currently “In Progress” I also want it to state “Not started” if all the Tasks associated with that Module are “Not Started” or “Complete” if they’re all set to “Complete”The structures I’ve tried that are similar to Excel keep saying that the formula has issues and can’t be saved so I’m gettin

Hi all, hoping the hive mind can solve for what I think may be a common use case. Here we go…I have two tables:Table 1: List of records from form submissions. Records are only added to this table. Records are linked to another table with multiple look up fields. We have an automation that when a record is created in this table it finds a record in Table 2 by matching against a unique identifier and updates the lookup fields. If the unique identifier is not matched, the linked and lookup fields remain empty as seen in the screen grab below. Table name is named 1. Onboarding FormTable 2: List of records that is overwritten daily by an external sync. With any given update, records remain, are added to and/or fall off the list so it’s not a situation of “when a record is added”  or “enters a view”. Table is named 2. Sync from Volunteer LeadershipObjective: Set up an automation whereby any record in Table 1 where the linked record field is empty attempts to lookup records in Table 2 based o

Hi allI want to create a purchase order (contract) in a PDF file for sending via Outlook to my suppliers.Goal: Create a pdf Purchase Order automatically generated upon a trigger (PO Ready) from the master order which can be emailed out to multiple email destinations and internally.Thanks in advance

I have a date, some weeks, and some holidays. I need to add the weeks to my date and exclude all holidays and weekends. I’ve used the WORKDAY function. However, I’m a little uncertain how to treat my weeks. Should I multiply them by 5 (since there are 5 working days in a week) or by 7 (since there are 7 days in a week, and the function will filter out all the weekends)?    

Following the advice to have all info on one table and use views, I have successfully created a one table base for my law library. For views separating case law and articles, for example, is easy. I have a field in which I enter a letter according to the subject. eg for cases, enter C, for articles enter A. For a different project, I should also like to have a one table base, but am unable to work out how best to add records where each primary field record (the record in the primary field) and its different fields have numerous records in the same field. For example: Existing Setup: 2 tables. Table 1 and Table 2 In each table I have 3 fields including the primary field. In Table 1, this primary field is renamed Property Next field is Y, the next field is Z. In Table 2, the primary field is Date. Next field is Location, next field is Notes. Location field is linked to Y in Table 1. Add 5 records: In Table I in Y enter Lindon enter Birmingham In Table 2 Record 1 Primary field Date I ent

I have an Invoice table. My automation setup is, when a record gets created, I run a script which calls an api (that api updates an Attachment field in the Invoice table) and then at last there is a Send Email action.For some reason, the send email action does not send any attachments. Although I could see the files are added successfully by the api. Here I add attachment field from the trigger response.I think, Send Email step is referring to the older values,  present during the start of the automation. Now what works is, if I add an Update Record step in between Run Script and Send Email, and update some random field and then in Send Email refer the attachment field from Update Record action.Just wanted to know if this is the expected behavior or not

I am trying to create a list of members who have not made a booking yet.  I have two table; Members and Bookings.  The relationship is one to many i.e. the Bookings table can have many records from one member.  I want to create a view or table which shows me which members don’t have a booking.  We can then contact them and find out why they have signed up and not used the service.

I am trying to use a shared form to get our client’s current Mailing Address for stipend scholarship checks. They can get multiple checks over time so we want present their last Mailing Address and have them accept it with no changes or override with a new address.. My approach was to create a shared form where I can prefill the previous Mailing Address. It would be blank the first time or would show the last value if they had one stored where they can override it or just hit submit to accept what defaulted in the form.Because it is a shared form, anything submitted would be a new record. I was going to date stamp the new one and use it to update the master record. The issue I am having is I cannot prefill the Client ID (the key) into the form as read only (or at all) even when the prefilled link came from a record that had the key, the new record only has the data they submitted. I can't find a way to grab the unique identifiers to match what comes back from the form. Appreciate any i

Hi, I'm trying to create a custom document, using Documint, but each time I'm put the "create buttom" the emerge page showed up the follow message: "Error while fetching Airtable data: You are not authorized to perform this operation"Can you help me?Thanks

Hello,I'm able to retrieve AIRTABLE data from a first table as well as fields from a table linked to the first one, but the level below doesn't seem to work.As indicated in the documentation and the explanatory video on DOCUMINT, as for the first linked table, I create an Fx field named “Lien_Table3 Table_Id” with the value “TableID”.On DOCUMINT, I indicate the Repeat / Loop on each “Lien_Table3” record.On the PDF generation link, I indicate “...expand=2...”.But no display of the desired field.What could be wrong?Is there a level limitation with the free version of Documint?Thanks for your help!Translated with DeepL.com (free version)

I have noticed that the PDFs I have created with Page Designer (by clicking the little printer icon) do not contain selectable text. It seems to be a giant image. Not how a PDF is supposed to work. This is especially relevant when you include a URL field and want this to be clickable. Strangely enough some of my URL fields are clickable in the little preview pane in Airtable. But only some of them. Of course when I print and save them as PDFs none of them are clickable, because it is not text. There is an answer to a previous question that suggests using Long Text fields to avoid that problem but that does not work for me (and how should it, since my output is not text?): Some links not clickable in output PDFs from page designer - #6 by ScottWorld

Before maybe a month ago, when I clicked to add new fields, I can just type the name and then select the type. Now I have to select the field type first and then enter a name. My brain is wired the other way. Is there anyway to go back to the old way?

We are getting close to determining of going with Zapier or Make. I know very well the feedback about Make vs Zapier. However, the decision is more than just me. Either way, our team has a question on how to best judge how many actions or operations is enough?At minimum we’re quoted around 300k-500k runs. I can understand there is a number of variables at play.Some considerations:From an Airtable perspective on an Enterprise account with over 20 apps used across the organization for about 150 editors Considerations to connect Airtable with ServiceNow, MS products, and other financial tools Starting out with about 5 developers using the API solution Definitely be capitalizing on the AI offerings either hasIf anyone has insights on how to determine what is needed love to hear about it.

I have a table where there are potentially multiple images available:Two columns linking to other records, then One Lookup column for each of those to look up the image attachment, and then finally, One more column where I paste a screenshot, used for cases where neither of the other links are present.So there are potentially 3 columns which could contain an image attachment. If I were to try to build a sensible gallery or an app, I’d only want one image for many of the views, so I’d like to make a Best Image column.The rules are more or less:Does Source 1 exist? If so, use Source 1 If not, does Source 2 exist? If so, use Source 2 If not, use Screenshot  If I try to do this using a Formula column, I end up with what looks like a URL to the image on dl.airtable.com, instead of it displaying the image. The docs do say that attachments can’t be returned from formulae. The thing it does return may be usable for a webapp still; I haven’t yet tried. At the very least, it isn’t viewable

Hello All, I have some fields in my database that are mandatory at different stage. I want to do a form with the first fields for the first time, and then send another form prefill and update the record. I do not see how to update. Is there a way to do it ? thanks

I use a lot of linked records.Occasionally I have an issue where a [Record from table A] is deleted (by a user or automation with script) which triggers the deletion of a [Record from table B] it is linked to (by a user or an automation). Because changes to from [Record from table A] look up fields in Table B trigger other automations, these automations start running before Record from table B is deleted. However Record from Table B has finished deleting before the other automations have finished. This isn’t really a major issue, but it is an alert in airtable and my emails that I need to check to make sure something else isn’t going wrong.  Is there a clever way I can simply check if the record still exists as a conditional action in running the automation? I realise this could be resolved by redesigning other automations, but that will require redesigning several dozen.

I am new to Airtable so forgive me if this is an easy answer. I have searched the forum and can not find the solution. I want to sum a field with several records {days worked}, by group {name}. I have accomplished this by grouping by {name} and the result shows in the group bar. I want to use the results of this in another formula calculation, in a different table. Thank you in advance for any help. Steve

I’ve managed to get Markup URLs {[Text](URL)} working when sending emails by automating a field to be written with an automation. However, I’ve lost the ability to separate lines in the email. So, this automation:Gives me this (one is grid and one is line):Any thoughts on how I might be able to throw a line break between these items?

This automation is designed to automatically update two fields of a newly created record submitted via form. Neither of the fields being updated by the automation is "Formula Name", which is the field that appears to be causing the failure. Anyone have any idea what is going on here?

 I am looking for the best way to set up an Airtable to keep track of a lot of book publishing details with minimal repetitive data entry and as human proof as possible. I’m on the free plan.  The situation:I have several book series (Power of Five, Dragons, Talonswood, Trident, Draken). Each book series has multiple books. Each book can be published in multiple formats (ebook, paperback, hardback, discrete paperback, discrete hardback). Each book is being translated into multiple languages (English, German, French, Italian). After translation, each book, in each format, needs to be uploaded to several platforms (KDP, Kobo, Ingram, Tolino, D2D). Not all books get uploaded to all platforms. For example, English language books don’t get uploaded to Tolino.  I need to somehow keep track of this mess so me and my assistant know what’s been done and what hasn’t. Also would be good to keep track of an error log so we know what’s needs to be fixed.  how would you set this up?? 

Hi there!I want to transform a ChatGPT output (30 words/names) into a multi-line column (30 lines) in Airtable. I'm using Make as my automation engine and its Iterator module. I'm having trouble finding the right array formulahere is the one I have: split(trim({{5.choices[].message.content}}); newline)It would be awesome if someone could help me!!