Ask the Community

I am working on a project for a service company. I have a table with clients and then a table of projects that are linked back to the client. Clients are assigned a rate based on different factors. The rate is carried through to any of the projects they are linked to via lookup field. However, I would like to override the lookup field should we have a promotional rate or a specific project needs to be billed at a different hourly rate. Any suggestions?

Is it possible to 2-Way Sync between a Business Workspace table and a table of a separate Team Workspace?Would it be setup from the Business Ws table?

I have a table Treatments and a table Users. Then I have a table Users_Treatments where each record is a combination of one User and one Treatment, and in addition there is a Review field (basically users review treatments they have tried). I have already pre-populated the Users_Treatments table with users and treatments but I miss the reviews. I would like to create a Form, so that each user can add a review for each one of the treatments they have tried. Is this possible? I only managed to create a Form that however shows only one treatment per user.

Hi everybody, I am attempting to use forms to update fields in my table. I need to be able to pre-populate the other fields in the form with the current information that is in the table, is this possible?For example: I have a table of "Items", and each row has the item name and columns of information about the item- owner, amount, etc. In the form, the first question is "what item would you like to update?" with a linked record to the first column with all the items. When an item is chosen, I'd like the other fields to auto-populate with the current information in the table with that item, so they can see what they're updating. If they choose "Scraper", for example, I want the next field of "How many" to auto-populate with the amount that is in the table, and then of course I want them to be able to edit it if necessary. Is this possible, maybe with Zapier? Thank you.

Hi there,We're building a decision-making helper tool on Airtable to reduce the number of meetings at work. For each decision to make that requires the opinion of more than one person, we intend to have people use a dedicated Airtable interface. Someone will create the topic to be discussed on it and then add the relevant participants to the topic.But I'm having a hard time choosing the type of field for the `Participants` field on our database. I feel like it could be both a User field or a Linked Record field. In both cases, I managed to get a `Participants Count` field: in one case with a formula, in the other case with a Count field. I don't know which field type to pick because I don't have a clear overview of each choice's fallout.What seems the best approach according to you?Thanks.

Hi all--Thanks in advance for your thoughts. I have a items shown in the attached that are different content that have different topics associated with them (you can see the column of topics). I'd like to get a view in Airtable where I see all of these segment names associated with the individual topics in lists in 1 view.  The way I've thought about doing it is to try grouping them, but when I group them, they sort with the 4 topics together, not as individual topic lists. Grateful for any advice on how to do this!

Hello, I am trying to understand more about the paid plans, and who exactly on the team needs to pay for plans to access bases that use paid features. We use airtable for our general employee handbook. Although everyone needs to access it, only the admin team needs to have editing/creator rights. From my understanding, someone with a paid plan account needs to create a workspace that houses the handbook base. Then they would share it with the rest of the team, and note in airtable who needs read-only permissions (in which those users won't need paid plans to access the base), and those who should have editing rights (in which we would then need to pay for their plan). Is this correct?We want the handbook base to have the paid features of higher record limit and sync intergrations which would be useful, but we don't want to end up paying $20 a month per seat for everyone just for those two features as the cost isn't justifiable for our case. Additionally, if we have

According to the API docs, it should be possible to set a rollup field using the REST API.However, if I send this:{ "name": "Total Points", "description": "Automatically calculated total points for each user", "type": "rollup", "options": { "fieldId": "fld...", // Field ID of a "Points" field in a Points table "linkedTableId": "tbl...", // ID of the Points table "aggregation": "SUM" } }I am getting this error:{ "error": { "type": "UNSUPPORTED_FIELD_TYPE_FOR_CREATE", "message": "Invalid options for Leaderboard.Total Points: Creating rollup fields is not supported at this time" } }I asked ChatGPT and it tells me that rollup fields cannot be created using the API, despite the API docs claiming otherwise. Is this true, or am I doing something wrong here?(Setting up the rollup field using the UI works just fine.)

Hi there, I'm using the list view in interface designer as a project management tool. When I am trying to drag a line/task to another position, this doesn't work. I want this to work as in Todoist, Microsoft To do or Clickup (in Todoist it works best). I want to manually sort tasks in list view and also drag them to different tasks as subtasks.In my underlying grid view table, each record presents a task / subtask. In this table, I use a child task column for the nested hierarchy in list view.Can you please adjust this, so we can use Airtable like Todoist, Microsoft To do or Clickup?Regards,Chris

I have a multiple select field with four options: 2020, 2021, 2022, 2023. I want a formula field that prints how many of these options were selected. I played a bit with Count and If statements, but couldn't get anything to function quite right. Any help appreciated! 

Hi there,On this interface page, I have 2 progress bars: one visualizing the percentage of people who said 'yes' on a topic and the other one for 'no'.But instead, I'd like to get a stacked bar chart that combines the two figures into one single visualization object (like in the example below).I don't think that's possible as of now on Airtable, at least not on a List-type page. Do you guys confirm?Thanks for your help.

Hi there,We're building a decision-making helper tool on Airtable to reduce the number of meetings at work. For each topic that requires discussion, we intend to have people use a dedicated Airtable interface. On it, someone creates the topic to be discussed and then assigns the relevant participants to it. Later on, the assigned participants weigh in on the topic.The screenshot below displays a list of the decisions to be discussed and of the positions taken by people. Hierarchy on this page is turned on, with topics being on Level 2 and positions on Level 1.As of now, new topics can be created with a short form that opens up when clicking a button, while positions can be created inline. But for the interface to be as simple to use as possible, we would like to make it possible for both decisions and positions to be added inline. We couldn't figure out how to do that, though.Do you know if that's possible?Thanks for your help.

Looks like all of my interfaces that have timeline views have pulled in all 'preview' fields into the record label ... Seems at the moment there's a bug where they can't be seperate and it looks super messy Thanks!Ross

I saw the functionality below on a youtube video from earlier this year, and I'm wondering if there's anyway to implement it, without using the Project Management template? It looks like, from an assignee field dropdown, it gives you a before and after of that user's capacity if assigned to them.  Amazing!Sadly, we're rolling our capacity up to Team level, as we have too many people to use it at the User level, but would love to see if this functionality is accessible outside of the template.Also if anyone has an thoughts / ideas / implemented solutions for forecasting using the utilisation tool, I'm all ears!  At the moment, it seems there's no way to see how a project will affect overall business capacity without adding a full project loaded up with all tasks, etc.  I'd love a similar setup to the above where you'd be able to see the impact before committing it to the schedule ...Cheers!R 

We have a load of addresses in a database. They are individually pasted into a Long Text field.The issue:Some addresses are in this format - 51A Wigton RoadCarlisleCA2 7AYAnd some addresses are in this format- 51A Wigton RoadCARLISLECA2 7AY So the difference is that the Post Town is uppercase - which is what we want.But a lot of submissions have come through in lower case on that second to last line, which is incorrect. I need a formula to find and replace the all text before the last break and after the second to last break, ie. all text on the second to last line. And replace it with the same text but in UPPERcase.  The addresses are not always on 4 lines, sometimes they are on 5 lines, so we would need to work backwords from the last break. A formula to do this would be much appreciated.  Thank you in advance.

Hello,I work for a growing nonprofit that needs *help* in the area of Email Marketing.  We use Airtable to manage our various lists of people and their contact information, but I need a good Email Marketing App that will integrate well with Airtable. We're using MailChimp right now, but it's a mess because it's not integrated with our Airtable contact lists. Can anyone recommend a setup for using Airtable as the CRM, integrated with another Email Marketing App that can:Automatically sync contact lists "two ways" with Airtable.Meaning, if someone updates the Airtable list then the Email App's List will be updated, or if someone Subscribes using an Email App SignUp Form then Airtable's Lists will be updated. (FYI, MailChimp doesn't do this natively, neither does Outfunnel which integrates Airtable and MailChimp.)Manage the Contact Lists, tags, groups, etc. in Airtable, andDesign & send no-code marketing emails using the Mail App, pulling from my Airtable lists.I was looking

I’m looking for help with integrations: My nonprofit uses Airtable heavily to track lists of people and their contact information. We also use MailChimp to send out updates to our partners, newsletter subscribers, etc. using that contact information. My question is this: Is there a simple way to establish a “Two-Way Sync” between Airtable and MailChimp so that they will always contain the same data, regardless of changes made on either side? I need a true “sync” that will: Update MailChimp with any changes entered in Airtable (add, remove, edit), and Update Airtable with any changes entered in MailChimp (subscribe, remove, edit). I’d rather pay a small fee per month for an established app to do this than build it in Zapier/Make, but either way is fine if it works. TIA, M p.s. If you know of a fix for this with an email marketing program other than MailChimp, please let me know. p.p.s. As of today’s writing, Outfunnel can do most but not all of this (like adding un/subscribes to Airta

Hey! We build our company automation and centralized system with Airtable's API & Automation systems.We use 1 Workspace with many many different Bases. Could the Dashboard (in the main view) have folders inside the Workspace that can be used to divide the different bases, which would make it easier to organize and find the right Base. The view looks really messed up right now. 

Hello everyone,I'd like to have an informative main field in one of my tables but im blocked because of circular references. To be brief, I have a table Programme, that is referenced in Sessions, that is referenced in Half-days, that have begin & end dates.In Sessions, i have a cumulative field that defines which is the earliest half-day of the Session in the field {from} and the latest in the field {to}.Id Like for Sessions to have in their main field this formula:{from} {Code name of Programme (from Programme)}and I can't because it is causing a circular reference.Is there a workaround any of you can think of?or How can I get more information about the error to try and solve it?

I live in Lagos, Nigeria, one of the biggest commercial hubs in Africa and I think it's a shame that Airtable is hardly known here. People are still using decade old desktop versions of popular office software that they learned to use when they were in university. I would like to officially partner with Airtable to showcase the product to businesses in Nigeria and Africa as a whole. I sent an email through the Airtable contact form about this but I received a generic response that sounded as if the person didn't even understand my request. I'm hoping that an Airtable community manager or sales representative will respond to this post.

I have this table set up where I have a running balance of what being added and taken from a cash register. I am running this script for it: // change these names to pick a view:let table = base.getTable('TIN');let view = table.getView('ALL');let result = await view.selectRecordsAsync({fields: ['Gross Added or Subtracted']});let runningTotal = 0;for (let record of result.records) {// change the field names here to adapt this script to your baserunningTotal += record.getCellValue('Gross Added or Subtracted');await table.updateRecordAsync(record, {'Running Balance': runningTotal,});} BUT, when someone counts the actual amount in the register, I want the running balance field to become equal to the actual count. How to I do this? 

I have two tables:Table one shows a list of tasks done on different computers and when the task has been marked as finished:TaskId, FinishDateTime, Computername.In table two I have information who was logged in when on on which computer:DateTimeStart, DateTimeStop, EmloyeeName, Computer. I want to have in table one an extra column, showing the name of the EmployeeName that was working on that computer while the task was finished. So we need to use the FinishDateTime and Computername to query the other table to find a match with exactly this computer and FinishDateTime in range between DateTimeStart and DateTimeStop. The result of the formular should show just the Name of the Employee. I hope this is clear. How to create the formular? I am familiar with excel, where i would do some kind of nested vlookups, but have no idea how to achieve this in airtable.

Hi there!  I'm hoping someone can guide me to a tutorial or has some great design ideas:  I have a base that calendarizes a huge list of events across multiple departments.  I have an interface page set-up with a record picker that displays relevant events.  I would love for each department to be able to review the list periodically and either suggest edits to existing records, or request new ones be added.My reason for not having them directly edit the records is because I want to (a) be sure that I know about changes, (b) can resolve conflicts if different team members varied info (that happens!) and (c) am concerned about data integrity when many of our users aren't regular airtable users! Is the best solution here to just allow users to make edits directly & just create some level of automation/notification when edits are made?  Or; I had thought to just request users to make edit suggestions by adding a comment to the record, and I'll get a n

Hi all, I'm very curious if this can be replicated on Airtable interfaces. From my experimentation, the filename of the image keeps coming up and I can't remove it. How do I develop this? Or is this just "non in-application screens"?

I am trying to achieve the following:A "Points" table that stores usernames and points associated with themA "Leaderboard" table that aggregates all points for the users, i.e. sums up the points for each userI set up the Leaderboard table first where I defined a "Username" field as the primary key and a "Total" field as a number field. Worked fine.Now I wanted to setup the Points table so a Username field points back to the primary key "Username" of the Leaderboard table, like this: { "name": "Points", "description": "Points table to track points per user", "fields": [ { "name": "Id", "type": "singleLineText" }, { "name": "Username", "type": "multipleRecordLinks", "options": { "linkedTableId": "tbl..." } }, { "name": "Points", "type": "number", "options": { "precision": 0 }