Base Design

Please excuse the long explanation..I have a spreadsheet showing some factories producing a number of products. For the sake of the example, let’s assume that the factories are the primary records and the products that they produce need to be split out in to a linked table.So the source spreadsheet looks like this:Factory City Country Product Acme Tools Denver USA Spanners Acme Tools Denver USA Screwdrivers Western Hardware Paris France Spanners China Supply Shanghai China Hammers China Supply Shanghai China Screwdriv

I am looking for a way to change the way that my shared Airtable base can be shown as the preview when sharing the url, instead of the generic “Airtable, everyones app platform” being shown. I frequently share the base, and people aren’t opening the base, or are wary to because they dont know what Airtable is. Please tell me there is a way to have a different preview shown? Do I need to first embed it in my website? I am open to paying, or outsourcing but I am just not sure how to start! Uploading: Screen Shot 2022-06-08 at 9.32.46 AM.png… https://airtable.com/shrbYQAOhU8YNsK99

Trying to figure out how to have the Interface “Button” When clicked it will go to the form I built? Do I use external URL?

Hi, I’m fairly new to airtable and having a hard time setting up what I think should be a relatively simple base. I have a staff of about 40 individuals. They only have access to the share views of two of my bases, if that is relevant (so anything they do on airtable has to go through forms). The 40 staff are each assigned between 1 and 4 shifts a week. Each day is divided into 4 shifts of 6 hours, so we have 28 shifts per week. The number of staff members assigned to a given shift varies. Right now I just have a base with two tables: staff names and shifts (listed as mondayshift1, mondayshift 2, etc.). Staff members fill out a form and select their shifts so that the resulting tables fill in. What I would like is a way to track attendance and then later, set up automations (for emails) if someone misses a shift. I was thinking I would create a form for them to fill out when they clock out, with name, shift, and then one optional question

Hi  Dear Community I’m facing issues with the print layoutJust 2 days ago everything was smooth and today I hace noticed this issue with the printing layoutIt does’nt som th complete information here a copy  

Hi, I need an attendance tracker for nonprofit organization that organizes different extracurricular activities throughout the year. I'm working on a generic form that the coordinators of each activity would use to report the activity, time, description/impact, and attendance. The attendance is linked to a table that compiles the beneficiaries of the different activities that are run by the Non-profit. We already have some beneficiaries or previous participants in this table and so some of the attendees are already in our records, but when we have new attendees, I would like to be able to generate a new record from a form. I am able to add a new record in the grid view, but not in the Form. I have already tried to use the link to the form, not the form builder view and it was still not allowing me to add a new record. Is this even possible? or am I missing something? The objective is to be able to have a beneficiary registry or a complete list of beneficiarie

Please change back your UX to the old one. The new one is so washed out its difficult to use!!!

I came back to my bases tonight to find the header colors all muted pastels. Some of us rely on the color to differentiate bases. Also, the contrast is much lower on the tables and the text on them… less accessible and more difficult to read. On interfaces, it’s still the same vibrant color… can we not retain that color in the Data view? Am I missing some setting that got changed? Also, the info in the far left (icon, help, notifications) is taking up more horizontal screen real estate. Maybe I’m the only one, but having huge changes for no benefit seems to be a bad idea for productivity. End of rant. For now. 😁

Hello! I am organizing a large amount of photographs. I often have the year but not the specific date. I would like to use Timeline view to see all these photos in their rough year-by-year order. Suggestions? The DATE field makes me list day-month-year. Thanks!Julie

Hi everyone,I wanted to share some feedback regarding the new Airtable design.The new interface feels less comfortable to use, mainly because of the extensive use of bright colors and white across most of the page, unlike before. It feels tiring on the eyes during long work sessions.Also, I noticed that the sidebar can no longer be resized, which reduces the flexibility we previously had.Is there any way to switch back to the old interface, or at least adjust the colors and sidebar size to make it more comfortable?Thank you.

Hello,I made a CRM with interfaces that my company uses (all mobile). There must have been an update because the UI looks different. The primary concern is that when someone tries to comment on a record within their interface, it says “an error occurred” , backs out of the record to the interface, and then when you go back in to the record to click comments there is no comment. I nor anyone else at the company have touched the CRM and it was working perfectly up until this “update” - Also there are a few other issues that have popped up. Is there an explanation or a possible fix to this?

Hi All, Struggling to get the following functionality into a base and hoping you can help a novice here. We are attempting to use Airtable to track & visualise AWS logs for interactions with our service. I the graph above I have outlined a rough schematic on what we are aiming to achieve however we are running into issues with tracking on a daily basis. I’m not sure how to structure our base so that we can gain the ability filter by day, see which products were trending, measure performance based on view count and feed that back to the client’s tag. Ideally we want to enable our clients to change a date field and see the product list re-order as such, with views, revenue etc following. We can populate the records via an API, we are just struggling with the base design.

Hello!We have been using Airtable to great success as part of our curatorial process (choosing puppet theater productions from around the world to appear in our annual festival.) Now we would like to use Airtable for other processes like - assessing financial feasibility of each show, documenting production needs for shows that will be appearing in the festival, and archiving information for shows that have appeared in the festival. We also have many venues, many artists, and many countries that the artists are from and we want to track all of that easily as well. We often use forms to get info from artists directly into the Base.  The way I am planning on doing it is with - 1 Base with 4 Tables (Shows, Venues, Artists, Countries), and the Shows table has over 100 fields that are used for various stages of the workflow. And I plan on making lots of views so that people at various stages of the process only have to see the data they need.  (I had or

In my setup, each of my clients has their own base and interface. They can submit support tickets through their interface, and those tickets feed into a synced table in my team base. I just got my 21st client and it says I cannot add any more sync sources to my support ticket table.I have the support tickets going to a second support ticket table right now, but our support team doesn’t get them in their support ticket feed. I thought maybe I could create an automation that copies the support tickets from the second table into the original support ticket table, but that won’t work because I can’t create an automation to create a record in a table synced to another source. I thought about creating a new base just for support tickets and then syncing that back to my Team Base, but then my team can’t edit the records once they get to the team base.  Is there another way to create a table that syncs all of my clients’ support tickets into one table in my team

We are a marketing agency that manages social media calendars for many clients. We love the platform for building the calendars and sharing amongst our team BUT sharing the calendars to the clients for approval is an actual nightmare that I can't solve. 1. We have too many clients to add them as paid collaborators and not be super cost prohibitive2. They can comment but would love for them to just be able to use the direct toggle to click approved to streamline.How are you delivering your social media calendars to your clients? 

right now I have two calendars for my inbound and my outbound dates. I want them both to be on the same calendar

Good day.I have a “whole” staff table, with various “statuses” SOWs, Guests, and FTE.  However, a newer table was linked to the base, with “special” contractor statuses.  I need to have these “added” to the above Full Table, along with their statuses, etc.  The whole needs to be the final source as it’s used across bases.  How might I go about this?  

Hello community, I created a DB to collect startup informations through a form.To impose a synthesis, I need to set a certain limit of characters for “long text” question.I can not find a way to do it with Airtable form, so I am integrating a different tool.Nevertheless, it’ll be more practicle for us to stay inside Airtable.Any suggestion ? Best regards,Marco

I have a decent sized based we’re using as a CRM. Every entry is tagged with a representative’s name in a single select field. Over time, some reps have come and gone, and I don’t want to have their names available to select for new enteries, but I don’t want to lose the data of who made previous entries. What I really wish I could do is toggle certain single select options on and off, but I don’t believe I can do that without losing the formatting that we have now, which is helpful. Anyone know a way around this? Screen shot below of what I’m trying to achieve. I do not want to use an interface to resolve this problem, as my team typically does not use interfaces that are built for them! Thanks for any advice you all might have! 

Hello,I am trying to figure out how to create this base without over complicating it. I have customers who need to request licenses for three different softwares. This needs to be in the same form. They need to specify length and quantity of those softwares.  In the from I'm also asking for basic customer information. I've currently set it up so the customer picks the software from a linked table, with conditioning then asking for 'Length' and 'Quantity' for each selected software. https://airtable.com/shrw2mPLjYm203vkk My problem is, that in my base, I'd like separate records for each software picked by the customer, but I'd like it to happen in one form submission, so the customer doesn't have to do it more than once:  Customer 1: Software ACustomer 1: Software CCustomer 2: Software BCustomer 2: Software C

How can I default to opening bases from the icons as it used to be instead of it opening interfaces always when clicking on an app? Very inconvenient for many of my users.

I am trying to use Airtable and Softr to create a page with fund applications for individuals so that I can track which year a fund was applied for and what its status is (ongoing, granted or rejected). It is important that each fund is presented on individual lines through Softr. If you look at the picture, that is how I want it and managed to do it with Google Sheets and Softer. But I am having problems with Airtable. Does anyone have an idea how I can do it?  

Is this base design possible? See image. I need to schedule a variety of sessions categories (29) across a variety of times. Each of the session categories has a varied quantity of allocations. In the photo attached, at the top you can see the session times and the rooms. In each cell is a pull-down list of the allocation type. At the bottom left in the image, you can see the allocation type and the quantity. The table at the bottom sums up the amount of time session allocation abbreviation is entered in the top table and then allows for a horizontal sum calculation.The top table would be very easy to construct. What I’m wondering is if we can make the bottom table a visible entity on the same table? It will be important to see totals as the sessions are allocated. 

Let me first preface these questions with I’m a vet tech not a computer programer/data person, and I’m only doing this for my hobby. I have these two PDF files that I would like to add to my air table to help me classify my model horse show string. I would like to put conditions on the drop down list so If I select one general breed or specific breed or class only a certain list comes up,  Is this possible? What is the best way to do this?  Thank you for your help- Sirena Breed Cross refBreed/show class reference

Hi, I’m trying to build an event management board. Some of my events are recurring, but the current date data type does not allow multiple ones. Do you have a best practice for it? One way I’m thinking about making a separate date table, and link the event with the dates. But the calendar view looks odd for this date table, as it use dates as the primary id and does not allow me to display big event name on it. Also, I don’t know how to filter the ‘date’ data based on conditions in the event table.  i.e. if I want to only show the dates where the event has been confirmed.  Wonder if you have better options? And if yes, please show me!! If not, how to make my current date table better looking?