Solved

Hi Is it possible to show the day of the week along with the date in a field?

Hi Im trying to Compress multiple fields with one script, I tried searching for a solution but I haven't came across to anything.I was able to find one but i'm only able to compress one field but not multiple fields // Modify these to your own values.let tinyPngApiKey = 'xxxxxxxxxx';let airtableAttachmentSource = 'Instructor Sample Artwork #1';let airtableAttachmentDestination = 'Optimized Artwork 1';let airtableColumnToLog = 'Optimized Artwork 1';// Don't change these unless you know what you're doing.let table = base.getTable(cursor.activeTableId);let view = table.getView(cursor.activeViewId);let queryResult = await view.selectRecordsAsync();for (let record of queryResult.records) {let recordAttachmentUrl = record.getCellValue(airtableAttachmentSource)[0]['url'];console.log('Compressing ' + record.getCellValue(airtableColumnToLog)) let request = await remoteFetchAsync('https://api.tinify.com/shrink', {body: JSON.stringify({'source': {'url': recordAttachmentUrl}}),headers: {

I want to start with the important fact that I do not know javascript so I need to be able to do this within the automations manager in Airtable. I have a simple base that has contacts with certain categories. I want Airtable to email me once a week with the names of any contacts still in that category.For example, John Smith and Wade Wilson might have "needs follow up" in the Status field. I would like Airtable to email me once a week to list out the people in "needs follow up" under Status. It can be an email that just lists their names. I have read the forums here and googled and I cant' figure out how to do that. 

I'm using the formula below to calculate the date difference between the day a position was opened to today (tracking number of days the position is open until filled). Is there a way to override that formula if the Position Status is listed as Filled or to make the formula only run on Positions with the status as Open. I don't want the running count of days once the job is filled, but don't want to lose the data point of the day it was opened.DATETIME_DIFF(TODAY(),({Open Date}), 'days')

Hi there,I am trying to set up an OKR table in Airtable.  I have two tables in my workspace.  One for Key Results and one for Initiatives.  Under initiatives I have a column with tasks just check off as they occur.  Please see below.  How do I create a column with a formula that will calculate the % completed based on the check marks listed in the task column.  I have tried to create the formula with creating additional columns (total task count and total task count completed to calculate off of but that didn't work).  I used the "countall tasks" in the total task column and tried to create a formula in the total task count but it isn't working.  Any guidance would be greatly appreciated.     

Hi Airtable Community!I want to be able to send an email if 7 days has passed since they last received an email.I have set a date field in my database to be populated with today's date when an email is sent from my automations.I now want to create another field that includes a "1" if today's date is greater than 7 days, or "0" if not.I can then trigger future emails if a "1" is present in the field.I'm nearly there with this formula (see attached).IF(TODAY()-{Last Contact Date}>7,"1","0") Does anyone know what I'm missing please?Thanks,Gavin

Hey all, so I'm working on creating a base that will be used to track multiple event registrations with a form that has option for the registrar to identify which event(s) they are attending. Once the form is submitted, automations will assign them to the event they said they would attend via. a check in grid.Currently, I have the email automation to send confirmation emails based off what they said they will attend, but I realized if someone plans to attend all five events, they will get a confirmation email for each event, that's potentially 5 different emails which isn't the most ideal.I'd like to concatenate the email automation, that will be based off the events they select. i.e., if they plan to attend Event 1, 3, and 5. A single email will be distributed, confirming they signed up for 1, 3 and 5—instead of 3 different emails for each event.I read around that this might involve creating a javascript but was hoping there is another way before I teach myself entry level javascript

Hi Airtable Community! I have a process that requires specific people to provide updates on the 15th of every month. I’m looking for an easy way to create a calendar that will trigger these emails automatically on the 15th of the month at 8 a.m. I’ve had some success with creating a calendar table and developing a formula that flips a field (when criteria met) to a new view that triggers email but the process is a little clunky and I haven’t been able to figure out how to send it at a certain time of day. Any advice/help is greatly appreciated! Thank you.

I created a table called Items (household items).  In Items, there is a partially filled-out field, PurchaseDate, that is some items have a PurchaseDate; other items don't have a Purchase Date (field is left blank).  I want to run a filter of those items with a blank PurchaseDate:  Is the best way to do this is to create a formula field, named noPurchDate: LEN(DATESTR({PurchaseDate))=0 such that if the PurchaseDate is not empty, noPurchDate returns FALSE, and if PurchaseDate is empty, then NoPurchDate returns TRUE? Is there an easier way to get this result? Another more "normalized" way of handling this might be to create a separate table, PurchasesWithDates linking Items to PurchasesWithDates.  How does one create a filter of Items with no link to PurchasesWithDates? 

Hello,I have created 3 forms connected to the same page (they need to be) and I was wondering if there is anyway to filter them on an Interface to only show those submitted on the same form.Thanks. 😊

Hello! I use Airtable for organizing my blog. Once arthile are ready, Airtable send an email to Wordpress (postie amazing plugin! ) for creating the next post.I woul dlike to automate the posting time. On my blog, I have 8 time slot per day, monday to Friday, so in total 40 new post per week.I would like that once I select a checkbox, an automation insert the publication data in the "pubblication Date" field according to the next available slot.I have tried creating a table with the available calendar (all the available time for the different time of the week) and a stack that increase by one, every time I select the checkbox, but unfortunatly I was not able to proceed further with automation.Does anybody have any idea on how to solve the problem with an easy and effetive solution (I think to use an automation is the right approach, but my coding capacity are almsot zero..)Thank you very much in advance to anybody would give me a suggestion on how to solve the problem. 

I have two bases on a free account but I want to move them to my other account, which is a PRO plan account.Can you send instructions on how I can move or copy the two bases in my free account to my paid account?ThanksMark

Hi. I am trying to use Make to automatically update record links, based on a generated primary key.  I am mainly using this because I am hitting the 50k limit of the Pro plan limit, and Make has no limitations on amount of tasks / operations.I have a field called LinksNeedUpdate, which when the value is 1, I want it to be able to set the value of 'Link to another record', to the value of a formula field.  I have the below fieldsLinksNeedUpdate: Simple formula field, which returns 1 when the values of CleanerMonthlyInvoiceIdGenerated and CleanerMonthlyInvoiceLink  do not match.CleanerMonthlyInvoiceIdGenerated: This generated the ID of the invoice. This field is filled in once all critiera are met for how invoice can be issuedCleanerMonthlyInvoiceLink [Link to another record]: This needs to be set to the value of 'CleanerMonthlyInvoiceIdGenerated'.   The system above allows me to automatically create rows when needed.  The issue is that in AirTable

How do I change the name of an interface with the new layout? Can’t figure out how to edit.

Hello!I have an automation set up that when a record enters a view, a script is run to delete the record. Almost every time it runs it throws some failure notices and I get multiple notifications from Airtable. But, it seems to work though. All records are deleted from the view when it runs. Usually there are only 20ish records that enter the view at a single time. And if I watch the view the records will disappear usually in under 10 seconds. Yet, I still receive the failure notices.Here is the script.  //Identify the table you'd like to delete records from let table = base.getTable("🗹 Checklists"); console.log(table) //Identify the view you'd like to delete records from let view = table.getView("⚙️🅰️ Delete Records View"); console.log(view) //Select the records that you wish to delete let recordQuery = await view.selectRecordsAsync(); let recordsToDelete = recordQuery.records; console.log(recordQuery.records) //Delete records for (let deleteReco

Quick one, I use date_add to calcuate a bunch of dates in different field. Now, I'm realising that even tho I use "Datetime_Format" airtable can't easily interpret those as dates if I want to sort by them or make timelines etc.Here is an example of a date formula I use.IF({Target 1st Harvest Date}=BLANK(),IF(  AND(    IS_AFTER({Target Sowing Date}, '10/01/2023'),     IS_BEFORE({Target Sowing Date}, '04/01/2024')    ),  (DATETIME_FORMAT((DATEADD({Target Sowing Date}, (1*{WtH}), 'weeks')),'DD MMM YY')),  (DATETIME_FORMAT((DATEADD({Target Sowing Date}, (1.5*{WtH}), 'weeks')),'DD MMM YY')))  ,(DATETIME_FORMAT({Target 1st Harvest Date}, 'DD MMM YY'))) Here's another DATETIME_FORMAT(  (DATEADD({Target Crop Out Date},&nbsp

I am trying to create a script to overcome the issue with updating multiple records after a "Find Records" search that yields multiple results. Automation Trigger: Record from "Packing List" table gets updated to ShippedDesired Actions:Use "Find Records" to search for items on the Packing list that were Available and mark them as Shipped (Some items may be on backorder so I want those to remain as is)This search returns a list of the 2 items (in my example) with Available as their status.Update the status cell to Shipped. I am not familiar with scripting so any help on writing this will be appreciated! I know I could complete these with Integromat (Make) but I'd rather keep it local to AirTable and less complicated.

I am creating an application using an AirTable form. We are asking applicants to rank their availability preference for five single select choices. Since there is no ranked choice voting option available on AirTable currently, my workaround is to create five single select fields (questions in the form) with the same answers in each drop down. It's a little cumbersome.The functionality I'd like is, for each descending selection, the choice(s) made previously to be removed from the list (Ex: If Monday at 5pm was the #1 choice, then I'd like that choice to be removed from the 2nd choice question and so on). This would make it more user-friendly and avoid duplicate days/times being selected.I've a feeling this isn't possible quite yet but, if anyone has a workaround or better option for ranked choice voting in AirTable forms, please let me know. Thanks!

I have a field called ID, and it's an autonumber field.  I cannot get it to display in my email.  I've tried creating a formula field with it, too, with some prepended text and tried adding &"", too, which was suggested somewhere.  I can add the Airtable record ID with no problem and other formula fields and have them included in the text of the email.  But anything I do with my ID field will not show up in the email.  The test data does have an ID in the ID field and a value in the ID Text formula field.  Any help will be greatly appreciated!

Hello,I'm a beginner when it comes to using formulas. This is my first time using a formula with conditions. Im looking to display a message when employee's reach our milestone years of service to the company. I know Im close, but its not working. Can someone tell me what am I doing wrong here? Here is my formula:IF(  OR(    {Working Years} = 1    {Working Years} = 3    {Working Years} = 5    {Working Years} = 7    {Working Years} = 10  ),  "🎉 Announce on Social Media")

How would I display the sum of this column and make it such that every time a new record was added the sum is updated with the new information so that it is usable information on softr?

Our main People table is linked to a Work History table that shows the date and position of each shift worked. I want a field in the People table to show only the most recent date that a person worked. Lookup fields do that, of course, but return all of the shift records for each person. TIA!UPDATE: The date of the shift worked is stored as text.

FolksI have created a database with several peoples details. On it, I have also created a view which will take a filter text like this:https://airtable.com/VIEWLINK?filter_FIELD=FIRSTNAME%20LASTNAMEand then send it to the specific FIRSTNAME/LASTNAME person, who does not have any airtable account as a normal shareable link, so they can access their data.The problem I am facing with is that as the controls of the view are available, the view can be filtered with different values and people can see each others details.I see that on the EMBED version of the view, I have the option "viewControls", but it does not work if I use it on a normal share view.Is there a way to prevent a view to be re-filtered? Or to prevent the controls to be available?Thanks in advanceAlfredo Rodrigues

Hey guys,I was wondering if anyone had any suggestions for moving elements around more smoothly? At the moment when I try to move record elements in grids they rearrange everything in ways I wasn't intending.For example: I have a section on my interface for Important Links that are pulled from different fields that I want to lay out in a particular way. And when moving them into positions from this : To attempting to get all the elements aligned it does this:Does anyone now of a way to maybe lock locations of elements or grid or something to just make moving things around smoother? 

Take the example below, imagine you have:Category.ProductsProduct.CategoryA product is linked to multiple categories. When you first create the 'Category' field on Product, this creates the other side on Category, lets call it "Products".  If you delete the column "Products" from the Category, is it possible to re-link them later on?Also, if you do not think one will ever need the "many" side of the relationship - does it slow AirTable down if you keep that many-side Field as well? Or it does not make a difference?