Other Questions

Hello, I'm looking for a way to add multiple linked records.Exemple : in the main table, I have a list of photo studios. For each photo studio, I want to save the number and type of electric power sockets available for each photo studio.In another table, I have all the types of sockets. I want to add as much link between a studio and a type of socket as the number of sockets present.Once I link a studio to a socket, this stocket disappears and I cannot link it "twice" or more depending on the number of sockets.Which solution would you suggest in this kind of situation?Basically, I'm looking for a way to store the information "This studio" owns "This Number" of "This Type of Sockets", and "This Other Number" of "This Other Type of Sockets".

Hello,I'm learning to run scripts and have been able to successfully write a couple of scripts for my work as a coach. I already know how to ask for the number of sessions (eg. ¿how many sessions?: 3) and then automatically create 4 records that are as follows: KickOff, Coaching1, Coaching2 and Coaching3. My difficulty is in how can I automatically create dependencies with linked records to the same table. So for example: Coaching1 has KickOff as predecesor, Coaching2 has Coaching1 as predecesor, Coaching3 has Coaching2 as predecesor.Attached you can see a simplified table... The script I have up to now is://Create Table Variablelet TableCreateDependencies = base.getTable('CreateDependencies')//Ask for Number of Sessionslet NumberOfSessions = await input.textAsync('¿How many sessions for this process?');//Create KickOfflet CreateRegister = await TableCreateDependencies.createRecordsAsync([{fields:{"Activity": "KickOff",}}])//Create Selected Number of Sessionsfor (let step=1;

When choosing a "Date" column, it only lets me add a specific DAY and time... but what if I ONLY want to add the year. Or a month and year. Is that possible?

Importing into a table (CSV, Excel, Pasted, etc.) with linked records will not allow mapping to linked records. The exact same data can be pasted into the GridView of the table and Airtable will expand the table to include the record count of the pasted data and correctly add the records to the table. The values for the linked records exist as would be expected by the paste into the GridView working properly. I am I doing something wrong? Thanks, Don

I’m creating a workflow to help with video production and scheduling. Is there a way to give feedback immediately when someone is filling out a date box on a form that will block that date from being submitted if another submission is already set for that date? For example, the client puts in a production date of January 1st. But a previous submission is already booked for that day, so their form will get feedback that date is already in use and another will have to be selected.

Hello! I have a base with ingredients, recipes, and meals. I’ve seen similar bases but none that ask this specific question. Airtable Ingredients Example - Airtable Explore the "Ingredients Example" base on Airtable. Meals reference recipes, and recipes reference ingredients. The meals table has a lookup to list all ingredients for the given meal based on the listed recipes for that meal. How do I get the number of times each ingredient has been used based on the meals table?

Hello! I‘m currently struggle with one problem. I want to make a system that allows a user to see recipes and calculate their costs. In a conventional database it’s pretty straightforward: you need a Recipes table used to present all know recipes and let user choose one than Ingredients table with actual costs of the ingredients and IngredientsInRecipes table telling us how much of each ingredient is in each recipe. Than we do SELECT from IngredientsInRecipes JOIN with Ingredients and have all costs for a given recipe at our disposal. It should be easy but I can’t do it in Airtable at the moment. Linked tables work in a peculiar way here and it seems there is no way to get a separate table including amounts of ingredients from one table and prices from another. Can you give me some advice?

I guess I have deleted a base, but I do not remember when I deleted it.Actually, I am not even sure I indeed deleted it.Can I see deleted bases and undelete them?

Hi, We have a Form that we are filling out and i would like to be able to refer to an instruction document for more detail. Can i add a pdf attachment or directory link to the document which will be there every time the form is opened? Cheers

I have the pro version of Adobe for availability to fill and sign documents. (Pro Version for Airtable too) However, the program only allows me to email the document to a person needing to sign. Is there an easy way to upload fillable/signature documents in Airtable? We have a shared table that has all forms employees need to complete and most of them use their phones and are not able to complete or sign these forms. It’s becoming to be more painful than helpful.

Hi everyone, We have an interesting use case for our company. I am almost 100% certain that what I want to do is impossible to achieve with JotForm, Airtable Forms, Softr Forms and miniExtensions forms. I have a record. The record’s fields are as so: Name, Selected Option (linked field), Type. I am trying to create a form where: a) Selected Option is filtered by the Type field (the selected option record has the same type field which I keep updated so the single select options match) b) The dropdown box in the selection field not only shows the name of the linked field but also an image associated with that linked field in airtable. An example of this would be: Record A Name: Wall Colour Type: Colour Selected Option table has a bunch of records like Blue, Red, Green, Rough Brick, Stainless Steel. It also has a type. I want the Selected Option linked field to only show Blue, Red or Green, since those linked records have the type Colour which matches. However the type may change to ‘Meta

i’m trying to connect a base from airtable to notion via make. i managed to do everything right but on notion, in a files & media property the file is loaded as an attachment and not as an actual file - i can’t figure out why and this way i can’t use that property as a cover in the gallery view. has anyone experienced something like this before? thanks!

Hello,Following the change of URL logic on Airtable, we encounter a problem. We use a database to create eBay listings. So we have a field for image URLs. We use these URLs at the last moment so no problem for the experimentation of this one. But the number of characters of the supplied URLs has increased enormously (about 230). And eBay has a character limit for images of 4000, so we can't add as many images as before. It's a big problem. We don't want to pay for a new third-party service to make URLs shorter yet. Is it a fatality or does someone have an idea to save us?Have a good day,Romain

Anyone using the Monte Carlo simulation method to calculate completion times of tasks and projects?

Hi everybody,I don't know why but either if I give an editor view to some colleagues, they cannot add fields, fill a form.The error is " cannot accept submissions because only some collaborators can create new records" The problem is that there are no restrictions to this tab and some people are editors.How can I do? Thank you so much

We would like to use Airtable to present information that people can browse online, but can’t copy to external text, so the ability to disable Copying is ideal. However, I haven’t been able to figure out if it’s possible to also disable the “Print view” feature. Users can copy the information by printing to PDF then copying the text from the PDF. Is there any way to change this?

Hello there!  New to AirTable.  On a small website  I have a small Contact Form that is populating data into my table inside of AirTable.  It's all working just fine in a local site (not live yet, but it works)  I only have a few fields, which are getting returned to am email notification automation, but the fields are all showing up in the email notification all squished together and look like this:    Pennyinfo@info.comI'm stuckmondayMy fields are:  Name, Email, Message, and BestDay   So, you can see that the info IS getting to me which is great but how can I get the fields to at least show on a different line in the email I receive?  It's too hard for me to read ;-)!I understand how to use markdown for the rest of the body of the email, but not understanding how to format the actual 'data' that is coming in to me via a contact form on my site after it lands in AirTable??   I tried putting the fields inside of curl

I'm in the free plan -- can I add another person to work on my projects with me? Thanks.

Hello,Our organization produces lots of content and I need a way to:1. Assign a pool of different writers their assignments and be able to use an interface to give feedback through the development and approval of each piece of content2. Every new assignment then needs to live in a main repository / master “base table” A few thoughts:1) I’m thinking the article assignments are entered in a separate table for the writers, yet the master base table should have insight into it as well.. Not sure how to proceed. : ) 2) in addition to me assigning topics to the writers, I also need the writer form to be able to accept pitches from writers so they will need the ability to enter in content into the form as well.  3) And then when the writers click “status” = “submitted” can Airtable then send me an email notification?Any guidance or examples would be appreciated!thank you!

Hey all,I have a workspace for my business & all staff are logged in under their company emails. Could someone still setup a new login & transfer a base out to their personal login somehow? Does not appear to be able to, but need to be sureI know the security is lacking with Airtable on this front & need to protect IP.

Hi This has worked for me for over 18 months and now it fails. The code is within an automation script block. The code window shows a strikethrough line in “selectRecordsAsync” and the tip suggests this method is deprecated. Any ideas why and what alternative I have please? let mgl_allocationsBase = base.getTable(“allocations”); const mgl_allocationsBaseRecords = await mgl_allocationsBase. selectRecordsAsync(); Thanks Claire

I’m trying to view an Airtable calendar on Outlook. FYI, we run an exchange server; I can access email and calendars via the desktop app (Microsoft Outlook for Mac v15.40) or OWA (Outlook Web App). I tried subscribing via this method: https://support.office.com/en-us/article/import-or-subscribe-to-a-calendar-in-outlook-com-cff1429c-5af6-41ec-a5b4-74f2c278e98c It produces no results (the calendar is empty). I’ve tested the same link in Google Calendars and Apple Calendar, and it works without issue. I’ve tested other calendar subscriptions in Exchange, and they all seem to work properly. Has anyone else experienced this issue?

Hi, I’m wanting to know if its possible to have a single extension access multiple bases concurrently? My situation involves analyzing more than 50k records at a time and generating a graph based on those records. I will have 15+ bases and each are identical in structure. Each base has 50k records (pro plan). General structure of those bases is listed below (or you can see the base directly). The bases I am sharing just show a few rows (not 50k) to make this problem easier to review. I know a synced table is what would generally allow you to sync multiple bases into 1. I’ve confirmed if I do that I can achieve the desired graphs/extensions in a single base (provided the record limit is not exceeded). But even with a pro plan I am limited to 50k records for the base, even if those records are synced. So this is not feasible. Is there an alternative way that would work better? Right now I am considering using a local database to host and store my raw data. And then I would use Airtable t

Hello everybody,After using the new community UI for some time, a couple of questions/suggestions have come.Is it reasonable to use such a large font in a blue stripe? What is the purpose? When I'm writing a new post it says New Message, covering a fourth of the screen.That's how much space a header takes At the same time editor area is tiny and is not expandable when you are in reply mode (at least in Chrome browser) Earlier I could stay signed in forever, however now I need to sign in at least daily.Sorry to sound too rude, but these things reduce my enthusiasm to bring something useful to the community. Does anybody agree or it is just my problem?

Hello Guys, Thanks for reading this and taking the time to help me out :slightly_smiling_face: I’am trying to customize my project management table and more precisely to implement a budget line. Thing is that the budget is not a fix number but a range. When i try to use the currency or the number field i’am stuck with only one possible number. Could you help me to fix this ? Cheers