Ask the Community

I have a list of 100-200 sign-up's on a shared view (that's embedded in my website, so it "should" update), and I want to have a public user "Approve" or "Deny" each sign-up by clicking a field button (see screenshot) that would update one Select Field in the respective row. This process happens only once a year.A simple search on the AT community shows that editable shared views are incredibly popular but not possible. There have even been some creative workarounds (like this from GAP Consulting), but it's too much to ask for someone to open 100-200 forms to update one value for each row. I found this editable shared view workaround, and it got my wheels spinning...Wo

I have a new repair business. I have two tables related to this question:One contains People, some of whom own items that they want repaired. The table includes contact info and the repairs they have submitted; the latter is a linked record field.The other contains Repairs, linking back to the item owners, providing all the details of the repair need, and indicating the current status in the repair process.I want to include a field in People showing Active Repairs, which are those that match certain statuses representing "incomplete." I've created this as a Lookup field and tried setting the source field a few different ways:If I set Repair Request, which is a formula field, I end up with an array of text items matching the names of the Repairs that are not clickable to link to those Repair records.If I set Repair ID, which is an autonumber field, I end up with an array of text items matching the Repair ID numbers that are equally not clicka

Hi all,I am wondering if there is a way to either create a new table or export a .csv file that would list out all of a record's linked records in columns. I have an inventory base that tracks outgoing and incoming equipment to and from specific sites. Essentially, I want to be able to export all of the linked record data so that each linked record has its own cell in a respective column. I've included screenshots below to better illustrate my specific case. Is there an automation or script that can perform these actions? I've tried to export just a single record by filtering the view, but all the linked records remain grouped in their respective cells rather than each receiving their own cell/row like I would prefer.

Hello! I've read through other messages and some how-to's and I'm hitting a wall with on automation I have set up. I have an automation set up to track my apartment cleaning tasks. When a record is created in the Cleaning Tracker table [TRIGGER], the automation:    1. finds the records in a different table (Rooms to Clean) to add the new task to where the name contains the same Month and Room/Area as the created record.     2. finds all the records in the Cleaning Tracker that have the same Month and Room/Area as the one just created    IF the record doesn't already exist:        create a new record in Rooms to Clean    IF the record does exist (record length >= 1)        update the record with all of the records that have the same Month and Room/Area This automation works great with every room's task

I am trying to build a shared database for ~30 research sites. There is a set of shared variables that all sites will track but sites also want the ability to track additional site-specific data points. Each site should get to see and edit ONLY their own records (i.e. they should not be able to see or edit any the individual records of any other sites). Each site should have access to an interface dashboard that shares summary data for the shared variables across all sites. I've tried a few different approaches, but haven't found the solution yet. I tried creating different views within the same table for each site, but I don't think that will work because I can't seem to restrict access to a view to only one site.I tried creating different tables within the same base for each site, but I don't think that will work because then I can't create a dashboard that aggregates across all sites.I think syncing may be an option, but we have the

Is there a full proof setting where editors are not able to add new select field options when using the CSV import extension?

After looking at all the questions re: logos in the emails, I find that I am still having problems.  I am not seeing the logo.  I've attached the output and the code.  Please help!!!

Hi,I have three tables:For faultsFor suppliersFor combining the fault and supplier tables so I can have multiple suppliers per fault and different costs for each supplier. (Every record represent a supplier in specific fault).Currently, when I open a new fault from the interface, I need to create a record for the fault and then create a record in the table that combines the fault and supplier tables. (So I can choose which suppliers belong to that fault + add thier pricing)What is the easiest way to create a new fault? Should I just submit two forms: one for the fault and one for the table that combines faults and suppliers? Or is there another, easier way?Thanks.

HiSo i just invited a user with a view license so they could complete a form (locked to our domain). This user was able to create their own workspace, and in the process upgraded themselves to editor.How do i stop this from happening? I'm about to invite 300 people to be able to submit a form for a project, and really don't want them to be able to upgrade themselves to editor and blow my license count.Cheers

Hey there,The "Insights" tab in our base is so useful for clean-up, and one of my favorite features is when it tells us which views in our base haven't been accessed for 90+ days. We're doing a base audit to clean things up, and we want to go through all of our views in a slightly more programmatic way. From the API docs, it looks like the metadata we can pull about a view doesn't contain its "last accessed" date, or anything like that:The only way I could think of to access this data would be to pull our Enterprise logs, search by view ID, and then grab the most recent date stamp for each access. That seems like a rather painful workaround, and since the data is already packaged so nicely in the insights tab, I was wondering if there's a workaround anybody knows of to grab it more quickly without having to do a brute force search. TIA!

Trying to do some base cleanup and design, and having trouble with dependency reporting. Table A has Field ATable B has Field B (Field A Lookup)On Table A, when viewing dependencies of Field A, it shows one dependency listed, which is as expected the Table B's Field B. It also notes in small text that 9 dependencies rely on Field B.On Table B, when viewing dependencies of Field B, it shows zero dependencies listed. So what is the disconnect here? Are there 9 dependencies on Field B or is it 0? If i delete Field B i get NO notifications/warnings, but im not sure if im breaking something somewhere else and wont know until i happen to come across it.How to troubleshoot and resolve this as its not just 1 field doing this, its regularly happening all over the place where the dependencies reported do not align.   

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 u

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. 

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 cha

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