Other Questions

2 fields, both are integer A = 35000 B = 86400 Formula A/B giving result 0 where it should be 0.40 How can I achieve result ?

Hey there, I am faced with a seemingly simple problem that I’m loosing far too much hair over. Bein in my late 30s, that’s something i really cannot afford any more and I am turning to the community to help here. Basically, I need assistance with a script that generates product id’s for designs, based on the designer and a variant of that to regenerate those codes if necessary. Our setup is a base with a table with Designs and another table with Designers - the schema for the Product IDs is Designer ID-Design ID so if our Designer’s ID is 100 and the Designs in question has the ID 23 the Product Id would be 100-23 Our backend / shop software (magento, nightmare) requires these codes to be sequential and doesn’t like gaps, so if the designs 100-23 was removed during production, we’d need to regenerate all product id’s that follow the 23, as simply omitting the design is not an option. This is where the script comes in. The starting point is the code here Calculate record number in parti

I have imported a small project schedule prepared by Excel, which as PiC field. After I imported it to AirTable, the Collaborator Filed in AirTable could not detect the PiC Field. So I end up to add assign task one by one. Is there a faster way to do this? say copy and past even by column?

I have a table of Researchers and a table of Projects. In the Projects table, I assign researchers to projects by adding them as linked records. Often, multiple researchers are assigned to the same project. When multiple researchers are assigned to the same project (i.e. multiple records linked to the project), I’d like to automatically create new records in a separate table specifically for each researcher assigned to the project, so that I can send them emails and manage their assignments individually. For example, in the case of the records in this screenshot, I’d like to automatically create a new record for “Project 1_Tori Klein (test)” and “Project 1_Test Researcher.” Any ideas for how I can do this? Thank you for your help!

Hi All! I am struggling on how to create a cleaning checklist for a client in a very large home. It was suggested I try to use Page Design, which should work. But where I am struggling is how to decide which areas should go into which blocks. Anyone have any advice? I attached a photo of how my table looks now for reference.

Hi there! Recently, I logged into my database and all the apps I’d built for a particular table had disappeared. Instead of seeing the usual dashboard with my apps, I now see the “Install an App” option. Has anyone else had their apps disappear without a trace? Some details of this situation if it helps: I definitely tried logging out and back in. My colleagues logged in and they also don’t see the apps. I checked the trash and it doesn’t look like anyone deleted anything. My colleague was able to restore an older version that still had the apps. I’d like to either figure out where the apps went or copy over the apps from the older version. Is it possible to do either of those things? Thanks in advance for any ideas!

So I am new to airtable. I created a table with the fields I want. How do I create a form for people to fill out and then their info will be added to my table?

I’m putting images in an iFrame for use on an artist’s web site. We have large images here at Airtable for our own use. They’re not huge but I’d like to limit the files that visitors to can download. But visitors are looking at an iFrame into Airtable data. Is there way to prevent download of large images yet still have them here in airtable?

I add a the field Record URL to the body of an email (Automation task) The email is sent to a collaborator When the collaborator clicks on the link they get a blank page I have shared the workspace and base with the collaborator. How do I resolve this issue?

I created a team contact sheet and want to send each person their line to update. Is there a way to: 1. share info in just that one particular line with a non-air table user and have them be able to update the information via a form? 2. Email other the form within Airtable without having to copy a link and then embed it in an email?

Hey all, first time post here. I’m assembling an org chart from a template. I’m assembling a structure where some solo people report to the CEO and others to their department heads. Is there a way to move the solo people to the bottom level since they are not considered department leads, even though they report to the top level CEO?

We are experimenting with using AirTable to create a marketing editorial calendar, but are stuck because of the inability to see enough information on a per-record basis in the calendar view. Is there a way to expand the record size to show 2 lines? Or have it display a custom field rather than the ID field for the record?

Hi all, I recently started some using Formnano forms to update records in my table, but found this morning that the entire Formnano site seems to be down, with form links not working and I can’t find a way to contact them. (Getting a proxy/firewall error message on all) Does anyone know anything about this or how to get in touch with Formnano?

Hi everybody! So I’ve created a simple donor database. The first tab lists monetary donations. The second one details individual donors. I want to set up a simple form for my employees to enter contributions but since the “individual donor” field in the the “monetary donation” tab links to the second “individual donor” tab, it doesn’t let my employees enter new donors in the form (they can only select from existing donors). Maybe it’s something simple I’m missing but can anybody help me set it up so new donors can also be entered through the “monetary donations” form? Thanks in advance! Bethany

I am an independent developer exploring Airtable Apps ecosystem recently. I’ve been using Airtable for some of my clients, so I’m quite familiar with it and its automation via Zapier/Integromat/Scripting, etc. Question for you - What are some Airtable Apps you wish existed and would pay some fee for? Thanks! Sam

Am working on putting together a base for better tracking of inventory bought/sold on Amazon and other channels. Would like to be able to use a barcode field which when an item is scanned, it goes out and searches Amazon and comes back with the item’s title in another field and in another field it enters the item’s current ranking. Also, anyone familiar with using Airtable integrated with Woocommerce? Looking to have several niche websites for products sold in-house or dropshipped, and best ways to keep track of it all besides spreadsheets.

Anyone considered creating a custom app that is like the SendGrid app but uses a different mailer (eg mailgun)?

Hi all, looking for some ideas on how to link courses, with faculty member availability, producer availability, and room availability. For context: courses have various durations (90 mins, 3 hours, full day, multi day) schedule should not allow double booking of a faculty member nor a room Wondering if anyone has a template built for this type of thing.

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