Solved

Good morning everyone,In my company, I manage the content of all our Airtable bases. We’re on the Team plan, and the 10+ other members have Read-Only access.Interfaces : We provide multiple Read-Only interfaces to make the data easier to view.Scripting Extensions : We use scripting extensions that can manipulate table data (for example, to get the published versions history from one of our tools).Forms : I plan to add forms so team members can interact with some of our base content (for example, to submit development tickets).My questions :Interfaces : If I add an editable field in 1 of my interface to make the large text areas easier to manage, will Read-Only users be able to edit content ? If they do, will these actions incur charges ? Is the logic applicable if i make the entire interface editable ?Scripting extensions : Similarly, if a Read-Only member launches a script that appends changes to a table, will we incur extra charges ?Forms : If a member submits a form that adds conten

I know a few years ago it was not possible, but I'm curious to know if anything has changed. I have a long form that I'd like to split into multiple pages. Is this still impossible to do in Airtable? Is my only solution to use an external service like JotForm?

Hi Community, I would like to create a new record that is automatically linked to a parent record when I click "+ Add record" in the interface detail view of my parent record in Airtable Interface.To try to explain clearly, my database is comprised of two hierarchies in two different tables.Table 1 is "Communications" and contains the parent records.Table 2 is "Web Articles" and contains the child records that are linked to a "communication" record in table 1.When I am in the interface list view of the "communications" table, and click on the details of the "communication" record, I can see my linked web articles (see screenshot 1).The only way to add a new record from here is to create one with a form. If I then try to add a new record (+ Add article), it opens a form to create a new record in the child "web articles" table, but there does not seem to be any way to link this new record directly to the parent record through which I clicked "+add article" in the details view, even

Hi Everyone Does any one know of a formula that could deduce the Week Number in the Year from a given date field? Any help would be greatly appreciated. Stephen

Hello! I’m working on a series of budget interfaces for my team members in a university office, and I want them to be able to edit certain fields of their personal budget “dashboards” (not the Airtable Dashboard interface style, just the word they’re using) without editing all of the details...which would open us up to folks potentially messing up other important info by mistake.  Currently we have the dashboards viewable as grids, because they give us the option to have Sums at the bottom of each column, showing folks what their running balance is for each budget category. However, the only way I can seem to get the “edit this column” option is by using a List view, instead of a Grid, which doesn’t calculate the sum automatically. Is there a workaround for this folks have seen? Essentially, I want them to be able to edit some-not-all of the records’ fields, and I want an automatically calculated sum at the bottom of the grid/list/etc. Ideas? (The two images below illustrate what we’ve

 HiI have this form https://airtable.com/app6DqS2bqGtz03sG/shrBpcNzpZdK8T6rW When anyone tries to login to complete the form they getting the above message. How do I fix this Many thanks

Good day everyone! I want your feedback on how to complete this. I have a table of ‘Projects’ listed and includes a linked field where I select multiple records that represent rooms of a house. This is what I want to do: once I select multiple rooms of the house, I want to auto-create a list for that particular project that includes default furniture and accessory pieces for each associated room of the house. That way, I’m not having to manually write it for each project that comes up. It may be easier for me to create an excel document to include the most common rooms with associated furniture and décor pieces. What are your thoughts? If it’s possible to complete, do you have any recommendations on how to make it happen? Thank you!

I run my market garden business on airtable. The market price for my vegetables change monthly or seasonly. At the moment I use a formula field to calculate the return on my production each month . I have a table for each vegetable price but when my prices change how do I stop the new price altering all my previous months. Do I need to use a script?

Hi, I created my first form today and liking the tools, however i find the linear scrolling required to access a multi-field form a bit long winded… Can i modify the layout and locate fields where i need to, to make the form more compact and intuitively laid out, and potentially all fields on a single screen/page? I looked at a thread from 2020, and it mentioned JotForm using Zapier ? Has there been any changes since then to Form layouts for Airtbale? Thanks You, Simon.

Hi all,This has been asked before, but the previous topic didn't get any replies:  We’re encountering the same issue: the record revision history looks different when viewed from the Data side versus the Interface side. Is this a bug, or is there an underlying logic we might be missing? DataInterface 

Hi, I’m trying to follow the extension first tutorial and I have an issue when I load the “http://localhost:9000” website : “Cannot GET /”. Any idea for this issue? Best,

Hey,I have a “project management” table where I keep all my projects, with a lot of different linked records.When I change the status of a project to “send invoice” I have an automation that sends an very basic email to my accountant that looks something like this: Hey!The Project "PROJECT NAME" is done.Send invoice to “COMPANY NAME”:  “AMOUNT” + VATInfo: “NOTES”Contact: “CONTACT NAME”Email: ???Best//OscarI have ran into a problem however, I can’t for my life figure out how to add the “contact’s” email adress. Since the contact is only a linked record from “people” where all the details for that contact exists. I do NOT want to add an email field to my project view, since I have a LOT of people and different other linked records there, it will become a mess. Can anyone help?THANKS!!/O 

I am building a base for our clients. Goal is to have them access their data through a portal. They will want to print professionally formatted reports with our company logo and page breaks. Are the print options in portals the same as interfaces? If so,  this will not fit our needs. Would you suggest we use a 3rd party such as Documint?

We have an event that is in multiple different locations. We have a form where they select which location they want to attend. I want to automatically send them the calendar invite when they fill out the form based on their response. Ex: We have an event on Monday in New York, Tuesday in Boston, and Wednesday in Chicago. If they select Wednesday in Chicago they will receive the outlook calendar invite for that specific event.

Is there a way to extract a users email address from their account info?Context...I have a form built in "interfaces" and have toggled on "see who submitted response".Ideally I'm trying to extract the domains for the users as a method to sort with different views.Ex. forms submitted by "domainA.com"forms submitted by "domainB.com"

I am from a company selling STEM supplies to schools. I have three tables:A “Material List” table with a list of materials we have in inventory An “Activity List” table with a list of our STEM activities. Each activity has a linked record field which is populated with linked records in the “Material List” table   An “Activity Material” junction table with the quantities of each material for each activity listed.  Desired Outcome of the Script:I’ve written a script that is intended to: Retrieve an activity record from the "Activity List" table using a passed record ID, whenever the list of linked Material records is changed. Get the linked materials for that activity. Compare the linked materials with existing records in the "Activity Materials" table. Delete outdated records of materials no longer linked to the activity. Create new records for materials that are newly linked to the activity, including setting the Activity and Material fields with appropriate record references

I would like to monitor when anyone changes certain field configurations (e.g. changes the field type, or edits a drop-down selection or similar) so that downstream dependencies can be adjusted or the change can be rolled back. The field manager seems helpful but doesn't seem to be proactive enough for this purpose.

Hi everyone! I'm trying to create automations such as emails and Slack messages to send reminders to my team to update certain projects (records) in a project management interface. When we were using data mode, I simply linked to the Record URL in the body of the message in the automation. Is there a way to link to a specific project/record in the record review layout? Or perhaps in the record summary layout?Here's a link to the video I sent to customer support. I haven't heard back from them and they suggested posting here. https://www.loom.com/share/d6166031e85e47afaf7e1311866f7b88thanks! Megan

I do not get Function Field as a choice in customize field selection- I get Number, Date, etc. Thanks.

Hello, I’m trying to wrap the text in linked fields but I can’t figure out how to do so. In the example below, the Name and the Doc Gap Descriptions fields are linked. In the original field, where the field type is Long Text, the text wraps and is fully visible. In the linked field, the text is cut off rather than wrapped. How do I display wrapped text here? I tried seeing if wrapping would happen in a printout using the print option of “Wrap long text onto additional lines as needed,” but that doesn’t wrap the linked text either. Thanks, Erik

I have a doozy of a formula problem and would LOVE some help. My base has a DATE field called {RR Actual Start Date} and a DATE field called {RR Complete Date}. Date format for both fields is Local (M/DD/YYYY). Default is off, Include time is off, Display time zone is off.I created a FORMULA field called {RR Time to Complete} in which I calculate the difference between the {RR Actual Start Date} and the {RR Complete Date}. All worked fine (and I’ll explain more below) until I tried to create a Rollup to average the values in the {RR Time to Complete} column and kept getting a NaN error no matter what.Here’s the detail:{RR Time to Complete} in holds this formula:IF(OR({RR Actual Start Date}=BLANK(), {RR Complete Date}=BLANK()), 0, IF({Raw_RR_Diff}<1, 1, {Raw_RR_Diff})). The output is formatted as Number with no presets and zero decimal places.The {Raw_RR_Diff} field is a FORMULA column that contains DATETIME_DIFF({RR Complete Date}, {RR Actual Start Date}, ‘days’). It is also formatt

We have an intake form to generate URLs with UTMs parameters. I have created a new form with additional functionality. During testing, I need both the old and new forms to work.My current Formula field concatenates the URL (Root Link) with the UTM parameters and values. There is also a check to determine if the URL provided in the Root Link field contains a "?". If it does, then the concatenation output is handled differently:IF(FIND("?", {Root Link})=0,{Root Link}&{Source Parameter}&{Source Input}&{Medium Parameter}&{Medium Input}&{Campaign Parameter}&{Campaign Input (Child Campaign Name_Linked)}&{Content Parameter}&{Content Input},{Root Link}&"&utm_source="&{Source Input}&{Medium Parameter}&{Medium Input}&{Campaign Parameter}&{Campaign Input (Child Campaign Name_Linked)}&{Content Parameter}&{Content Input})My new form has the option to create some additional link types based on content. If you choose that option, the

Hi guys,The easiest explanation of my problem is this:I have an orders table and I have a “Tags” field in that table (multi select) - one of the tags is “Awaiting Payment” When a customer pays, a team member will remove this tag. When this happens, we want to automatically leave a note in our Notes table.We already create notes automatically in other automations so are confident with that part, but the trigger is more of an issue?I’m thinking that maybe I need a “Tags Previous State” field to copy to?Not really sure, I appreciate any insight anyone can offer. 

Currently in airtable we have each project as a line item, and we have multiple columns that note milestone dates:Brief Start DateKick-off DateIn Market DateOut of Market DateIs there a way to create a gantt view (either in the base or in an interface) where each project bar is segments to show the different working phases of the project using the milestone dates above to create the segments?

I created a database but not the way it is suppose to be, so now I created one with the same fields but it is relational now as i did not know how to build one. So, now I need to move all the data into the new one. Can someone tell me how, i saw something about syncing but I cant find a way to do it. thanksRose