Other Questions

I am trying to understand the logic behind date and time fields. When I have a field in one table that is just set as a DATE (no time), and I do a lookup of that date in another table with just DATE (no time), it adjusts the date to be one day before what I have set in the originating table. When I add the time I can see it is adjusting for timezone, but the date I have set it with my timezone in mind already?

I have a view set up to group a user with the a single select tag. I’d like to find out the count of each tag for a user. Can’t figure out how to make this happen so I can link it to a chart. Ex. use case: User 1 has 4 items attached to them with 3 tagged as new and 1 as old. I want to total account of the tags with it still being associated to the user. Any help is appreciated.

Hi everybody, my question is how do I link records from a base table to another base table, is this possible? I’m working on two different bases, Product catalogues /orders and business budgeting. I would like to link order sales from the Product catalogue base to the income table in budgeting base. How do I do that? Thank you in advance Ramona

I am experiencing some type of bug with the Grouped By Function in one of my bases. I wonder if anyone is seeing/experiencing the same. Net/Net, when we duplicate a record, for some reason Airtable is NOT grouping the two identical records together. My company has been using Airtable with this repeatable process for nearly 4+ years on a daily bases. For whatever reason, within the last 72+ hours, we have been experiencing this issue. The field we are grouping is a linked record. I am experiencing this issue with multiple linked records that are either simply number fields or text fields (no automated numbers or concatenates). Any ideas what is going on?

I am looking at switching my customer contact database from access to airtables, but need to know if there is a way to do a mail merge where you create mailing labels. each week i need to send between 20-50 different customers items by mail.

Hello All, I am creating a roadmap for my business and i need to setup the following event. Happy Hour - 7-9pm occurs Mon - Sat from 9/21/20 to 11/21/20 Kettle Bell Class - 5-6pm every Mon/Wed to run for a year 9/21/20 to 9/20/21 I have the pro plan. But, i simply want a calender to display these things. I have tried date ranges, but the times aren’t calculated. I have gotten it to work if I create a record for every individual day, but that is extremely time consuming. There has to be a better way. Can anyone help with steps? I know some people have discussed creating a linked table, but I can’t seem to get this to work. Any help would be greatly appreciated. Thank you.

I am an engineer looking to develop some team schedules for my department for ongoing projects in different phases of design. For example, a single project may have a schematic, design development, and construction document design phases. I am able to add a date field for each submission but the timeline view only shows from beginning to end without the intermediate dates in between. Any suggestions without creating different records.

Hi! I am using Airtable to store responses from a Typeform survey. I am also using Automate to send out a thank-you after the Typeform is completed (this automate is only connected to Tyepform). However, when someone fills out the Typeform survey, I see 2 exactly similar responses in the Airtable. Why is this? How can I ensure that someone’s response is not duplicated?!

I’m using a ‘vlookup’ style script below as part of an automation triggered each time a new record is created. //Substitute "Orders" for table name which contains values //on which you want to run the vlookup let mainTable = base.getTable("Litters"); let mainTableRecords = await mainTable.selectRecordsAsync({fields:["breed_string"]}); //Substitute "Product" for table which contains range to search in let lookupTable = base.getTable("Breed Landing Pages"); let lookupRangeRecords = await lookupTable.selectRecordsAsync({fields:["Name"]}); //Replace "Item.barcode" with column name which has the values you want to look up for (let record of mainTableRecords.records) { let lookupValue = record.getCellValue("breed_string"); //Replace "Barcode" with column name which is the range to search in for (let rangeRecord of lookupRangeRecords.records) { if (rangeRecord.getCellValue("Name") === lookupValue) { let linkID = rangeRecord.id; //Replac

Hello! I’ve built a base to track one consultant’s hours and expenses for several different clients. The table I need to draw data from is the Hours and Expenses table. Client / date / rate is the ID field, then we have date, hours worked, a lookup field showing euros per hour, and a formula field showing billable hours in euros. Other fields I need to be able to summarize by month are the billable kilometers driven and the billable expenses. The consultant has a form he fills out to populate every record: he enters the date, his hours, his kilometers, and his expenses for about ten different clients, plus descriptions (either single-selects or text) as needed. At the end of each month, we need to be able to see how much to bill each client. Is there a way to have all the hours worked records automatically summarized, without anyone having to go nitpick through a list one by one? Same question for billable km’s and expenses. I have a “billable?” checkbox field for the consultant to che

Hi, I am using this formula (DATEADD({Estimated Start Date},Calculation,‘days’) to create the attached result. However, I would like to then use this result to populate “target delivery date” in an automation, and got an error that it did not like my string. I am assuming it has to with the time. Is there a better formula? For Context, I need to have Target Delivery Date as stand alone field, not a formula, for various reasons.Hence why I want have an automation to populate it if “Calculated Date” is “Not Empty”

Hello, I am new to Airtable. I have read the documentation (several times!) but I can’t seem to get my head around a simple filter when using the API (curl). My URL: “https://api.airtable.com/v0/{AIRTABLE_BASE_ID}/{TABLE}?fields[]=&filterByFormula=DATE_START+>+‘2021-05-25T06%3A27%3A31.169Z’” The field DATE_START is a date and I am trying to query for dates later than a given. The error I am getting at the moment is: {‘error’: {‘message’: ‘Unknown field name: “”’, ‘type’: ‘UNKNOWN_FIELD_NAME’}} So my understanding is that the formula is not correct. I am using the URL enconder provided in the documentation and I suspect that the error may be in the formula itself (date later than X). My formula can be used from the graphic interface, but I can’t find the way to translate it to “code” Any help would be very much appreciated. Thanks

Howdy all, I’m having a bit of trouble working with Google Books API. I’m uing Data Fetcher to connect and I’m able to pulll down tons of info, but I’d like to narrow that information down to the correct book that matches the Book Title and Author. I add those values in Data Fetcher but I’m getting over 1500 results. :astonished: Is there a way to narrow the search to exclude the data I don’t need? Newbie at using APIs so maybe I’m missing something really simple. :face_with_diagonal_mouth: My use case: User enters in details about a book. I then want to hit up the API to pull down the missing information like the book cover, publisher, isbn, etc. to Airtable. Appreciate any help.

Hello, I don’t understand why the calculated form is not released in Airtable. It is super easy needs a new data type that calculates only in form (HTML code) without connection on servers. Before submitting the form and don’t save anything, it will only be a visual element

Hi, I am making protocol app for EMS in NYC. I am using Glide to create the app. What I am trying to do is this: Protocol page lists all protocols → click on protocol → protocol detail page that lists steps for that protocol, IN ORDER *** (VERY IMPROTANT as our EMS protocols are algorithms to be followed in a specific order of operations) per level of provider. ** In my airtable base I made a Protocol table that has a linked field per provider level (ex CFR/EMT/Paramedic etc) these link back to the Interventions table which is a list of all interventions. When I add interventions to the records in the protocol table it maintains the order that I added them, however once I go to Glide, the inline list sorts them out of order even when I have “sort by sheet order” selected. If anyone knows how to troubleshoot this that would be HUGE. Is it a base organization issue? Glide issue? Both? I can’t seem to figure it out. Screenshots attached Thanks :slightly_smiling_face: K

Hello, we need to be able to print a single record to PDF or export a single item to CVS. It appears that if you export to CVS, it exports the whole table. I was told I could use a Form to populate the items in a single row, however, if this is the solution, I would like to know how to automatically populate this form with the items in the row and then print that form to PDF. Can anyone help? Thanks in advance!

I am a freelance consultant, and built a table for me to track billable client calls. I synced with my Google calendar. I would like for the “client” column to be updated automatically based on who is a participant in the call (i.e. if "Jim Jones is a participant, then update “Client” to Jim & Co.). How do I set up this automation?

Hello! I am embedding an Airtable database into a Webflow site. I would like the viewers of the Webflow site with the table to be able to filter the data. Will the filtering effect everyone’s view or just the local user? TIA - new to both Webflow and Airtable! :slightly_smiling_face:

Hello, Printing from Page Designer Layout is not working for me, it’s prepping but never getting to the system printing dialog box.

Hi! I was wondering how can we create a WEEKLY PAYROLL? The template available in Airtable is bi-weekly so I was wondering if it’s possible to build a weekly payroll.

I have a field where users can upload a video file. When I grab the URL to that video from the API and play it in Firefox, everything plays just fine. When I try to play it in Chrome, I get the following error: Refused to load media from 'https://url/to/my/video.mp4?’ because it violates the following Content Security Policy directive: “default-src ‘none’”. Note that ‘media-src’ was not explicitly set, so ‘default-src’ is used as a fallback. (url intentionally obfuscated)

Why is my JSON App not helping format my long-text JSON field? Notice how its all in one big long string? Why is it not formatted?

I deal with clients who regularly cross time zones and have deadlines in those different time zones. I want to show what time zone a date/time field is reporting as a reminder. They are so used to doing the offset calculations in their heads that the reminder would help. In other words, is there a non-convoluted way of finding the time zone of the device? The ‘ZZ’ of DATETIME_FORMAT will give me offset. That would be easy enough without daylight savings time. With it, I’m casting about for an easier way. Maybe using a GMT field in conjunction with a time zone specification field (a la ScottWorld’s thinking) is the way to go.

Hi Team, I am uploading a series of pictures from my iPhone to an attachment field. The files are too large so I used a tool called “Compress” on my iPhone to reduce their size. My phone confirms that the “compress” tool has worked and the files are much smaller. I then upload them from my phone to the attachment filed. When I try to email them they are way to big, again. So, I download them from the attachment field and check their size. They are almost as big as they were before the compression tool. I don’t understand why the files get uploaded at one size but somehow get larger. Please help! This process is integral to our business.

Hi, Say I have a base with 4 tables. A linked to B linked to C linked to D. If I want to visualise data in table D from table A I need to hoop trough table B and C with lookup fields to get this done? regards,