Other Questions

I would like to create a Table to check the number of items in stock by date and time. ■Order └ Product Name (Link Table) └ Unit Date ■Production Product Name (LInk Table) └ Unit └Date At this time, the same Product name and Date are used in Order and Production. Is it possible to display items that have the same product name and date in different tables? Even just a link somewhere or a general idea would be very helpful. Order Production

I want to send an SMS reminder to staff to submit their lesson plans if they haven’t yet submitted it for that week. What formula can I use to look at the most recently submitted lesson plan for that teacher and if it was after a specific date then include/exclude from the sms reminder?

I have a table with ~5k records which I filter to show a subset of, then I create a PDF report of the filtered records including the images in the attachments field. This has been working perfectly until last night, when the images started to output as solid black boxes, but the preview of the PDF in the Apps sidebar was fine. Nothing has changed in my base, except that I hit the 20GB attachment limit which prompted a warning about the base exceeding limits and needing to be upgraded. I modified the structure to avoid this in the short term (but will need to upgrade to Enterprise ASAP anyway), reducing my total attachment storage to 16GB and removing the warning. But the problem with Page Designer still exists even though i’m now well within the limits of my Pro plan (50k records, 20GB attachments). Images attached with private content blurred.

I’m trying to make a column show different currencies. I’ve got a column for price and a column for € price and formula field that is controlled by a 'currency switch' which determines if the price in the formula field is shown in or €. My problem is I need to multiply the formula field with another field but it’s now a string as it has either a $ or a € attached to it. Is it possible to take and convert the numbers in the string back into a decimal?

I am using WPForms → Zapier → Airtable. The situation: In WPForms I have a Form to upload 1-5 Files (Pictures). With Zapier I pass the data from the form to Airtable. The Pictures seems to get into Airtable as a link. The field in Airtable which receives the Link is an Attachment so I get an Image in Airtable. Which is perfect. The Problem: I only get the first url as an image. I want all the urls as an image in the attachment field (up to 5) Any ideas?

We need customers to enter an address, typeform doesn’t have this and neither does airtable, using jotform which is poorly designed. Does anyone have a solution? I mean the maps block uses google api? Why can’t a field?

Is there a formula I can plug in to see their age (so I don’t have to calculate anything?)

Hi everyone! Im new here so thanks in advance! My problem is simple , I have listing manager with a full record of my clients | Name, last name, phone,webflow member ID, Photo of listing, price and etc… I Want to split it that I will have one table I can see all the listings with a record of who submits that Flat. I use it to make a “status” function to send the data to my webflow site. Please help me out here :slightly_smiling_face:

Hi, I’ve created a shareable Calendar link following the steps described here. Integrating Airtable with external calendar applications – Airtable Support However, in Google Calendar the generated events don’t have an end date. Most events in my Airtable last more than 1 day, so that’s a big problem for me. Anyone else had this problem?

I am currently Syncing a Calendar from Google Calendar. In the same base, I have a calendar view of upcoming projects. How can I see both calendars at the same time??

Hi - Thank you in advance for any support or help you can provide. I am not sure which side is the issue but I have filed the very same question on Dropbox Support to see if we can get an answer. I have connected my AirTable Base to my Dropbox to be able to link from my ONLY Drop box account. When I go into my Attachment field -and Select Dropbox - I am only shown two Dropbox folders (I have many folders synced and stored in Dropbox. - I am not seeing all my folders. I have a DropboxPlus with extra storage. I have a Airtable Pro 1 collaborator (aka me) plan. We know that the two folders that are showing are - folders in the cloud only that have been stored up in Airtable but not on my computer. Non of my computer folders are showing when I select Dropbox in Attachment field. The Airtable and Dropbox system both acknowledge they are indeed connected. Any help is greatly appreciated because honestly - that is why I have Dropbox is for my

Hello all! Really glad I discovered Airtable! I was experimenting with the filters tonight, and noticed that it doesn’t look like I can combine “And” searches with “Or” searches. Am I over looking something obvious, or is there another way around this? Example: I have a list of job descriptions, and my client sometimes uses abbreviations. So I want to search for: 20oz AND GT OR GREEN TEA Thanks!

Working with the Airtable Python Wrapper to batch insert records that have multiple field types, including “select” fields. even when Typecast is enabled, I get the below error: Unprocessable Entity for url: https://api.airtable.com/v0/appPdjdf8ska/rtt (Decoded URL) [Error: {‘type’: ‘INVALID_MULTIPLE_CHOICE_OPTIONS’, ‘message’: ‘Insufficient permissions to create new select option ““ja””’}] The code below works when all fields are text fields, so i’m not sure what I need to change? airtable_conn.batch_insert(data, typecast=True)

… this is my first time with online database work. I am have a table listing the 50 States, with each having a unique URL field in the record. On a web page, I want to display a drop list of the 50 States. The web visitor will select one State from the list which will then will display the unique URL to the visitor. This is web page has the function I want to use on my site. https://www.needtechs.com/techs_search.php Anyone know of a guide that will help me figure out how to do the view and or filter to accomplish this? Thanks in Advance.

For hours all I can see is a message that the table is loading. How do I fix this?

Hello, I’m using Integromat to look at the Airtable Record Last Modified Time Field as the trigger, then it goes to GMAPS and gets some mileages and comes back and updates the record. Does anyone know how to keep it from recalculating all the mileages and updating all the records, only the ones that have been modified? I have the scenario set to 'Choose Where To Start ’ “From Now On” Its running up a lot of “Operations” in Integromat. Thanks!

Hi guys! So, I’m trying to do something that feels WAY more complicated than it should be. I have a view which groups records by week, then by type, then by status, and we use this as a dashboard to measure activity. However, we’d like a static report every Monday that summarises the counts in each of these dropdowns, otherwise we’ll need to manually ensure we check it every week and scrape the data on a Monday. I’ve tried roll-ups and count fields, but the way the base is set up means having a linked field just for this adds an otherwise redundant step into our users’ day. Even just the ability to do a rollup of things tagged as “content type x” within the last week would be better than nothing, but it’s seemingly not possible. It’s a long-term bug-bear of mine that it’s so weirdly hard to get record counts out of Airtable in an easy way, so any help would be appreciated. Thanks, Josie

I have a base where I track several daily routines to try to gamify the forming of new habits. Each row is a bunch of checkboxes and a date. Is there some way to count streaks like this? How many days in a row have I managed not to smoke for example :smoking:

Hi, We have a base that lists our staff calendar and we have approx 20 employees. When we duplicate the data for the next week, it is very cumbersome to keep the hours the same but change the date for each employee as they all work different hours. Is there a way that we can duplicate a previous working week and get the new dates populated in a more efficient manner?

Hi, How can I hide data in column for collaborators with editors role? For example, my table have columns A, B, C, D I want that editors can view and edit A, B,C columns But column D will be hide for them And only I as a creator can view and edit data in column D

Hey Airtable Community! For the past few weeks I’ve been trying to design the following process: A user submits a form entry. Depending on whether the user indicates if they’ve submitted an entry before and whether they want their entry used for a specific project, a formula field will produce a certain text string. 3.That formula field is added in curly brackets to a SendGrid HTML template, so that the appropriate text swaps in to each individual email, rather than me needing several different templates. This all works fine. I started running into trouble when I then tried to add hypertext. I thought I could get away with this by putting it directly in my formula (this is an example version): IF({Adaptation Switch}="Yes", "Text 1","Text two, and visit us <a href=\\"https://www.airtable.com\\">here</a>!") Of course, the slashes are there so that the quotations for the hypertext HTML don’t mess wi

I want to upload the photos I took to Airtable. How should I do that? thanks！

Hello, is it possible to periodically export our data from Moonclerk to Airtable? if there is a way, I would love to know.

Hi community, I have a Base for customers that is shared by several other bases using the Synced Table feature. Is it possible for linked records to be shown in the original table, as they are with the synced table? Example: I have a table of contracts with a linked customers field. I can see all of the contracts for a given customer when I open the synced customer entry, but it doesn’t show up in the original customers Base Thanks everyone!

Hi there! I am trying to devise a way to send an email with a recap of our sold inventory from the past week using Zapier. The Zap will be triggered upon a new record in a view. (Our sales manager will Audit the list from the past week, then use a checkbox to say it’s ready to go). Obviously, the number of units sold will change week to week, so I can’t use a static HTML table in my email. Ultimately, I’d love to end up with the same design I have in Page Designer - see below screenshot. (side note: I will be ecstatic on the day that Page Designer/other blocks integrate with Zapier - it would solve SO MANY of my problems if I could attach a page from Page Designer as a PDF to an email or to a record). Any ideas as to what sort of action steps I need to use before I build my email template? Thanks so much!