Base Design

I would like to hide the primary field in a gallery because I want to use a long field for the title. I understand primary keys and keeping the title short. No problem. But, I don’t want to publish the primary key but a long field. I attached an example pic of what I am talking about but not sure anyone can see it, since all I see is a link.

Dear Airtable Community,I need your help with the following issues. In the course of project management, the employees have to submit a monthly performance report (%) for all current projects to our controlling department.Example:Project XYPerformance report Nov. 2023: 75 %Performance report Dec. 2023: 85 %etc.It would be great if the value of the previous months remains and is not overwritten, but I don't want to create a new column for the upcoming percentage entry every month.I would be happy if someone could suggest a solution to this.Best regards & thank you

When I use Aritable I either get the solution straight away or spend days knocking my head against the wall just to find out I’m overcomplicating things. I’m currently in the latter situation, so please bear with me :winking_face: I’m designing a Crypto Portfolio Tracker on Airtable. I have 2 tables: COINS TRANSACTIONS I plan to add every transaction I make (buy or sell) to the TRANSACTIONS table. If amount is positive it’s a BUY, if it’s negative it’s a SELL. So far, so good. Now I’m trying to create a PORTFOLIO table summarising/aggregating of all my transactions to reflect my current portfolio. This PORTFOLIO table should aggregate (sum or average) all records with the same {Ticker} to give me information about how much of each coin I have. So a PORTFOLIO table would look like: Ticker | Total Amount | Cost Basis | Current Price | P/L Where: Ticker - {Ticker} from the Transactions table. The transactions table will have multiple entries with the same ticker, but I’d like to show

I have a table for meetings that is linked to a Personnel table and an attendance confirmation table that is also linked to the Personnel table.When a meeting is submitted, an email is sent to each linked personnel record with a form. The form is prefilled with the meeting ID and the Personnel's name. When they submit, it shows that they attended the meeting.I'm trying to find a way - within the meeting table - to show what personnel (linked in the meeting table) have not completed an attendance form using a lookup into the attendance table to find the personnel name. Any ideas are greatly appreciated!

Hello!  I'm trying to come up with a formula or script or something that will let me know when a duplicate record was entered into my table.  I know I can use Dedupe to find current duplicates, but this is an ongoing issue and would love to be able to be alerted if something is entered into the base that already exists.  I saw another thread from a few years ago that said this was possible with a script.  Anyone have any insight?  Basically I'm thinking that when a new record is created... the script will run and based on the results of that script it either will or won't send me an email.   Hopefully that makes sense!

Hi, I would like to be able to share and sync data from multiple workspaces of clients to 1 table in my own base/workspace. For example, I have 10 clients with 10 fields in their base and I would like to have 2 of those fields automatically synced and stacked onto each other into one table in my base/workspace. (Instead of having multiple tables from multiple clients in my base).A solution that we're currently using is having a form that clients can use to add data to our base and a client view on that base in the clients workspace. But that limits the client doing changes to fields that are not in the synced table. Ideally clients can work from their own base and can add rows themselves and can change everything (and not having us to change certain fields that cannot be changed due to links to other tables in our base). Thanks for you help!  

Hi all, I currently struggle with how I should manage all team members. I would like to have them in a table called "People" (Person Name is just a single text field), with Birthdays, Joning Dates, Headshot image, title, which domain they belong to etc. Then other tables like tasks will have an assignee who is linked to the peoples table. So far so good. This would allow me to have nice overviews within Interfaces like in this template:No I noticed during Form creation for Tasks that I can't have a default value "current user", nor that automatic notifications are possible if someone got added to a field. Is there a way to solve this and bring this together?Like if I select a "User" in a task that they will get notifications and that the task will be then also linked in the "People" table? Update: Right now I am planning to use automations for notifications and to do that I added an email field in the "People" table. If someone has other ide

I'm working on tracking progress for multiple offices and their checklists. Currently, I have two tables - 1 with the Checklist and 2 with the Progress Report. The Progress Report is setup where the first column is the office name and the linked record field/column needs to select multiple records. There are 22 offices with around 25+ checklist items. It has been super tedious going through each line and added the linked records one by one. Is there any way to select multiple records at once to add it to the linked record field?

Hi, just trying to get some advise on how to start creating an inventory managements base on airtable. We provide kits with have their own unique indentfying number - and each kit contains devices which we record the serial numbers of - they belong to each individual kit. Is there a way to build this out so that the Kit ID "contains" the unique devices? But still make them moveable and flexible ? We also will need to track stock that has not yet been built into a kit - but all with have unique serial numbers. Many thanks for any insights! 

I'm a new enough user that I don't really know if this is a Base Design, Automation, Sync, or Formula question - apologies.I use Airtable to manage a golf travel business and I have one Base that is a client list with 2 Tables (Names and Past Trips). The Names table has 20+ fields/columns. I also have lots of additional Bases that I use to manage the individual golf trips.I would really like to pull in information from the Client List Base to each of the Trip Bases. For example: I have a Roster table in each Trip Base where I list all of the travelers in the first column but I would also like Airtable to automatically pull in each client's Email, Phone Number, and Handicap Index from the Client List base (since they are all tracked in Fields in that Base).Is this possible with the free version of Airtable? And if not, is it even possible with one of the paid versions?Thanks very much for any suggestions.

Hey everyone,Really excited about the new dynamic filtering feature that was just released. I’m trying to implement it on one of my bases but I’ve hit a bit of a snag trying to make it work in my use case.Here’s the deal: I’m with a company that handles housing for employees on a certain project. The employees work in rotations, being on the project for three months and then off for a month, before coming back again. To keep track of apartments and maintenance, we have check-in and check-out forms. The catch is not everyone fills them out because there are just so many of them, and it’s tough to keep track.Right now, when filling out the forms, employees pick their name (which links to our Employee table) and their apartment (linked to an Apartment table). After they check in, their name gets linked to that apartment, and it gets unlinked when they check out. (This gives us a clear view of who's in which apartment at any point in time)What I want to do sounds simple but I can’t quite c

This is a basic hack to sort a simple list of pre-determined roll-up values (e.g. 12 months) without a script or 3rd party automation.In the example below, month values from the Sub-items table are rolled up in Items table / Unsorted column.  Columns 'M1', 'M2', 'M3' use a REGEX_MATCH formula to check 'Unsorted' for the corresponding values.  The column 'Sorted' uses a series of IF statements to to join these together in the right order.  

Hey amazing people 🙂 I have a rollup field puling in unique values, and I really would like it sorted (in this case by ascending date) but I can't figure out how to do that? Community Search didn't bring much up for me.Here are my settings:And here is my display result I would like to see "March 3rd, 2023" March 4th, 2023" "March 5th, 2023"It seems to pull in based on the order of my current Top view in the Table it is pulling from, but even swapping the View with the sort order I want didn't seem to change anything (And I don't want that view at the top anyway)Any ideas?

Hi,  I'd like to create a "Business Health Check" Dashboard, and I'm thinking Airtable might be a good way to do it,  but as a new user I'm not sure how to start. Basics:1. Dashboard view:   Show changes to each category over the past few months (line charts most likely)2. Form:    Owner would fill this out weekly with data for that week3. Data/Questions (this is where I'm not sure how to lay the data out for the questions, or to record it in a way that the charts could use it).  Question examples    - Time Period (Date 1 to Date 7 - usually a week - ie Mon-Sun)    - Booked for how many days out (likely do this as a number field:  1,2,3,4 .....     - How many new inquiries did you get from x source this week?  Number field    - How do you feel about business this week?  - Drop down selector - Not Good, Good, Indifferent      Doing the form so it captures the time period is

1. The Date Time Button in the filter when we select a date the data is not the same in the table where it is linked? When we select the past month, the value of the data is not match in the table when we filter it2. Can we do math operations in a table that is not in the same row but in different row?

Hi,I have a table named "Customer" whose field is "Address"I also have a table named "Invoice" where the associated fields are "Target Customer" where it is linked to "Customer" table and it can linked to many customers; and "Latest Address" which is a roll up field.In my case, i only want to retrieve the last address of the last linked customer. So if i have ["Customer1","Customer2"] in "Target Customer", the "Latest Address" must be Customer2's address only.How can i achieve this?Note: Customer1 and Customer2 are not related to any created time or updated time or any min max value. The sequence is totally random. Thank you

I have a base that is mostly photos, with reference numbers on each one. Because the photos are the "main event", I am trying to use gallery view to print and/or save as PDF.However, I find that cards often break across pages, and sometimes leave the photos invisible. See example, attached.Is there a way to make gallery view print so that cards do not break across 2 pages? Eg, if a card is to big to fit on the bottom of one page, I'd like the whole card to bump down and begin at the top of the next page...Thanks!PS, here is a view-only link to the base in question, if you want to take a look for context:https://airtable.com/apphd3iQywmXlOo2D/shreaoqDCsKGsNO9G 

I have created a form using fillout and and added a forms table in airtable How do I auto update the client table, services table, etcI would appreciate any assistance 🙂 

I am looking to set up a base to manage client onboarding and success.I'm fairly experienced with Airtable and I've built project management bases in the past with linked records and lookups but what I want to build this time has some unusual features and I'm scratching my head how I accomplish this. The use case is something like this:Each new client we bring on goes through an identical series of steps/tasksThese series of steps/tasks can be broken into "modules" such as 1) onboarding, 2) mid year review, and 3) year end review. Each new client added to the base can be enrolled into a module and have a set of records created for their instances of the corresponding tasks. The tasks will be have statuses To Do, In Progress, Done. These roll up into the module. When all the tasks in a module are complete, the module will be marked done.For each client I want to visualize: 1) Their list of tasks (grouped by module), 2) Their modules (with the status)Also want a global view of

Hey guys, Really new to Airtable and not an excel expert either. I have been trying to create a Master Catalog / Master SKU table which contains fields like SKU variations, Amazon ASIN, Category, sub-categories, landed costs etc. I have also assigned a Master SKU code as the Primary and this may overlap for some SKU variations. I want to create another table where I can import the Sales data in excel format, which carries the Amazon ASINs (not all of them populated in the Master SKU) and Units Sold. The excel may also contain other data that is not relevant to this exercise. Similarly, I would like to create more tables to upload sales data from other marketplaces (each has their unique marketplace product ids) as well. How do i get Airtable to recognise these ASINs (or other unique marketplace ids) & match them with the Master so that I can link the records ? Or do i have to key in each line of Sales Data as a New record in a New table and then individually link eac

I developed a table that looks up records from other tables in a base. My colleagues all say that they have never touched this table, yet revision history of multiple records in the Linked column say that they were "edited by pasting." I have searched AirTable FAQ and can't find that phrase anywhere. Has anyone else seen that with Linked & Lookup fields? Perhaps my colleagues just don't remember that they did this? When I add a new record and see it show up in the Linked table, it just shows that I edited it, not "by pasting."

I have a table that was transferred to me over a year ago and now I am the owner. I recently upgraded to the Team plan. I can input data into the template but now matter how I change my field permissions, when I try to delete a row is says: "this table is configured so nobody can delete records". How do I change this? If I am the owner shouldn't I be able to change this. Thank you for your help!

The community's help is really needed. I need to figure out access to certain rows in the database.Scenario: Each row of the table has a "USER" field. In it I select users who have access to the table (screenshot #1). I want to make it so that "USER" see only those rows in which they are selected and can edit these rows. All other rows where they are not selected in the "USER" column, they either cannot edit or cannot see (it’s better if they don’t see it, but it’s not critical).  

I currently have a formula running for # of weeks someone has been enrolled in the program.  Is there a way to have a Kanban view with 52 columns (1 for each week of the year) and have the clients auto populate in those columns based on # of weeks enrolled?

Hello,I am building a Scheduling tool for my company and a feature we do for our clients is "Scheduling Optimization", where we map out their schedules and look for ways to cut down on headcount, merge shifts, etc.I was hoping to use the Timeline View to display the schedules with both date and time taken into consideration, but despite the "Day" view having an hourly breakdown, it still displays each shift as an "All Day" event: I am aware that the Calendar View does this properly, but the problem is the orientation; I'm often working with events that are 100+ staff per day, so the Calendar View is somewhat unusable:The Daily Calendar view is a little better, but I need to see these records from a weekly view in order to properly assess possible optimizations. What I really am looking for is to be able to have either a Timeline View that properly displays record width based on time OR a Calendar View that I can flip the orientation where time is splayed sideways (if that makes sense!)