Solved

Hi! good day!I am currently using the formula below to determine if a record/records is within last weeks Sunday to Saturday. Sunday being start of the week and Saturday being end of the week. AND(       IS_AFTER(           {Time in},           DATEADD(               DATEADD(                   TODAY(),                   -WEEKDAY(TODAY(), "Sunday") - 7,                   "days"               ),               0,               "days"           )       ),       IS_BEFORE(           {Time in},           DATEADD(               DATEADD(                   TODAY(),                   -WEEKDAY(TODAY(), "Sunday") + 0,                   "days"               ),               0,               "days"           )       )   ) If today is the 20th of June then my Current formula will tag my June 8 , 8AM record as false. If I adjust the time to 8:30AM, formula will tag it as true, would like the formula to include the entire day of sunday up to the entire day of saturday. Appreciate the help!

Hi Dear Community how to add a column for updating the price same as ther second image Thanks         

Hi, I have about 50 task fileds that each have a status. They can be marked as Assigned, In Progress, Complete, Question for Supervisor,  Question for Administrator. Each field is a multiple select field, because sometimes there is a question for both the supervisor and the administrator. I have a view for the supervisor and a view for the administrator that are each filtered to only show tasks that have a question for them. I have a formula field for each them that pulls out which task has the question.The formula for the supervisor is as follows: (The admin has the same formula, just with ADMIN instead of SUP in the formula)CONCATENATE( IF({Task A Status}="Questions for SUP", "Task A"), IF({Task B Status}="Questions for SUP", ", Task B"), IF({Task C Status}="Questions for SUP", ", Task C"), IF({Task D Status}="Questions for SUP", ", Task D") ) This works great. My question is, what if I have a question for both the supervisor and the administrator. Right now, if both those options ar

Hello all, We have recently implemented Airtable on our team to account for hours worked by employees. To gather the information, I created a form in which they answer at the end of every work-day to take into account the actual hours worked. These answers feed a database that groups every reply by week/employee. In the database, I created a column of “Work-day” which is the employee’s weekly hours divided by 5 business days. This way, when they answer the form, I would have the daily overtime and then it would be grouped weekly and it would give me the weekly overtime.However, the team is mainly composed by part-time workers and that’s where it becomes tricky. We don’t really enforce a fixed start/finish hour, so a person who has a contract of 18 hours/week, may work only 2 days one week and then 5 days the next week, picture below.  What I would like for it to do, and that I wasn’t able to, is to calculate how much overtime (or time they didn’t work) they are doing per week, based of

I have an interface that has linked table of images.I need the user to be able to rearrange these records by hand (drag and drop) so they print nicely and the right order. This works if I do it in a view. However the user should only be in the interface. I seem to be able to find anyway to rearrange these in an interface using either a gallery or cards. Is it me who a missing a check box to allow this?

I need help creating a formula that will create a link that will show property details, access codes, checklists, photo uploads (for a cleaning business) thank you in advance!

Hi community  I'm stacking with how to put 2 or 3 on the same page in the interface  

Hi, wonder if I can relate data in different workspaces. Or it will be completely separated?

 Hello I struggle to configure an action button in the Record Detail view: I wish to update a check box field to ‘NO’ and then to ‘YES’  such that to trigger an automation, but that does not work. It is weird that if I configure both Updates to ‘YES’, the Button takes the ‘After.. ‘ appearance as default. What am I missing?Thanks   2 Updates Button  This is what I wish to doWeird behaviour (??)  

I’m trying to use the record review interface in one of my interfaces, but instead of loading the record details, it just shows a persistent loading spinner and nothing ever appears. I’ve tried refreshing and checking permissions. Has anyone encountered this before or found a fix?

Hello! I’m trying to make a templated onboarding document that we can easily update with information fed from Airtable. Here’s the direct use case (Integrations are generally off the table in a corporate security setting): Hire Roster (lives in Airtable, holds new hire data) Microsoft Word/GDoc/OneNote (whatever!) that is complete with specific fields waiting to be fed new hire data, will serve as new hires’ onboarding document. Is there a way to automate the process of filling out a document without manually doing it?

I have an excel file that we currently filter by 3 to 4 fields to come up with a price for an item for vehicles. We filter by Year, Make, Model, and then for certain products, we also end up filtering by other parametes, but I’ll use size as an example. I am trying to create a form where instead of having to exit and go to the excel sheet, a person could potentially do the following: Select year → this should provide the filter for the next question and only return Brands for those years When they select a make, it should filter the next question to only show models for the selected brand. When they select model, if there are 2 models, it should bring up the size field for the next question, if there is only one model, it should bring up the ID for that specific model in the next question. After it brings up the correct ID for that model, it should show the only price option for that ID. I know I can import an excel file, but I’m not sure how to get it to let me make a form that filt

Trying to create a condition via formula which will mean that a client won't be able to be quoted via airtable extension with the following:Formula:IF(Type="Client", IF({On Hold}="On Hold">"Good", "✅ Good to Quote","❌On Hold - Do not Quote"))We are hoping to then enable the On hold note to propagate through to an extension we use to send quotes onto clients There is a field with single text which we use to fill out the client and then a options single select for on hold/good

I have a question regarding the page designer extension. How to make the data fields automatically adapt to the amount of data to display and for the extension to create as many pages as necessary? I am setting up a contract. This contract contains a “travellers” paragraph. Under each traveler, page designer displays the information concerning him (package chosen, date of departure, date of return, details of flights, details of accommodation, etc.). The number of travelers naturally varies from one contract to another. There are contracts with 1 single traveler and others with 40 travellers. On page designer the reserved field does not adapt to the amount of data. In addition, we only have the right to 1 single page!! How to solve this problem? Thanks

Heya everyone!So I noticed that on the Airtable update API endpoint they note about upserts:Airtable reserves the right to throttle upsert requests differently from the standard rate limit throttling policy.Intuitively, I’d assume that differently means that they’re more strict about it as they’d be doing comparisons on their end.Does anyone know whether upsert is throttled more aggressively than plain updates? I’d assume so but I thought I’d get it cleared up.Thanks!

I have a base that is largely used for planning.I have a lot of automations. Often one action sets off a chain of 4-5 automations.Because I use this base for planning, records get deleted often as part of my workflow (i.e. I change my mind).An unfortunate, unexpected irritation with this is that reasonably often, an action will set off an automation > I delete the record before the automation is finished (these are usually simple automations "if Record A Field A = x, update Record B field A" - most are not long and convoluted).And so, I have a significant and frequent number of "failed automation: record not found" emails and notifications.Is there any way to prevent this happening?

Hello, I’m new to Airtable, (trying to help a friend build an efficient solution) and I’m looking for some advice. We have a form with a rather large multi-select field. Users must enter their name, date and select any number of options from the multiselect field. The information comes into the table in the way you would expect: But in order for it to work with my friend’s processes (and existing tables) they need a way to break the record up (ideally on form submission) into multiple records: I found a way to do it with automations. I created an automation for each Option to check to see if that option has been selected, and then create a new record. Unfortunately, this is time consuming and will not scale well. Can you recommend how to build an automation script (or other solution) that can automatically parse the multi-select field into multiple records, one for each selection? Thank you,

Howdy good people!Hoping someone can advise with a product code lookup scenario. Our team sells training subscriptions. New subscribers submit airtable forms to notify of catalog onboarding. Each subscription is tied to a certain product (9 product types currently). Product name auto-populates in a multi-select 'Product' field upon form submission in an 'Offline Subs' table. Each product has a set unique code stored in another table (Product Codes). We need to auto lookup and match the product name with corresponding product code and auto populate this in a 'product code' field in the 'Offline Subs' table (see attached). Playing around with lookup fields and can't see an automation option, imagining that this will require a script to achieve?I don't have any coding/scripting experience so hoping someone can share a similar successful script or use case experience. Any assistance greatly appreciated. 🙂

Hi everyone! Our library uses an Airtable base for approving programs, some of which are one-time and others are repeating. We’re running into a problem where we’re sometimes overbooking on a single day (this is across multiple branches, so we have the room, but we try not to host too many programs on one day) and we’d really like to see all our programs on a calendar view. The problem is with the recurring programs. Right now, the base is set up with a text field where programmers put in their dates (e.g. “every third Wednesday from 11-12”) but obviously Airtable can’t read that. We could set up individual date fields for each occurrence, but some of these programs are staples, held dozens of times a year and would necessitate dozens of date fields. As a work around, I tried making a separate “Calendar” table with the dates as primary fields, and then in the main table, the date field became a linked record field. In Calendar, I created a calendar view and that technically works, but

HelloI have two tables Customers and Orders. They both have a CustID to link the order to the customer that placed it.I need to import a CSV file to Orders and this includes the CustIDI can import as a regular field but can't figure out how to import it and have the Link to the customer tableThanks in advance for any helpMike

Hi, I am new here. I have some columns like name, email, job title. I have 3000 rows of these data. I want to send personalized emails to all of these 3k users with their name and job title. How can i do it? Is there any automation or extension available which can help me with sending these email automatically?Thanks for help.

Hello there, I want to create a form in Softr, connected to my Airtable DB, where my employees will input their availabilities for “next week”, so I need to generate automatically the “next week” concept. I have created a table “weeks”, with the following columns :Week number Year To generate the concept of “is next week”, I want to create a date field “today” that updates automatically on a daily basis, and then in the field “is next week”, put a formula. However, I don’t know how to automate the update of the date at “today’s date” . Can you please help ? :) 

HelloI have a table, shown in Interfaces as a list and I designed a complex Record Detail. I have duplicated the list for convenience in a different interface - thinking I could amend it in the second interface (I only need a button), but it seems the two record details are linked, I cannot edit one alone. Is there a way to un-duplicate the two record details, without having to rebuild the list and record details? 

Hello I am trying to share an interface to new users as view-only. This shared interface should be as low-effort as possible, immediate access to the table and the detailed records, nothing else. Instead the invited user is asked to sign-up (for free), is shown an horrible and totally irrelevant App Builder process and shown he has 14-days free account. This is totally unacceptable for us: is that how it is supposed to work?  How do expert users of Airtable do this? Is it possible to embed the interface somewhere else? Or do we need to build in our website these interfaces via API? 

Hi Everyone, I’ve been searching the community pages and it seems that there is no way to create PDF’s automatically from templates created using Page designer, is that right? I’ve created the field type ‘Button’ to click which displays the document in the page designer app perfectly. But, I then have to manually save it as a PDF. What I’d like, is to be able to click the button and for that document to be automatically downloaded and saved as a PDF file. Surely this must be possible? It just seems crazy that the button can produce the document but can’t save the file. Am I missing something? What do people use the Page Designer app for if not to create documents which they then want to attach and send to their customers? Thanks, Rosa