Other Questions

Hi everyone, Goal: I want to match Companies to matching Talents based on different criteria (multiple). What I did so far Set up a base with two tables. Table 1: Companies, containing Fields “Name”; “NecEducation” (necessary level of education); “Rel.postal.codes” (all postal codes within a 40 mile radius as proximity of talents to company is key in my example) Table 2: Talents, containing Fields “Name”; “Education” (same choices as in field “NecEducation”) and “PostalCode” (just one value, referring to the postal code the talent lives in). Now I would like for there to be a field next to each company, displaying links to each Talent that matches the necessary education and who´s postal code is within the “Rel.postal.codes” of the company. Using @Greg_F ´s method here Compare two Tables (VLOOKUP on Excel) - I was already able to map single postal codes to single postal codes (not the range though!!) I´m facing the following issues: How do I compute results based on multiple

I created a form in Airtable to collect shirt sizes from our team for an upcoming order. I can’t find an option for putting the static image of the jacket within the form so people can see it when they are deciding the size they would like to order. Is it possible to have a form with a static image embedded into one of the questions? Thanks!

Hello! I am designing a booking system for a team of teachers. You can use the form to book a meeting (video call) with one of the teachers. My problem is that for a single teacher, I can do it, but for a group of teachers I can’t. If anyone can help me, I would be very grateful!

We use Airtable to manage our project opportunities and related workstreams. I’d like to introduce a bulletin board where all team members can see the latest news. Ideally a notepad of sorts, visible to everyone. Is there an app or similar I can in to achieve this?

Hello, I have a question about the webclipper. I would like to extract a table on a webpage as html. So when i configure the web clipper, i do not manage to ensure it will capture all the raw html code between elements. Any idea how this can be done? Thank you All!

Hi Guys I have this base which is very close to what I need to do: Ingredient Tracking Base I just have one last step and I have no clue. I need to get the number of batches made of a SKU, times this number by the amount of ingredient in the SKU, then take this number away from the amount in stock for that ingredient. I am desperate for some help.

Before getting into my lengthy question, please let me know if anyone is or knows of an expert airtable consultant that has programming experience, and is well versed in OCRing text based document and performing basic NLP & text mining queries on the documents… I’m Looking for some advice on pre-processing multiple images of unstructured text that will be OCRd (whether via Textract or Vision (or other, better option one may recommend))… In my use case there can be multiple thousands of images that are each a part of a separate document (which can be one or multiple pages). For example, one muse case may have 100 documents (each containing 10 pages each), with the entire set containing 1,000 individual pages. Typically the images of text are photographed and then provided to the user in jpeg, tiff, or pdf format. The sender typically receives the images ‘raw’ and the imager usually does not take the time to label files or combine them into singular pdfs containing the subject ima

Do you think Airtable can be used for advanced planning & scheduling for a manufacturing company? More specifically, there are several machines and work stations with manual labour wheareas some workflow steps are necessary and some are not depending on the sales order. I want to calculate the optimal order when the material has to be placed at a certain machine or work station to manufacture the product. It is a relatively low volume, but high variety production. We use Microsoft SQL Server/Navision which is the basis for our production data. There are scanners at each work station to track where the object to be produced is. Based on this, could Airtable be used to calculate the optimal order as described above and display when which object should be placed at a certain machine or work station? The calculation should consider the delivery deadline, capacity usage, production time and other factors.

Hi ! With Zapier or Airtable Automations, I can trigger a certain mail to be sent when a record is added in a view or met a condition. However with Sendgrid Block, that seems impossible, I’ve been testing different things for hours ! Any idea? Many thanks

I want to calculate a deadline that is 30 days prior an App Release date for daily content. But I also want a deadline that is 60 days after the App Release for project types that are not daily. The 1st step of my goal works correctly with this formula… DATEADD({App Release (from Master List)}, -30, ‘days’) Here is an IF statement attempt to include the 60 day delay for all other content that does not work. What am I doing wrong? IF ({Project Type (from Master List)} = “DAILY Meditation”), DATEADD({App Release (from Master List)}, -30, ‘days’), DATEADD({App Release (from Master List)}, +60, ‘days’)

Hi All, I am new to Airtable, was wondering if someone can help. i am struggling with trying to get a date to change 6 weeks in advance every time I mark the task done. these are recurring tasks and they have to be completed every six weeks. is there any way I can do this. help will be much appreciated thank you in advance. Jay

Hi, i have an issue with a zap on zapier here is the message : "The app returned “You are not permitted to perform this operation because the field or table has been configured to limit who can perform this operation”. this is a message from Airtable. I’m the owner of my workspace, i’ve put permissions on “editors and up”, so i don’t understand how to fix the issue

I am trying to build an external web app through either Pory or Softr, but my API key seems to have stopped working (I keep getting an invalid key error). Does any one know how to fix this? I’d hate to delete my current API key (I currently have some forms live on my site through Mini Extensions and it would break that connection (although it would be relatively easy to re-do…just not sure deleting/re-generating would really solve this problem - there’s no reason it should have stopped working in the first place). Any ideas? Thanks in advance!

Hi All, Simple one but I’m a but stuck… so it’s ask questions time. As per above I’m trying to convert the simple 24 hr formatted column into JUST a h:mmA format. My formula is: DATETIME_PARSE({Confirmed Time - 24 Hr}, “h:mmA”) How do I stop it showing the date portion (11/19/2020) in my result? EDIT: Here are my full fields. Ultimately I’d love to create a single output that combines ‘Confirmed Meeting …’ with ‘Confirmed Time - h:mmA’ (eg November 19, 2020 at 2:00pm) that can be used in as a simple trigger in a Send Email automation on Airtable… I’m just getting my head and logic brain around Airtable though.

Hi Guys I need a hand. I’m building an ingredient inventory tracker (here) and I need to calculate the total amount each of each ingredient used every time the recipe is logged. I’ve got the other half of the tracker working fine, adding in ingredients every time an order is logged. Any insight would be greatly appreciated.

This is the formula i am using to manually override my default date entry IF({Date Override Entry} = BLANK(),{Default Mixed Date}, {Date Override Entry}) i attached a screen shot that shows the result that i am getting. It returns a result that is a day off and i am not sure i am not sure why. Thanks in advance any help it is much appreciated. :pray: Screen Shot 2020-11-21 at 11.57.57 AM|700x308

So I have a directory of creatives who have multiple creative passions. I used multiple select in order to help organize their creative interests like this: But when I go to view in groups, the groups that show up don’t filter by the individual option but by the groups of options that each cell has. Don’t know if that makes sense so I hope this picture helps Is there a way to group by individual options? Or another view I can use? This airtable is being embedded in Wordpress so my members could just search, but if there is an option would love to know. Thank you!

I’m looking to use the gallery view that I have for recipes for a foodblog on a page in my blog. But to format to hyperlink to the PageDesigner App perhaps so users could print the recipe or scroll through them. How can I best do this? I feel Airtable is amazing but this one tweak would make it awesome! If there is a template that can be used to hyperlink to my blog tha would be great to know about.

Hi, I am trying to patch a record using the primary field. How would I go about doing this? Use case: I create a record and assign the primary field as the object’s unique ID. A few minutes later I receive more information about this object and I want to add the information to the record. I do not have the airtable id that I received when I created the record, but I do have my unique ID for this object. How can I update this record using my unique ID for the object, without airtables underlying id?

Hi everyone! I’m new to Airtable and need some help with the Forms view. Providing some context below: Table 1: Contains IDs and names of specific users. Table 2: Contains data that is inserted via the Form View, with one of the questions being a Linked Field to Table 1’s ID. My questions are: Why does the form in edit/preview mode show all the other data in Table 1, but when you share the form it only shows the ID? Edit mode: Share mode: Is there a way for me to display the lookup field of the name of the user from Table 1 when their ID is selected? Since selecting IDs will start to get confusing after a while. Thanks in advance!

I am using AirTable to manage a vehicle database. The entire base is embedded within our company intranet page and is visible to Salespersons. We want Salespersons to be able to email a record (from a specific view) to a customer quickly and easily. On the full version of AirTable, I can right-click on a record and choose “Send Record” to email a nice summary of the record and photo attachments. When I embed the base, the ability to right-click is no longer available. Is there either a way to get this functionality back in an embedded base, or a way to simulate it? Thanks so much!

Our primary lead source comes from Canada Post neighborhood mailings. Right now we are sending about 300K flyers/month across 4 divisions but will be increasing to 450K plus come the new year. We have over 20 areas a week and multiple flyer types which we are looking for a more stable way to keep track of. I am wondering a couple of key things before I dive more heavily into mastering this myself. As we schedule new routes, is a recurring date scheduling function something that can be coded in? From what I have come across, this is not something I’ve seen others need to use, but for us it would be essential. Ideally as a mailing route is generated you could schedule it one of 3 ways. a: Say the route has 10,000 homes, and you want to send them out over 4 weeks on mondays starting X date, it splits up the routes (taking into account the varying number of homes) and generates a plan with an assigned flyer type. b: You want to send at least 2000 flyer per week starting on X date and the

I am trying to update a record’s attachments field. I am doing this successfully with curl, and also I have python code that successfully pulls records from the table; however when I add code to that which tries the PATCH, I get a “Could not parse request body” 422 response. Below is the code. Thanks! import requests import datetime import json auth_token=‘keyXXXXmJVG’ hed = {‘Authorization’: 'Bearer ’ + auth_token, ‘Content-Type’: ‘application/json’} url = ‘https://api.airtable.com/v0/applXXXXmLfek/Table%202/recthrgH5KVMEMglc’ print(“GET’ing records…”) # THIS REQUEST WORKS: response = requests.get(url, headers=hed) print(response.json()) r2 = { ‘fields’: { ‘mytext’: ‘success’}} print(“PATCH request…”) # THIS REQUEST FAILS WITH 'Could not parse request body’ presp = requests.patch(url, headers=hed, data=r2) print(presp.text, presp)

Hi, my colleague got this really weird problem. Starting this morning, when she tries to enter text in a Long Text field, it delete each letter after she types it. So she sees the letter for a second or two then it deletes itself. She’s been using this fields for months without any issues. Here’s what I tried so far. Close all her browsers and reboot the PC = Did not solve the problem I tried logging with her account from my PC = It worked!!! I created a Long Text field on another table without activating the rich text formatting = It worked for both of us!!! So it looks like when she tries to type anything in a long text field and activate the rich text formatting, it does not work anymore for my colleague. Beside removing the rich text formatting on the field, do you have another solution that I didn’t tried? Thanks Annie

Hello, Long time reader, first time commenter. Each year, my org has members re-enroll in our program. Ideally, they would be enter their name/ID and view all the relevant information within their record. My hope is to have this information populate a form, where they could then make updates where necessary. Does anyone have suggestions about how to do this within a Wordpress site? I have some basic facility with javascript, but that’s the extent of it. I imagine that the solution will involve the Airtable API, but I’m not sure where to begin. Thanks, Mike