Other Questions

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,

Pivot Table app could be so useful - but it is just half cocked and really needs updating by Airtable. Can’t export / share. Only way seems to be either a screen shot or export to Excel Can’t change the widths of columns. It’s exactly what I need for several tasks, but without either of the above features it’s pretty useless. I don’t think it’s even possible to create an automation to export to a CSV or anything?? Please give us an answer Airtable

hi! i have a field that is linked to another table, and that field is a date. I’m trying to sort chronologically, but from what i see, it can only be sorted alphabetically. is there a way to change the settings of the date to yyyy-mm-dd in numbers instead of mm-yyyy now so i can sort chronologically? or any way to do that? thanks!

The article The primary field – Airtable Support doesn’t explain why rich text formatting should be blocked. Is there any reason to do so? For security?

Hi! I’ve been playing for quite some time now and just can’t get a result. I want to use Airtable as an inventory management tool. In a table orders are automatically imported via the store. One row is automatically created per order. There I get the product with SKU and the associated size. My problem is that the SKU is the same for all sizes: Product A Size 11 (SKU: 123456) Product A Size 12 (SKU: 123456) In a second table I have created the products and entered the stock level. Now I want the stock level to change automatically as soon as an order is received. Maybe you can help me? Thanks

Hi everyone! We’ve been working on a tool I wanted to share with the community. After months of private beta, we’re publicly launching our Airtable x Webflow sync at Whalesync! It lets you sync your Airtable data to your Webflow CMS instantly . The problem Airtable is the best place to manage your data. Webflow is an awesome frontend website builder. The combo allows for really powerful creations, but connecting the two is hard. Trying to do this with automation tools like Integromat can be complicated and brittle… especially when it comes to things like linked records. The solution A super simple (but powerful) way to sync data from your Airtable base to your Webflow CMS. You just map the collections/fields you want to connect and Whalesync creates a real-time sync. We support the major field types out of the box including linked records and rich text fields. How we’re different :zap: we sync in real-time :keyboard: we offer 1:1 support via Slack/calls :rocket: we’re a grow

I have a script that takes a small amount of time to run. While it runs, I want to use the full width of view I am on, so I close the app slide out. That also stops my script. Is there a way to configure this from not happening? I would like the script to continue running while I get other work done.

I am making a GET request to an airtable collection (the data has the form of a list of jsons). I am trying to add a filter according to the documentation but because my data is not relational but json-like, I can’t access the fields inside the records. With an example: The simple GET output: { "results": [ { "id": "12345", "date": "2022-04-14T05:14:16.000Z", "info": { "username": "random1" }, { "id": "123456", "date": "2022-04-13T15:14:16.000Z", "info": { "username": "random2" }] } I would like to filter the date and/or usernames, doing something like: https://api.airtable.com/v0/myBase/myTable?filterByFormula={results}{date}>“2022-04-13” Thanks!