Ask the Community

We leverage a concatenate field to be able to indicate when milestones fall during certain weeks. We are wondering if there is a way to revise the formula so that we can have the grouping be in order chronologically by year. I have supplied the formula that we have and how the grouping is appearing today below. 

Hi, my first post here.  I've tried to find similar posts to what I'm trying to do with no luck.  I am working in a product base and am using formulas to create product titles based off of multiple formula fields.  We have products with stones and without, and then we have different types (ie. pendants, necklaces, etc.) that depending on their values make up the title.  I have created the following formulas fields (which are basically concat formulas) and now need to create another formula to come up with the final title:GG Title with StoneGG Title No StoneGG Title Pendants with StoneGG Title Pendants No StoneThe logic would be:If {Division}=GG and {Master Stone}="No Stone" and {Type}="Pendant", then use "GG Title Pendants No Stone"If {Division}=GG and {Master Stone}!="No Stone" and {Type}="Pendant", then use "GG Title Pendants with Stone"If {Division}=GG and {Master Stone}="No Stone" and {Type}!="Pendant", then use "GG Title No Stone"If {Division}=GG and {Master St

Hi all,I was wondering if anyone have experience with making a simple expense overview per project in Airtable?I'm thinking like maybe a quick registration per project with a drop down that determines what the income / expenses is and it add's each registration to an overview per project.Example if you want to register a invoice from a supplier you would choose expenses and do a little text like Supplier Name and the cost.Then it would on each project add these together and give a quick overview (something like attached picture)I hope it makes sense. Does anyone know if this is possible? I have added a view on how our airtable looks.Thank you 🙂 /Christina

I’ve read a couple threads on this but didn’t see an answer. When I open a Linked Record, the fields it shows do not directly correspond with any of my actual views from that table. I want to rearrange the fields for the Linked Records, but don’t know how to adjust if they don’t seem to be coming from one view. They are not coming from the first view in that table. Thank you for any help!

Hi, I used the HelloWorld TypeScript example, installed and imported the @octokit/rest package to interact with GitHub and now I get the following error. The module is @octokit/rest present in the node_modules, vscode uses types from the package OK.Is there some caveat on using third party NPM modules?Running NodeJS 14 (per docs) and @airtable/blocks 1.18.1 $ block run --http Updating bundle... Bundle Error: Cannot find module '@octokit/rest' from '/workspaces/airtable-run-github-workflow/build/development/transpiled/user/frontend' Your block is running locally at http://localhost:9000  

I'm scratching my head here, if anyone can help!I have an automation to update a record when a linked record is created. For the Record ID in the Update Record step, I'm using a linked field from the previous step, set up as follows:It works perfectly when I run tests, on both preview and run as configured. But in real life, it keeps failing on "Received Invalid Inputs" and when I check, I see the Record ID isn't getting passed through.EDITED TO ADD: I have another automation set up the same way, except the trigger is "When record updated" and it works fine. What am I doing wrong?

I would like input on design or if it's even possible. Here's my scenario.  I have tried this a few ways through Co-Builder, but nothing that works yet.Our organization does a survey for every event/program we have.  The questions are always different.Other staff need to build forms, but they are not 'techy.'  I would like to build a system that creates their evaluation forms automatically and they would have the ability to edit easily through the interface or form builder.  I also need to be able to show the results through an interface real-time.Surveys look like this:Speaker 1 Rating (rating field)Speaker 1 Comments (long text field)Speaker 2 Rating (rating field)Speaker 2 Comments (long text field)(more speakers, not always the same number of them)Which experience was the best? (single select field)Open-ended question (long text field)I do have a license for mini-extensions.  Other staff members do not though.Any thoughts?

Hello!If I want to add a checkbox to a rich text field I simply type [] and checkbox appears.But the same does not seems to work over scripting. I tried all kinds of combinations of `[] ` and `- [ ] ` and so on with no success.```let formattedInstructions = instructions.map(instruction => `- [ ] ${instruction}`).join('\n');```Maybe it's not possible right now?Thank you!

I created a base for a client and now need to transfer that base to them and remove myself as the owner.  What is the best way to accomplish this?

My Interface goals are stalled because I can not figure out how to create my desired bar graph. I created a bar graph example in R to show that I would like to have the number of hours on the Y and the dates on the X. They do not necessarily have to be color coded but they should be separated by the location. In my own attempts to create this bar graph I have only been able to create a count of the number of hours logged. For example, 2 hours has been logged twice for two different dates. This does not provide any substantial information on time and the number of hours spent traveling per location. If anyone is willing to help me figure out how to create this bar graph, please reach out! I would really appreciate it.

We perform record review for the assets we have in our base, around 300 days after the last review date was entered for the asset. These assets are in the LMS Content table, which has linked records back to the Assets table.Rather than have the reviewer go to the the Assets table to update those linked records, I’d like to automate it so some of the linked records get updated with the same new date value.In the Assets table, there are linked records back to the LMS Content table, here I want to update some of those records based on a condition.Here’s a bit more about the desired workflow:I want to update linked records when a value in the Last Review Date field of the LMS Content table changes. For each linked record, from the Assets table where its Asset Type value = “Video”, update its Asset LR Date to the same value just updated in the Last Review Date field of the LMS Content table.Then, for each linked record from the LMS Content table, where the value in the LMS Content fiel

Hi all, I am creating a resource library and I want different info to be displayed in one field based on the selection in another field. Im sure I am over thinking this and there is an easy solution! Here is the example; My base is displayed in a gallery view. Based on the 'Provider' listed, I want the description to change relevant to the 'Name' (e.g. Online Learning platforms'). If more than 1 'Provider' is listed, I want info for both to be displayed.  Is there an easy solution for this? or a workaround? Many thanks! Nick    

I'm working in a new client interface, and they have a button with the action 'Update record'. This is linked to a dropdown. (This is a list of purchase orders.)But there aren't any other settings for this. What does this action do? How is the record "updated"? 

is there a way to enable the viewr of an interface to toggle how the table is sorted? i would like them t beable to click the column and toggle how it is sorted

Hello,Our team has recently started taking advantage of Interfces though we've noticed the search feature seems to work differently than in a regular Airtable data table. In the first picture I provided you can see that searching "BCTS220" returns two results with "BCTS220-1R" existing in each (this is accurate). But if you search for  "BCTS220-1" it only shows one result even though that string exists in the the other record which isn't being shown. Does anyone know how searching in Interfaces is different or if there's a way to correct this?

Hi, I am trying to create a base and keep getting the "could not send request error" Attached is my Json body and the screen shot of the API call and the error.       { "name": "CMM 2017", "tables": [ { "description": "A to-do list of places to visit", "fields": [ { "description": "Name of the apartment", "name": "Name", "type": "singleLineText" }, { "name": "Address", "type": "singleLineText" }, { "name": "Visited", "options": { "color": "greenBright", "icon": "check" }, "type": "checkbox" } ], "name": " Editorial 2017" } ], "workspaceId": "wsprSxuHCKzjhwYUM" }       

Hi! I created a prefilled form link but somehow it’s not populating the field. I created other similar ones and those are working though. Help! Working: Form Not working: Form

Is there a way to use the Multi-Select Field WITHOUT the field options being in Bubbles (i.e., as just plain text). I currently push several multi-select fields into Page Designer to generate record reports; however, have to maintain an interim field for each that uses a formula to strip out the bubble. It is a cumbersome workaround. Seems like there should be a "Bubble" toggle just as there is a "Color-code option" toggle.

Hello Airtable Community,I'm working on a project that involves calculating the Qibla direction using Airtable. I have latitude and longitude data for various locations stored in my Airtable base. I need to create a custom formula that can accurately determine the Qibla direction for each location.I have come across the term "boussole prière en ligne" (online prayer compass) and understand its importance in providing precise Qibla directions. Could someone guide me on how to implement the necessary trigonometric calculations within Airtable’s formula field to achieve this? Specifically, I’m looking for a way to:Input the coordinates of the Kaaba (latitude: 21.4225, longitude: 39.8262).Use the haversine formula or any other relevant trigonometric function to compute the initial bearing from any given point to the Kaaba.Ensure the result is displayed in degrees, representing the direction to the Qibla.I would appreciate any examples or step-by-step guidance on setting up this formula. If

Hi there!Quick question: If a recipient of an automated email from Airtable (sent by Airtable mail server) clicks on the "unsubscribe" link, will his/her email address be "blacklisted" for all automated emails from that Airtable base or is this specific to the automation which has executed the "send email" step?Cheers!

On one table I have item name/type/start date, and I’d like airtable to auto-fill some cells next to it in that row depending on the type/start date selected (type is a dropdown single select). So for instance on this table: When the type (green arrow) is monthly email (or whatever the type is), then fill in the cells next to it (purple box) which is called from this table: I’d also like it to fill in dates according to the start date of that item, so for instance if it’s type “monthly email” starting on June 17th, then according to the second table calculate the date of 2 weeks before the start date. Going to sync this with our CRM for activities, so these cells next to it are the item activities name/date. Here’s a loom video if it’s easier, thanks a lot Loom Charged Production [Copy for Development - June 10, 2022]: Pipedrive...

Hi all,I am trying to add info from a linked table (one to many relation) in the body of an e-mail in an automated action.This is my setup:TableA with Fields Name, Age, Status, Email, ...TableB is a collection of dates on which the person in TableA is expected. Fields: Name (from Table A), date, type of meeting)One record in tableA can have multiple lines in TableB.Now I want to be able to send an automated mail that contains the info from TableB (date and linked type of meeting).Is this somehow possible? If yes, can someone please help me how to solve this?Thanks in advance.Kind regards,Kenneth De Vos

Is it possible to link multiple filters to a single grid in an Interface? I have a base with 11 tables; 1 primary table and 10 support tables. In my primary table, I have 31 fields, 10 of which are linked records. I would like to create an interface for my client that will allow for as simple or as complex a query as needed. To explain further:My primary table is a plant directory. I would like my client to be able to choose a simple query, such as:All plants that are Red. I would also like my client to be able to choose a complex query, such as:All plants that are Red or Orange, Low Maintenance, requires Full Sun, is Fragrant and is Deer Tolerant.Is there a way in Airtable to be able to accomplish this?Thank you in advance, Mr. Brad B.

Hi,I'd like to give users a button to create a new table in the backend with default fields and table name. This table could be a duplicate of an existing table. Is is possible to implement this functionality on the front end?

Im loving MiniExtensions and Airtable. It does exactly what is needed without clunkiness. Creates a portal for users to work with and see your data.  Id looked at Softr, Noloco and others, but they get very pricey or very complex fast and need a lot of line by line field crafting. MiniExtensions is simple and does the trick.Keen to see though, with anyone else using Airtable and MiniExtensions, how are you better managing login and front end access?  Airtable creates users and magic links well, but Im hoping someone may have worked out a way to manage password or phone numbers to send the passcodes to? Users at my end are fairly simple so I need to dumb it down and keep it secure same time.