Other Questions

Hello everyone. I’m trying to set up an automation to create new records in airtable when I update a row in a google sheet. A little background, I’m using an email parser to gather order data from emails, which are then sent to the google sheet. I want the google sheet to then update my airtable orders page. Mostly it seems to work, except that I can’t seem to update linked fields. For example on my orders page, each order is linked to a “Customer”, and I have a separate “Customers” page. If my google sheet has a name for the order, it is unable to update the “Customer” field on the orders page. However, if I create a new column which instead of being linked to my “Customers” page, is just a single line text field, then it is able to update. However then I’d have to manually go in and edit the linked “customer” field. Is there anyway to have the google sheets to airtable automation update a linked field? (Link to an existing customer?) Could it also crea

I currently need to calculate, given any date, what is that week’s Saturday. I am currently using to following formula: IF(Start,DATETIME_PARSE( DATETIME_FORMAT(DATEADD(Start,-DATETIME_FORMAT(Start,'e')+6,'days'),'Y-M-D'))) , where Start is the date to be used as input. The issue I have is that, while it works in the middle of the month, If I have a week that spans multiple months, this does not work. For example. inputting 1 December 2021 should yield 4 December 2021 as output, but I get 1 December 2021 back instead. If I input 8 December 2021, I get the expected 11 December 2021 as output. Any ideas on how this can be fixed?

I have a List where I want different non-registred people to enter data using a form, and afterwards being able to see the results. It works well with the form, and I have the link to the shared grid view after the submission, so that the people can watch the results. The grid view is grouped and I have the problem, that the view is not grouped on mobile phones. It works fine on PCs. However, the view is grouped on any device as soon as I have signed in. So it is only the shared-by-a-link-view that is not grouped. Anyone knowing more about this issue? Thanks in advance, it would make my life so much easier! :slightly_smiling_face: Best Peter

Hi I am stuck with a problem here. I have two tables. Table A where a single record can have multiple relations to records in Table B. In Table B I have a field with numerical numbers. So my challenge is to make a form from Table A that can manage a one to many relation in Table B AND add the numerical numbers to Table B as single records. The numerical numbers show up in Table A as numbers seperated with commas. Is there a way to accomplish this. I have made Interface that works in the new Interface Designer. But the interface seems not to do well on mobile units and can not act as a form without a user to be logged in. Is it possible to have it as a form like in views ?

I’m trying to be able to sort my groups by the first created date/time of a record in that group. Essentially, I am trying to create an order form, where the customer’s phone number is the primary field. Each item a customer orders will need to be its own record, and there might be multiple customer orders coming in from the form by different employees sometimes a few minutes apart, but each customers’ items would be fulfilled at the same time. In my screenshot, I would need the 0433 order to come 2nd, as the the first item for them was placed before the first item for 0422 . Any help would be greatly appreciated!

I want to sync one view into another base. I found this documentation stating how to do that. As far as I understood, that Link that I create can be viewed by anybody in possession of that link. In addition, I can protect it with a password, but then the sync will stop working. Is that correct? If so, the sync feature is pretty much useless for everyone who doesn’t want views to be accessible publicly (I know, it’s a private link, but I don’t really trust that kind of private link), or am I mistaken? Am I missing something here?

Hi, I would like to design a base that multiple managers can see which employees (labor hands) are available in half day increments (morning and afternoon). Ideally, managers have a running task list that is then assigned to an employee and all managers can see which time slots are taken and available. Currently a spreadsheet is used with 2 row entries per labor hand (morning and afternoon) and a column for each calendar day of the year. A tab is within the spreadsheet for the running task list and each task is given a number. That number is then assigned by typing in the appropriate cell to an employee for a specific date or dates for the morning and or afternoon. I’ve considered making an airtable with all calendar dates with 2 records each (morning and afternoon) then having a form created to send to each employee with their availability. The form isn’t allowing multiple dates to be selected. The problem is the ease of use with the spreadsheet for managers is high, meaning

Hoping you all can help a new Airtable workspace user out. I’m trying to find the right combination of permissions that would allow someone outside our organization to: Access a table or base ideally with a shareable link and Have editing access to the fields in selected column only. Essentially lock/unlock columns while all others remain read only. I do not want to give access to: Expanding records which allows information in the hidden fields to be seen. This happens when giving read only and above access to a base users. Is this possible? Any insight and guidance is greatly appreciated!

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 =