Other Questions

I have a base and a table that tracks a list of classes by title, also showing date and assigned faculty. I need a list organized by faculty showing which classes they have each taught in the past. The assigned faculty is a linked record field that pulls faculty names from another table. This at least gives me a list organized by faculty. But, when showing the courses they teach, it shows every instance of a course taught, which may result in too many duplicates. For example, if John Smith teaches Class A 20 times in a year, Class B 5 times in a year and Class C 3 times in a year, I just need a list showing John Smith teaching 3 classes, not 28. How can I eliminate those 25 duplicates and just get a list of each unique course title taught be a faculty? So far, I have just exported to Excel and manually removed duplicates. But, this is a time consuming way to run a report regularly. Any help is very much appreciated!

I have an onboarding form at google forms. I know you can use type form to sync to Airtable but I already built the google form and its free how to keep a google form sync’d to Airtable is it still just Zapier?

hey I have a service co there is client info and notes on the job one field is materials needed so I made a view of just the field of materials needed but now I would like to operate on that you know, sort it by supply house or group it independant of the job or dependent on the job. any way to gather up all the entries for this field over many records and then sort them, and then put them back to view in other ways? it would even be best if we could call from a database of commonly used materials when we made notes on the job thanks!

Hi, I’m struggling with this script (I’m a newbie) you see below. I have the array “dependencyOrderSplit” which, can have more than 1 string object. I should use these strings to filter thru “let filteredRecords = queryResult.records.filter” and comparing the string field “order” with ALL the objects [0, 1, 2, etc.] and retrieve the record.id which comply with that. My problem is I don’t know how to obtain a new array with ALL the filtered records. If I use [0] as in the example, only object 0 is retrieved, but object 1 not. Any ideas?

Having issues coming up with the following formula need. I have a “Delivery Date” field with a date. I have another field where the forumla will be “Settlement Date” The Settlement Date needs to look at the Delivery Date and then automatically calculate next weeks Friday date. Issue is the work week is Monday-Sunday and pay day, or “Settlement Date”, is the next week on a Friday. Example 1. Delivery Date = Sunday 12/12/21 then Settlement Date = 12/17/21 Example 2. Delivery Date = Monday 12/13/21 then Settlement Date = 12/24/21

Not 100% sure on the best way to create a CRM & Project management setup. Currently we have the pipeline in one tab, a list of jobs in another tab, all the shifts including £rates in another tab. We want to keep the pipeline tab for selected people only. We also want to hide the £rates fields in the shifts tab so to prevent certain people from viewing them. How can we restrict views of tabs and certain fields please? Is it even possible to hide tabs? Or is it better to create a separate base and have certain fields auto sync to the other base? Thanks in advance. Pete

I have an asset that is linked to an owner with a % holding and to many valuations. I want to view the data for a selected owner, with a current value of the asset calculated from that owner’s % multiplied by the LATEST valuation - ie from the valuation record with the latest date. Filtering is easy enough and rollup field looks promising but there seems no way to use the latest valuation record in the calculation. I need to select the person and then print or export the results that values their entire estate by combining latest asset valuation with % owned. Is a custom app needed (that feels unlikely given what I want to achieve would be trivial in SQL)? interfaces don’t seem to do it and views neither as far as I have been able to determine so far. It seems like something that would be used frequently but I’m in my first few hours with AirTable so a pointer to a help article would be great, thanks in advance!

If you duplicate a page designer app and select a new source table, you have to start all over again with your design. It would be incredibly time saving if the static text fields and images would remain instead of being deleted. User case: app for invoices > duplicate for credit note

I’m looking for a way to set the filter to only show the next workday. I’m a teacher [primary school] and each day we have a ‘topic of the day’. That topic is introduced by me the day before by a riddle. Because i would like parents at home to talk to their children about this riddle (and try to guess the topic together), I made a base with all topics, their riddles and the dates i will talk about them. I’ve made a ‘view’ with a filter ‘where -date- is tomorrow’, but on fridays this doesn’t work as it has to show the riddle for the topic on monday (there is no topic/riddle on saturday). I’m only using Airtable for a few months now so maybe the solution is simple… Any help would be appreciated!!

Hi, we have encountered problems with our app. We made a kodular app that is making calls to airtable but when we have more than 150 records , kodular app is freezing and we cant load records. Is there any solution to improve speed of querys? pro plan or something?

This is probably out of the realm of Airtable, but I have scroll wheel settings to where I like them for all other apps. But for some reason, each “click” of the mouse wheel is effectively the same as hitting the Page Up or Page Down key on my keyboard. I think it’s because the rows on my base have a lot of paragraph text fields which make them quite tall. Is it possible to adjust that so that it only moves by a set number of pixels rather than (I’m assuming) a set number of rows?

Hi I have created an automation on my ATS airtable base - that automatically send an email when a particular status change occurs. However, I would like to delay this email, i.e. I do not want the email to be sent as soon as the status is changed, I would like it to be sent after 1 day for example. How do I go about this?

I’ve collected a lot of data on a site inspection and used page designer to create the single page records, however when trying to bulk print these records, the app crashes and won’t print. Is there a work around for this, or a code we can use to get it print each row separately? It’s going to be incredibly labour intensive if we have to do each row separately manually!

I have one table with header as Field Name and the values in the column as First Name, Last Name and Address. I want to create another table with values from that column. So another table will have header as First Name, Last Name, etc. And I will be adding rows of data in another table then. Is this possible?

I share View links with different stakeholders so they can see records that fall under their department. I want to be able to have a View or some other easy to way to see what records they edited so I can review any changes that were made. Since they are typically making the edits after clicking on the link and not signing in, the Last Modified By usually shows as Anonymous. This has made it hard for me to filter since any records submitted through my form also show Anonymous. So I’m trying to find a way either to be able to specifically view edits made through the shared links or perhaps on the flip side make it so that records submitted through the form don’t show Anonymous for Last Modified By so those wouldn’t be populated using a filter showing Anonymous changes.

For video editing purposes, how can I input timecode into a field? The format could be either: H:MM:SS (hours:minutes:seconds) MM:SS (minutes:seconds) In the article Supported format specifiers for DATETIME_FORMAT I found “Preset timestamp format”, but that’s a timestamp. My desired format is time duration, similar to a stopwatch. Thanks!

This community has been invaluable for me learning about all the cool things Airtable can do! My question was asked nearly identically on this post and I almost got my answer, but I’m having a bit of trouble on how to add a single select field to my template task creation. Everything works until line 20, where I tried to plug in ‘Category’–a single select field in my Tasks Template–in all manner of combinations , to no avail. Here is the script that works entirely well except for that one line. Can someone tell me what I’m doing wrong here? Perhaps @JonathanBowen since he’s the one that came up with this. :slightly_smiling_face: let eventsT = base.getTable(‘Events’); let tasksT = base.getTable(‘Tasks’); let eventTemplateT = base.getTable(‘Event Templates’); let tasksTemplateT = base.getTable(‘Task Templates’); let tasksTemplateQ = await tasksTemplateT.selectRecordsAsync(); let event = await input.recordAsync(‘Pick an event’, eventsT); let eventTemplate = await input.recordAsync(‘Pick

I don’t quite understand the api documentation for how to retrieve one particular record. You can’t send a body in a get request can you so it all has to go in the url. I’m not sure of how to format it. I have an emails table. I want to do a GET request when a user enters their email address to see if we already have it in the table. The api documentation says to retrieve a record I have to set the url up like this but I can’t get it to work. Please could somebody tell me how to construct the GET request url for this so i can pass in my api key and the email that i’d like to search for?

Hi all, Just wondering if it’s possible to have the Google Maps app as a view rather than an app? I remember the Gantt chart used to be an app only, and is now available as a type of view. Can we do the same with Google Maps app? If not, can the dev team look at this as a future update? Cheers, Andrew

This is so simple, and yet no matter what I try, nothing works. :confused: I want the due date to be 2 days after the creation date. I’ve tried a hundred variations of: DATEADD({Created},+2,‘days’) …to no avail. What am I missing??

I see this was a problem before and was fixed. Well it’s back. Fix in the works? Thanks

The categories no longer show up color coded on my app, does anyone know what to do about that?

Hi Airtable Community! I’m building a base to track musical artists that I am booking for a benefit concert series I will be hosting and I’m having trouble dealing with a specific issue: Right now I have a list of artists with their booking prices, and I need a quick way (through a formula ideally) to take those prices and place the artists in different price brackets (with $5000 increments) to understand how I can pair artists from different price brackets together to meet my estimated budget for this event. For example: If I have an artists who has a rate of $750, they would be in the bracket of $0-5000 If I have an artist who has a rate of $5500, they would be in the bracket of $5001-10,000 If I have an artist who has a rate of $10,1000, they would be in the bracket of $10,001-15,000 ect Basically the idea is that I can use airtable’s grouping function to be able to view artists that are at similar price points. Does anybody know how I might be able to do this? PS: I have also alr

I would like to show the start date, planned or original end date (that was missed) and NEW planned end date. And ideally showing different colors between the dates. Is this possible? Heather

Hi, I want to use record specific webhooks to automate when people click a personalised link related to their own data that record is updated. Click external link > record updated > email sent The code I have is CONCATENATE(“https://hooks.airtable.com/workflows/v1/[etc etc]”,"?RecordID=",RECORD_ID(),"&M=TRUE") Which creates the URL https://hooks.airtable.com/workflows/v1/[etc etc]?RecordID=BLAH&&M=TRUE I want to put this into a button to click but nothing works. IF I put it into a browser it doesn’t do anything. What am I missing here? Do I have to do something like MAILTO:HTTPS …