Other Questions

i have a communication log table, when i request something from Client and he didn’t replay the record still opened , i forced to call back to the client and open new ticket , finally i found may tickets still opened , how can i close all opened ticket related to to same client automatically

Hello, I’m using the Airtable Python wrapper found here: Airtable Python Wrapper Documentation — Airtable Python Wrapper documentation I’m trying to get all records modified after some date time. My code is: AT = Airtable(BASE_KEY, TABLE_NAME, API_KEY) filterByFormula = ‘IS_AFTER(LAST_MODIFIED_TIME(), DATETIME_PARSE(“2022-03-15T14:23:41.000Z”))’ AT_ITER = AT.get_all(formula=filterByFormula) However, this is always returning every record in the table. Also, how do I get it to return the last modified date in the fields? I have tried: AT_ITER = AT.get_all(formula=filterByFormula, fields=“lastModifiedTime”) …but this throws an error. The docs say the default is to return all fields, but there’s no modified date field when I try that, either. Any help, please? Thanks!

Hi Guys, This is probably a pretty easy one - for the right person… haha. Pls see attached. This cell started as CURRENTLY AVAILABLE. Then a linked record called ‘2022 Camry’ was added, and I now have ‘2’ records in this field. How do I automatically unlink (remove) **CURRENTLY AVAILABLE", ie, updating to only leave the record called ‘2022 Camry’. Thanks!!

I am trying to a similar thing, but instead of adding an INTERGER for the multiplier in the DATEADD formula, I am trying to pick up a value form a table LOOKUP. Have also tried with a FORMULA cell and it doesn.t work either. I have different categories of appointments to book, that each have different duration and priorities TIA, Duncan

I am very new to Airtable and struggling with one piece of the puzzle. I’ve read a lot of posts and articles but can’t seem to get this relatively simple thing working. I’m sure I’m missing something obvious. I am trying to use Airtable to house information for my meal planning and shopping. I have three tables. 1-Dishes/Recipes (Where all of my recipes are stored, tagged by meal and such). 2-Ingredients (A list of pretty much every possible ingredient). 3-Menu (A menu of what I am eating for which meal on which day). All of these are working as I want. When I add a new dish, I can add an ingredient from the list. The menu pulls information such as which meal of the day a dish belongs to when I add an item. All great. The struggle is that I want one more table for a grocery list. I can manually type each ingredient onto the list, but I was hoping for more automation than that. I want it so that the Grocery List table adds a record when a

Is there a way to make an address clickable so when a user clicks it bring up a Google map for that address without utilizing a block?

Hello I would like to extract a value after “HR” word. This value can be of 2 digits or 3 digits String: 146/63 HR: 78 oxygen: 98% T: 36.8

We are looking for a script similar to Running Total, except instead of adding the previous record to the one below it, etc it would add a Units Received field to a Total Received field everytime the Units Received field is updated. How would I go about something like this?

I am using Airtable to run a daily medical care routine. Every day follows the same set of routine records all with that day’s date. “Use same timezone (GMT) for all collaborators” toggled on. I am trying to filter to get a view of “Today”. When I create a Datetime filter where Datetime is “Today”, the “Today” is defined in in GMT = 0 and I live in GMT = -6, so at 6pm my “Today” filter stops working. Is there a way to change the timezone of the dynamic filter? I have not tried toggling the timezone setting to use my local timezone, as this causes issues with my setup in its current configuration.

How can I paste multiple records into a single linked record cell so that it is recognized as multiple linked records and not a new record with the concatenated name of all the pasted records? I have two tables (Table 1 and Table 2) which are linked. Table 1 has a column which can link to multiple records in Table 2. I have a separate Excel document which lists the associations between records in Table 1 and Table 2 and am trying to determine how to paste these into Airtable to document the links between the records. For example, Table 1 has the following records: 1 2 3 Table 2 has: A B C D E My excel sheet has the following pairs 1 - A 1 - C 2 - A 2 - B 2 - E 3 - D In this case, I am trying to copy record “2”'s associations (A,B,E) and paste them into the single linked cell in Airtable to link those records between the two tables. When I copy A,B,E in their individual rows in Excel and past t

I have “next meeting date” in one table (a table describing regular meetings) and then I have “event date” in another table (describing one time events). I’d like a calendar view with all those dates. I’m thinking about auto-copying dates into a “dates table” when a date field is updated, wondering if there’s something more elegant. Thanks

I need to build this /dp/B079KHS5CY This part B079KHS5CY comes from my “Data” column. How can I combine this together to form a proper URL? Thanks in Advance

Recently I began changing over from gmail to apple’s mail. I usually sign into airtable with apple–that is, not with an airtable password. I couldn’t sign in because the new apple email wasn’t recognized as a member, of course. So I hit, “forgot password” and made a password. I signed in with the new password and gmail account. Then I went into my account and changed the email to the newer one at apple. Now online I cannot get my workspace at all. It is still on my phone (perhaps still signed in with old mail?) I tried changing my email back to the original one, but that did not help. Is there anyway I can get the workspace back online? I’m afraid it may sync my phone and then I will have lost all my info.

I’m syncing a table from 1 base to another which contains 30 or so employees and their daily salary on a project. At the end of the day each day, I would like to add all the employees and their salaries to another table, the data table, in the base. As I add employees (or offboard them) I would like to only those people in that day’s list. Do I need to have 30 different automations, one for each employee? And how do I deal with employees being onboarded and offboarded? Perhaps a script or something can elegantly solve this? I do not know how to build scripts personally. Any advice on this relatively straightforward but hard for me issue would be greatly appreciated!

Hey! I use Airtable to plan a basketball practise. I bring the information for each exercise by pasting it from Excel into the “exercise plan” table for the participating athletes. When I paste the Excel data into the Airtable, the date field changes to a text field. Can anyone tell me why this is? I have modified the field types in Excel and Airtable in many different ways, but the problem recurs over and over again. I have a similar table in another account and this problem doesn’t recur there?

Sometimes I need to copy a record from one table and paste it into another. Until this week, I was able to do so with no problem. However, now I’m having an issue with multiple select fields. For example, one field is for a person’s availability, and they might select three days (e.g., Monday, Tuesday, and Wednesday). When I paste the record into a different table, it creates a new option within that field called “Monday Tuesday Wednesday.” I want the days to remain separate. Airtable Support said that creating a new option is what’s supposed to happen, but that doesn’t really make sense to me. They gave me a couple of workarounds, which would make the process more time-consuming. Does anyone have any suggestions? Thank you!

I have a scenario where I need to create “Booking” records in AirTable via Zapier in which some bookings might have multiple “Payments”. These Payment records will already be in AirTable, but in this Zap I need to create a new Booking and relate the two existing Payments to it. How can I use Zapier to create a new Booking in AirTable and connect two existing Payments to the Booking at the same time? I’ve tried using a comma delimited list of Payment unique ids (see screenshots).

Hello! I’m a bit of an Airtable novice, asking on behalf of my employer who definitely knows more than I do. So I can get more information if necessary, in short :slightly_smiling_face: We are building a table for rental items that are checked out, and we want to have it know that a particular item is not available for rent if the requested time falls between the day it is to be checked out and the day it will be returned. Is there some way to have this range automatically populate? We are struggling to figure it out. If there’s any further clarifying info I can give, please let me know!

Any idea why this is giving me the same result? I assume this should be a negative number not zero right?![ https://photos.app.goo.gl/vyBy9Ij2WerlK2XF3 Day formula : DATETIME_FORMAT({Meeting Date}, ‘dddd’) Days Remaining formula: DATETIME_DIFF({Meeting Date}, TODAY(), ‘days’)

Hi sorry if this is really basic but I am completely new to using Airtable so I have a basic data set and am looking to create an invoice, I have the page designer up and it has the options in blue that are in my table (Client, net amount, vat etc) and the option to add images text etc. What I can’t find is the mode option that allows you to list data format it into a table etc? We do have the upgraded version I just can’t get it to look right in this view can anyone help?

Hi everyone, I want to trigger a script that will create a new section. inside the section, it will create views and filter them. I couldn’t find a way to achieve this. I searched in the community and found that this had been requested before. this s would really be beneficial to have since it will automate processes. Also, another thing is having the ability to duplicate a section with all the views in it. instead of duplicating all the views in a section, move them one by one. Is there any way for these features to be applied! or maybe it is applied already but I haven’t found a way to use them yet. Thank you

We could save a lot of time if we had a little more control over the Gallery, when we embed in the website. We’d like the headlines to flow, variable width for the columns, a limit on # of columns, and RTF formatting for the fields. Is this in the works? Is there another solution or app? How are people solving this problem?

Hello, so we have created multiple databases to put on our website. the databases looks clear when using a laptop however when using a mobile devise, the database looks like completely different. How do I get the view to be the same on both desktops and mobile devices.

Just curious if Airtable recently updated the way their iOS app loads data? I have large bases that use to fail to load or load super slow sometimes, but recently they have been opening super fast. Not sure if it is new phone, but very impressed by current load speeds!

Hi. There are online forms hosted by other orgs that i need to fill repeatedly, with different data each time. I also need the same data to be stored in Airtable. Is there any way to either 1) Enter the data into AT first, then use the AT data to automatically fill the form using some kind of macro/extension/app, or 2) Enter it into the form, and then export it to AT before I submit. I’d rather not enter it twice! Thanks.