Other Questions

Hi! I’m trying to figure out how to ‘get’ the url of the page my form is on. I’m deploying an embedded airtable form into hundreds of articles (We run a news site). I can not manually put the url in. Most forms will tell you ‘where’ a user filled it out… is there an easy extension/way to get the url and submit it into a ‘single select’ or short text field?

So I have the following tables:Teachers (can have many students)Students (have only have teacher for each student)I'd like to create a form where if I choose a teacher (or multiple teachers), it shows only their relevant students in a dropdown.Is this possible?

Hi First I have a table with a linked column that returns unique values (allowing multiple records = FALSE). Note the actual source column is a formula. Second I want to build a kanban view over those linked unique values but the option doesnt show. What am I missing?

I'm trying to display an airtable in a wordpress.com site.Wordpress.com does not display iframe. Is is possible to get an alternative type of embed code? Many thanks

I have seen posts dating back to 2016 asking for the ability to lock (protect) data at the field level, but I do not see that this issue has been resolved. Not being able to protect critical data is a serious concern for me in our organization. It is far too easy for someone to overwrite a record - with no warning whatsoever - and the user might not even notice that they did so. I would love to see the ability to lock a field once the data has been retrieved for use in other systems, or to lock a record entirely once all info has been collected. Using separate views to achieve this is not practical, but looks to be the only way to accomplish this. Please tell me I’m wrong and that there is a workaround for this. Thank you.

We use a long text, rich format, field for explanation purposes however even with the height set at Extra Tall a lot of text is still out of view. Is there a way to increase the height for certain rows or a way to inform users letting them know to expand the record to read more? Not all fields require the expanded height and we really want to avoid spreading the fields so far, as it becomes harder to read all other fields.

I'm working on a script that will move records (and its child records) from one base to another. It's mostly working but one issue I'm running into is figuring out the table information of a linked record. For instance, I have two tables: Companies and Users. A User belongs to a Company. If I wanted to move User 1, all the information and Company 1 with all its information, I need to know table information for both so I can grab the fields for each table and create the new records.So when I have a User.company, I'm given all the field information but nothing about the table. Is there an easy way to look the table info up? I was hoping tableId was attached to the field or some identifier that shows which table this field is to but I don't see it. Since I can rename a linked field name, I can't use the field name to search for the table. For instance, I can rename the Company field to Organization in the User table so searching for an "Organization" table wouldn't help. Any suggesti

I'm very new to scripting and my javascript knowledge from college is a very distant memory, so bear with me. I'm trying to create a script that will essentially generate a mini-form with three fields from my table that will create a new record when filled out.I've been successful to a point but running into some issues. Code is below. Here are my questions:Is my syntax correct to create one new record with multiple fields filled through user input?How do I ensure the user input can be validated as a number for a currency column? My parseFloat() function is still causing errors (scripting block says it cannot create a record because it needs to be a number).Both Payment Month and Payment Year are requiring objects, which I assume has to do with the fact that both fields are single select. This is important because I have functions and automations dependent on those being entered the same way every time. How can I alter my code to satisfy that requirement?Thanks for any help! // pi

Hi everyone,The question may be simple or have an obvious solution, but I am struggling with this and can't solve it. Here goes:I need help in assigning values (in €) to different companies in different projects. Let's say this is kind of a portfolio approach to a company's project.On sheet 1: I have a Project List with a lookup column to a partner list (on sheet 2).On sheet 2: I have a Partner List with indication on which projects they are participating.I would like to assign, on sheet 1, an indication of each partners assigned project value (€), and have that reflected (separately and total value) on sheet 2.One project can have multiple partners, and the same partner can be in several projects. Do you have a solution for this? Or is there a formula for this?Thanks in advance,J.

We are experiencing more than one repetition problem for the mail automations we run. In the automation we have set up, we send an informative e-mail when the number of weeks the person works is updated, but we have a problem that it sends the same e-mail 10 times in a short period of time. 

Hi - I'm new to AirTable so I may have missed something, but if I duplicate an existing record (say a "Plate" in Product Database), change the name to "Cup" & other data to I end up w/ 2 records "Cup" & "Plate" in the table - as expected.  However in other tables where "Plate" was included as a linked record, I also now show both records in linked field in these tables. How can I prevent this behavior?

I've created a timeline view. It's nearly what I need but the labels of my records disappear when I use longer timescales. Is there a way to have the label appear above/below so that I can still see them when zoomed out?

Hi everyone! We are having some troubles to submit our extension. We are having this error message when try ‘block submit’: Packaging… Incomplete Error: Dependencies cannot be on multiple disks. Code: submitCommandWindowsMultipleDisks Any hint or solution there? Thanks in advance

Hi all, I’m struggling with sharing a view of a gantt chart we’ve created, the shared link returns “Start date field is hidden or invalid” however I can’t se any error with this field. Gantt view in base Base start and end fields Error message Any on advice on where I’ve gone wrong would be much appreciated

Is it possible to limit the amount of rows in a table view for use in a chart? E.g. I want to see my top 20 accounts based on sales value. However when I create a chart, based on sales value, I cannot limit the results to only the top 20.

When I right click on my extension frame and select print to pdf, the print preview window is blank, even if my extension just prints "hello".any help appreciated.I'm sure I could do this a while ago. I'm using the latest version of chrome.

Question as in the title 👆I've been doing a lot of work fixing structural errors, and the Manage Fields has been super helpful. However, I did notice it didn't update in real time.Not an urgent issue, just out of curiosity: does anyone know when it refreshes? 

The PDF view is broken and the generated PDF does not have full informationBroken PDF issue in this Airtable

Are there any scripts or extension that can help me do either or both of these:1. Instead of having the questions show up on the left have the full question show up on top of a Gallery View entry https://share.cleanshot.com/kJ6Xqd2. Present a more compact view of the Gallery information - e.g. a table view in Google Docs or even Google Sheets presents a lot more information in a more compact way https://share.cleanshot.com/cJCUtk

How can I search for duplicates across a whole base, not just within one table? Thanks!

I’m a new user in the wonderful world of Airtable but can’t find a way to further implement my chart blocks. Can they be used on page designer? Is there a report generator feature I’m missing? Any download options? Ideally I’d like to generate a report (to download or print) displaying my charts and other organized data from a grid. Thanks!

From a look-up field array, I’m extracting a duration h:mm, which I’m trying to convert to a duration field. The time comes out alright in a human readable format, e.g. 2:59, 4:24, 6:00, but I’m struggling to convert the string into a duration formatted field via formula. I tried using a few formula IF(Time,DATETIME_FORMAT(DATEADD(TODAY(),Time&“”,‘s’),‘H:mm’)) = always 0:00. IF(Time,DATETIME_FORMAT(DATETIME_PARSE({Time},‘H:mm’),‘H:mm’)) = still no formatting

Hi there, I’m working with airtable on some amazing bases, where I’m creating several pivots and charts for with the apps. However, I cannot seem to find a way to be able to export these. Is this something that is expected for the product? Otherwise I’m not able to share the dashboards I’m creating in e.g. reports to share internally and externally. Thanks, Maeglin

Hi, I want to do a bar chart for every record using the three columns Ventes. For example, bar 1: Ventes 2019, bar 2: Ventes 2020, bar 3: Ventes 2021 Is it possible? I am joining an example for 1 record, I have 150 records in that view. Thank you

Is there a way to make a graph with multiple sources of data. E.g. two y values (same data type). Seems like it should be easy! Many thanks