Other Questions

There were other posts related to the question. Like: WORKDAYAnd workaround is simple and well-known (WORKDAY(DATEADD(Date,-1,'days'),1))But isn't id a bug, that WORKDAY(StartDate,0) does not work?

I need to ensure no dates in my base land on a weekend or holiday. I’m trying to use the WORKDAY(startDate, numDays, [holidays]) formula to accomplish this. However… issues. I’m using “0” as numDays since I do not want to add any days if the date already lands on a working day. This does not move the date however if it lands on a weekend or holiday. If I change numDays to “1”, then the date automatically moves forward a day, regardless if the original date already lands on a weekday. How can I resolve this? Is there a “if weekday” formula that I can add in? See More

Hi everyone, I want to use the barcode to find the exact record, but somehow it keeps listing relevant records.My barcode formula is TX1, TX2...But when I look up the barcode for TX2, it also shows TX20, TX220Can it be fixed? Thanks in advance

I have a Jira Cloud instance with the typical Epic -> Story structure. I'm wanting to pull those epics into Airtable with a link to their associated issues and rollup their story point total. Example:DEV-1 (Epic) Make a sandwichDEV-2 (Story) Get Ingredentiants - 5ptsDEV-3 (Story) Assemble - 3ptsDEV-4 (Story) Eat - 1ptHow can I sync this data from Jira and assemble the proper links so I can reference DEV-1 and rollup the estimates to get 9 story points total? I've tried syncing my Jira tickets into its own table which has the Epic <-> Tickets reference information but am unable to convert that information into a 'hard link' that Airtable can use. See screenshot, if I edit the 'Epic Link' field to "Link to another record" it technically works but I get a message saying my Jira Sync won't update this field anymore. 

Hello. I've 6 tables, I've carefully counted the records (with no filters), it's 906, and Airtable indicates it's Off-limit. (only 5 records deleted in the past week)I've removed 32 records, My computed total is now 874, but Airtable indicates 983 (now inside limits !). All other bases are below 1000 recordsDo you have an idea of the difference (109 records) explanation ? (I need these 100 records !)I work in a non profit organisation giving information technology training, and showing Airtable experience for other bigger organisations with bigger budgets. We have only volunteers, impossible to buy a PRO Plan.Thank's for your help

Trying to figure the basics of Airtable. At this point i just want to populate a Single Select field in Table A with information in a field from Table B. Doable? Thank you for our time ~ Tom

We have a series of event registration forms listed on our web site, with URLs that prefill a particular field and hide it from the user. These links all broke today. Help!For example, this link (which is live on our site) stopped working today:https://airtable.com/appOQfoS4FjmyZPko/shr3lPQDrY1VTx0Ba?prefill_Events=STEM%20Helping%20Students%20Learn&hide_Events=trueBut removing the prefill_Events and hide_Events workarounds leaves us with a form that does:https://airtable.com/appOQfoS4FjmyZPko/shr3lPQDrY1VTx0BaAny ideas about why this stopped working today? We have been using this prefill URL syntax for months without an issue.

Does anyone know what the max field limit is for each table in each base? Thanks.

I am trying to get a specific folder ID from Google Drive through an Airtable script based on information from a newly created record. I think I am supposed to get access to my Google Drive by connecting to it via API. I’ve built and published a web app using Google Apps Script but I’m unclear how to connect the platforms together. What are the general steps to send data from Airtable to the web app so it can take that information, process it and send back a response to update a record?

Oh hello there! I am working with a team that is developing a base to capture competitor profiles. Within the base we have an organizational overview tab, contacts tab, program information tab, and a SWOT Analysis tab where we'd like to fill out the data on the competitors' strengths (from a drop down), weaknesses (from a drop down), opportunities (from a drop down), and threats (from a drop down) (among a few other things unnecessary to mention). What I'd like to do is have a matrix template that will pull in those selected drop down items and look something like the below for each organization/competitor. Would the matrix or page design extension be best for this? Might there be a better tool? I have some serious beef with the page design view and how limited it is - or perhaps in my case, just not intuitive enough to be impactful. Any ideas would be incredibly welcome. Thank you!

Are there plans in the product roadmap to make the web clipper extension available for other browser than Chrome? If yes, then when ? I’m mostly interested in that being available in Firefox as I’m seriously considering to switch back from Chrome to Firefox. By the way, the web clipper tool is a great feature that helps users to quickly and conveniently add new records in a table in a comprehensive way. Thanks a lot for it ! Best regards, Younes

We create QR codes pretty frequently in our marketing collateral and it's not infrequent that we find out after something has been printed/distributed that we need to revise the URL it's point to for whatever reason.   I know there are a few services out there to generate a QR code. Is there a way to manage the associated URL though so if we need to redirect it at some point, we can?   

Hi, We’ve developped the Ubiqod platform to manage QR codes to interact with business processes. Here is a tutorial on how to use QR code to track working time in a Airtable base via Zapier. What do you think about a native integration between Ubiqod and Airtable? Would it be useful? Do not hesitate to give us your feedbacks!

Hello everyone,I am using AT for events.When I sell a ticket to my event it creates a record of the attendee.Afterwards I would like attendees to be able to fill a form with further details about their profile (eg. dietary restrictions) and whatever they fill gets updated in the same record.Currently I have 2 options:1. Attendee select their email from the form (lookup formula) so it stays in the same record but I don't want all attendees to have access to everyone's email2. I can use a 3rd party like Fillout form that creates a link but currently it is very glitchy.Are there any other options without using a third party?Thanks in advanced!

How can I search globally in all tables ? No the existing search app doesnt work. See the image below. it only search in the records in current base not globally. Please guide me whats the possible solution to this. Screen Shot 2020-09-17 at 10.53.07 AM

Hello! I’ve just come across Airtable and was experimenting with it as an alternative to Google Sheets. My question is, if my application requires multiple databases, can string searches be performed across them? Thanks, B

Hi, I was wondering how does the 10 login badge work? Or is this effectively broken?

Hi everybody,How would you go about sending an image from an Airtable attachment field to an image field in a Webflow collection item.I have set up a scenario in Make using a webhook. Works great so far for all the text based fields, checkboxes, etc.But I can not figure out, how to pass on the required image URL, so I can map it in Make.Does anyone here have make scenarios with images running?Thank you for your help!

Hoping someone can help me.  I'm sorry if this is not in the correct section.  I'm new to this and not sure of what to call most things.   I'm a crafter and i'm trying to use Airtable to keep an inventory of my craft supplies.  I have imported data from a different system, and have titled the column that contains the URLs for the photos  as "Image" and defined it as URL.  However, i can't get the images to populate.  I wrote an email to airtable asking for help, and although i keep replying to emails saying they're busy, with i want to wait, it's been well over a month and i still don't have a response.  I have tried looking up on the internet in various places, and have found issues the same as mine.  However, the fixes they show apparently are from a different version of airtable than is currently available, as many of the screens they show have different options from what I see, and i have not been able to equate the old to the new t

Hi,Please allow users to download all attachment files in one click. We should not have to manually download every file individually.Thank you!Kerry

Hi all I’m curious to know if there is a way to use single select tool in web forms pulling from data from the grid indicating that a selection has already made. For example, if 10 people are signing up for 10 potluck dishes and one person has already signed up, the potluck options are reduced to nine in the forms. I guess this is considered conditional but not sure how it would work. Thanks

Hi,Not sure if title accurately matches my question. I have 2 tables linked by "Part Code":Table 1: Parts. Columns: Part CodeTable 2: Offers. Columns: Supplier Name, Part Code, PriceIn Table 1 I would like to add columns that automatically select the lowest Offer per Part Code. So Table 1 would have e.g. columns Part Code, Cheapest Supplier, Cheapest Price. Latter 2 automatically filled.Is this possible, if so, how? Any help appreciated!

Hello, Airtable community! I'm working on setting up a career path assessment tool within Airtable, designed to evaluate and suggest personalized career paths based on user responses. My aim is to have everything contained within Airtable, from data collection to scoring and recommendations. Objective:The goal of this tool is to automatically calculate scores based on assessment responses and use these scores to suggest appropriate career paths. This involves creating a streamlined and efficient form directly in Airtable for data entry.Current Setup:- Tables: I have tables set up for Questions, Responses, Roles, Skills, and Traits.- Form Creation: I am trying to create a form view in my Responses table to collect user inputs directly within Airtable. Issue:I am encountering difficulties in creating and configuring the form view:- Form Fields: Some of the fields do not appear as expected in the form view.- Field Ordering: Struggling with ordering the fields correctly according

Dear Community,I am writing to report an issue that I have encountered with the automatic upload of images to Airtable, which subsequently causes errors when attempting to upload these images to WordPress via an automated workflow. Here is a detailed account of the observations and steps taken to diagnose and troubleshoot the issue:Overview of the Issue:I have implemented an automated workflow using Make.com to generate images using OpenAI's DALL-E, store these images in Airtable, and then upload the images from Airtable to WordPress. However, I am encountering a persistent error when attempting to upload the images from Airtable to WordPress. The error message received is:```[500] Sorry, this file type is not permitted for security reasons. (error code: rest_upload_unknown_error)```Detailed Observations:1. Image Generation and Initial Upload:- Images are generated using OpenAI's DALL-E and are saved in PNG format.- These images are automatically uploaded to Airtable in an attachment f

I have a single line text field as a primary key “name” field. if it is blank when I save the record, I would like to automatically fill in the name as a concatenation of three other fields that are in the record. How can I do this?