Base Design

Need some help. The product is working great. I post a gallery that is sorted by date newest at the top. I have many items in my gallery and each time I view the published gallery it starts at the bottom and that is not what I want. This makes the customers have to scroll to the top when the top should be the starting point. This is also the same for me when adding new material. Once I add the material I have to scroll to the top to make sure it posted correctly. How to get Airtable to start at the top, not the bottom. Particularly on posted material. This is the same with a published grid. It starts at the bottom. Let me know if you need clarification.

We have several tables that were created by an employee who is no longer with the company. He is listed as the “owner” of these tables. Is there a way to make someone else who is a Creator to be the Owner?

Hi is there a way to hide certain fields from view? I have an amazing base (if i do say so myself) for a charity that links all of our fundraisers and how much they have raised etc which is great what I want to add is a column for any of my paid fundraisers on how much I have spent on things like their wages so I can work out their ROI - not obviously I do not want them to be able to see each other’s wages is there a way to either hide a column or add an extra tab/table and hide that instead?

Hi I am -hoping someone can help. I have a database of contacts. I have a dropdown field in the main table where I tag each contact by it type: client, vendor, employee, lead. I have set up a table for each type because while each set share some similar information such as name, email address, phone etc… I also need to capture specific information for each contact type. Is it best to create a main list for Contacts, then a separate list per contact type with its own specific information while still linking them to main contact where I can pull up the generic data name, email address, phone etc… . Or is it best to create a contact table and create different views? If I create one table for all the contact type with different view? Will this mean that each time I add a new contact, regardless of the contact type every single column will be displayed? Or will I only see the relevant information based on the view I am on when I click on add new contact? I hope I am making sense.

I have a dropdown menu, and I want to automatically send a third party an email based on the person’s response. For example, if they choose option 1, I want to send an email to example@gmail.com. If they choose option 2, I want to send an email to example@hotmail.com, etc. Is there a way to do this? Thanks.

Hi, I got several columns in a base. Now I want to delete or move the first column but that option is not available in first column for me and I’m owner. Look forward for help.

I have a multi-select field called “Trades”. A contact can do multiple “Trades”. I want to group by trades, but I don’t want the contacts with multiple trades grouped into their own unique multi-trade grouping, I want them to appear once in each trade grouping. Ex: list of trades is: demo, grading, hauloff. I want a contractor that does demo and hauloff to appear once under the demo grouping and also under hauloff, and I want the only groupings to be demo, grading, hauloff. I do NOT want a Grouping of demo & hauloff combined. How do I achieve this. It seems like it would be a frequent issue.

How can I configure the calendar or Gannt block to show each assigned team for a project if they share the same job#? Example: I need to allow each assigned team member to see their schedule - The calendar shows the record number which is only internally used and links the project under both - and the lack of information shown on the calendar doesn’t provide other users with any information on the project. The Gannt block shows pretty much the same thing in minimal information. Ideally - I’m looking for a way to have each user (4G and Apex) see more details such as:

Hi everyone! I work for a small nonprofit tool-lending library and makerspace in Baltimore, MD. We offer a service called Open Shop, which is a time for the community to come use our equipment and workspace for woodworking, home repair, metalworking, or crafting projects. Due to the pandemic, we’re moving to an appointment-based system for Open Shop and are trying to figure out how to best do that through Airtable. The biggest issue I’ve been struggling with is how to balance capacity limits and flexible scheduling. Ideally, we’d like people to book either 1-hour or 2-hour appointments that can start on the half-hour. We’d like the system to reserve a maximum of 4 overlapping appointments (aka people in the space) at any one time. For example, if there are 4 people with appointments from 5:00 pm to 6:00 and a fifth person tries to book from 5:30 to 6:30, the system should block that appointment because it would exceed the capacity limit of 4 people. Clients would need

Hi, i’m having an issue, i have a base with around 80 new lines, with a date and time. I tried to organise it manually by days and hours, but it seems that it gets messy all the time, maybe when i’m looking for an information using a filter. Is there a way to lock the place of each line based on the date ? Right now i have to sort it “1-9” in order to have then reorganized, but i don’t understand it doesn’t stay like i wanted it ordered… can you help me please ?

Hi friends I have a difficult problem on creating many to many database, As a event manager, I have (for example) 10 events a month (120 events a year) , so I create a table name: EVENTS Our company has about 200 freelance employees , and a part of them may join to organize our events , So I create a table name: EMPLOYEES In that case (many to many relation) I have to create a new table name: EVENT DETAILS And so, if 100 employee organize each event, so the table EVENT DETAILS may have 100*100 = 10.000 rows , and I think it is too many rows … And the other way, I may create a new table for each event include many field: employee, salary, vendor, client, … but in that case, I have to create 120 table a year … I think it’s not good idea … So, My question: is that right solution of that problem and can we have the better solution for that Thank you all in advance !

Hi Friends I’m wondering how to design these kinds of table Manage Event Employees, Salary and Event Profit I have many events (with event information: date/vendors/…) I have many employees to organize events (with employee information: name, phone, email, …) I want to connect many events to many employees (1 employee can do many events and 1 event can have many employees) I want to calculate result & effect of each event so I have to set below information: Salary of each employee in each event (and the opposite, In employee table we can view the employee salary from the past events and the total income they got ) Other Expense in each event Then have total expense in each event Income in each event Then I have profit in each event Feedback of customers in

User Flow: Order # , Order Item and Order Date is recorded by Operator 1 QC is performed on the Ordered item by Operator 2. —> If QC Check passes, select order number, record transaction and send to Pack and Ship. —> If QC Check fails, select order number, record transaction and send order back to warehouse for repair. —> After repair, perform QC check again on the ordered item, select order number. record transaction, Ship date is recorded for each Order number by Operator 3. I have three tables and am following a traditional Relational Database logic: ORDERS , which basically just has an order number and an Order date (along with some other order details). QC CHECK, which is linked to ORDERS table, and where I store PASS or FAIL statuses as well as date of QC check linked to ORDER NUMBER field from ORDERS SHIPPING, which is linked to ORDERS, and where I store ship date for every ord

So I am trying to create a somewhat all encompassing purchasing, inventory, and installation/delivery base to track some material for a specific work scope on a construction site. Essentially we issue purchase orders that have various line items for materials on them (say 10" pipe, 12" valves, 6"x1/2" bolts, 1/2" nuts, etc etc) and they go out to lots of different vendors. I want to log in all the stuff we’ve bought and what vendor it’s from, the purchase or number, etc etc. Next, I want to log in what we have received into inventory. For example I may do a PO to a vendor and I request to purchase 100ea 6" bolts, 100ea 1/2" nuts, and 100ea 1/2" washers. This may not all come in the same shipment. I would like to log that I received 30 bolts, 50 nuts, and 50 washers on 7/31. Then I would log receiving another 30 bolts, 50 nuts, and 50 washers on 8/3, for example, then the balance of the 40 bolts remaining out of 100 on 8/15 (very basically example). The stuff coming in

I’m thinking about using Airtable for my business. But I’m not sure if it will work. I was hoping someone in the community can tell me whether what I’m trying to do is possible. I’m a life coach. I’ve accumulated a large library of information over the past few years. And I want to organize it. That way when I’m coaching people and I remember something I want to share, I can easily find it in Airtable. For example, let’s say there’s a meditation tip I’ve learned I’d like to be able to add the tip but also categorize it in some way to make it easy to find. And maybe even give it a star rating so when I pull up all meditation tips, by category (if that’s possible), I can see which ones are the most effective, based on the star rating. The second thing I want to do is create a CRM to keep track of my clients. I know I can do that. But what I don’t know is whether it’s possible to create meeting notes. For example, if I meet with someone once a week, I need a place to put

I have a “Trade” field that I share between Contacts and companies. The issue I have is when a contact or company does multiple Trades ( ex- demolition and excavation ). I want to be able to use the same list of “Trades” on individual Bids they are submitting on each job, but I don’t know how to carry over just the appropriate Trade label for each bid. I was thinking us setting up a separate table of “Trades”, but not sure exactly how that would work either.

Can I run the app on my Fire HD?

Hi Im following the many to many tutorial from Airtable Airtable - Support

Hi! Is there a way to track completion of forms that are sent to a contact list in one of the tables? We want to send a form to everyone and then see who has or has not completed it yet. Furthermore, some people may need to complete the feedback form multiple times (about a different person/experience each time) so ideally we can see their completion status by the person/experience they are providing feedback on. Any recommendations? Thank you!

Is it possible to change what is able to be viewed on a card as the card moves through different phases of the pipeline in Kan ban view? For example, if my stage is ‘Intake’ only a few fields are displayed, but when the card moves to ‘Due Diligence’ more fields are automatically displayed.

These 2 options should be part of the basic design. And no, the Dedupe block is nice nut is not what is missing here. Simple basic option in every database. Please add this.

I’m setting up a dashboard for a travel agent with 5k+ carried out in 3 different currencies. The set-up I have right now works, but I’m wondering if anyone can suggest improvements or more enhanced approaches to this case. In the main table I’m extracting the ‘day’, ‘month’ and ‘year’ from the transaction date with formulas, then I get the user to link each ‘day’, ‘month’ and ‘year’ to the relevant Day, Month and Year tables where I can summarize the data accordingly. This is working fine but if you can think of a more elegant way to do it, I’d love to hear. The main issue I’m facing is that: I also need to convert transactions to a unique currency, so I prepared a different table with FX daily values - which I link to the main table (where all transactions are recorded) to pull the relevant exchange rate. Is there a way to do so without having the user to link the again to a differen

Project Summary: We need a system of managing, requesting, and distributing resources to students for the 20-21 school year. We are starting by creating a “Drive-Thru Library” A book catalog will be created using QR codes taped to the back of each book- I am hoping to use airtable to start with this inventory. I need for families to be able to scroll through the catalog of available books created with the QR codes and easily make a request - is that possible through airtable? We are looking to expand beyond books. In the future, we are hoping to allow students to be able to “check out” for example, a bag containing science lab materials or a trombone. Tech Goal: Create a system that can scan information pre-loaded into QR codes --> into a form --> that automatically populates into a spreadsheet. Also desirable… If a confirmation email can automatically send in this process. A way t

Hi, is there a way to create a list of the top 10 whatever, products sold, courses taken, etc? Many thanks for your help!!

Hi I’m really confused about lookup fields and assumed they worked in a similar way to vlookup in excel and google sheets. I have two tables:- Orders orderid order name price productid sku Products productid productname sku The Orders sku field needs updating with the sku field from the Products table. Is this possible and can someone show me an example please. Thanks Jonathan