Base Design

Is there any way to see sync status of a record in the source base?I am trying to trigger an automation inside the source base once that record is synced.

I have two tables (Table A and Table B) linked to a common table (Table C).When adding a new linked Table C record from Table A or B:I want Table A to use View 1 from Table C.I want Table B to use View 2 from Table C.View 1 and View 2 have two different input requirements upon creation so they have different field orders and visibility.How can I achieve this? Thank you.

Hello!I'm attempting to optimize my Calendar view, and I'm running into an issue.I have a table with tasks that fall in three categories:Multiple Days (Start and End dates are different)Single Day (Start and End date are the same)Deadline/Milestone (only End date is filled out)In Gantt view and Timeline view, these work great. The issue is Calendar view. I duplicate the Start and End dates for Single Day events because it then shows the event as taking a full workday (which is important for our workflow, and it differentiates it from a deadline/milestone)In Calendar view, the start and end date appear as separate cards, essentially becoming duplicates. I could use a date range, but because of the volume of multi day events we have, this would make is extremely difficult to read the calendar. Is there any way I can merge the start and end dates into one card in Calendar view if they are the same, while maintaining the ability to move them around on the view itself? (i.e - not

Why am I having trouble playing HTML5 videos when playing free online pokies at https://pokieslab.com/real-money-pokies/? When I play online pokies, there is sound but no video. Is it possible that my browser does not support playing HTML5 videos? I've tried using a different browser, I've even tried using my phone.The internet is fine, everything works, even I tried to read cookies everything is fine, the website works fine too, now I looked at the code maybe something is wrong here? Still, it seems the problem lies in the code, and I hope you can help me.Code here:   <!DOCTYPE html> <html> <body> <video width="320" height="240" controls="controls autoplay"> <source src="resources/sample/sample1.mp4" type="video/mp4" /> </video> </body> </html>   

Until the new redesign this week I don't there was any way for ppl to see the column descriptions on shared views. The new UI redesign changes that since the column description icon shows up on the top right of the column.I think this might be a data sensitivity issue, as some folks (including me) use column descriptions for internal notes that don't apply to shared views 

Was wondering if anyone has any suggestions for improved visuals / accessibility settings on Airtable? The latest update made it reeeeaaallly hard for me to see things like icons & symbols. Was wondering if someone had suggestions for extensions or settings that might add high contrast / easier to read text & symbols?  

Airtable, I noticed you've changed the colours. Whilst the update is nice, you seem to have included multiple shades of blue that are incredibly alike and cancel each other out.Rather than have three different blues, you could explore the vast range of greens you're missing. The bright green you had before could have been slightly amended to fit within the set. I'm sure a lot of people use greens within traffic light colour coding.

My plant names table has these three fields: Taxon Name, Name Status, Accepted Name, and Synonyms. Here's the table: https://airtable.com/shrHB9evyZmBawj0CTaxon Name is for all possible plant names. Some of these are "accepted names", meaning they are the names currently in use. But some names are "synonyms", meaning they were formerly used, but are no longer used for that species. The synonym name has been replaced by an accepted name. If a Taxon Name is a synonym, I mark it as a Synonym in the Name Status field and enter the currently accepted name in the Accepted Name field. The Synonyms field is for keeping track of all synonyms that were previously used for any currently accepted name.I need a formula for the Synonyms field that does the following: 1. Search the Accepted Name field for non-blank entries. 2. Compare the value in these non-blank records to the values in the Taxon Name field. 3. In the Synonym field, when a Taxon Name field value is equal to a value in the

Aside from the problematic association of "Master" with slavery, Master Base sounds very inappropriate if spoken too quickly. I've used Queen before (in reference to honeybee hierarchies) and am seeing Primary becoming more of a standard.Here are some other suggestions from Microsoft: https://learn.microsoft.com/en-us/style-guide/a-z-word-list-term-collections/m/master-slave

Hi! We are a small visual artist company. We work on several projects at a time, repeating tasks on different projects, like on animation video production. We don´t know wether we need to create one base with all our projects, with a table for projects, one for clients and one for tasks. Or to create one base for each project, syncronizing the task tables from a generic base. We need to somehow have a general overview in one view from all the tasks due to each project. I hope that you understand what I mean, and that you will be able to help me! thanks!

I would love to have some additional filter options for filtering the base and grouping the views. Google Tables lets you filter by Week, which is a great feature. I can't find a way to do this in Airtable. I can only say within the next or previous 7 days. What if I want to see it by just this current week Monday-Sunday? Especially in the reporting. Below are the DataStudio and Google Tables quick select date filters. From what I can tell, I cannot do this with Airtable. One of my Bases is my estimating department. I just moved them over from Google Tables, and one thing that is greatly missed is the ability to group by week. Seems like it should be an easily accessible feature, and I hope I'm just missing something. It would also be nice in the reporting to be able to compare last month versus this month or last year versus this year. Cannot do that because the filters, from what I can tell, only show "within" as an option. Thank you for any help

Hello! I am currently at a standstill. To make my long story short... I have a database that keeps track of vehicles and equipment. This included Maintenace records, mileage, locations, etc.  (Keep in mind I am not the only one who uses it) Because I have seniority with it, I am more familiar with it. However, I have come across a problem. In my database we have a tab names Mileage where we keep track of the monthly mileage for vehicles that we will be submitted to an outside program. I created a form to send out to employees that are responsible for vehicles (1 employee, 1 vehicle). This form automatically creates a record into the tab which I like but I do not want it to do that. or at least want it to do something else. I would want to do the following or get close to it:  list of vehicles showing the 49 vehicles that need mileage information. The mileage that gets submitted through the form updates the list (this would have to be monthly, and we cannot

Hello, I have multiple team members using our airtable system. We are all in the same database and I am looking to track productivity from the team based on records updated within a day. Is there anyway to pull a report or set something up so I can see who completed what per day, month, etc? Example. Sally and John both work for Company ABC. Sally completes 5 tasks in the system and John completes 2. Currently the only way I know to see this is by clicking in the record making it not feasible to be able to view the productivity. Thanks,

Hi all,I am building a base for capturing information about a large collection of school trophies. The "trophies" table includes a linked field, "people." In the "people" table, there is a "role" field. There may be cases where a person has multiple roles, e.g. "alternate" and "student." It seems like there should be a way to characterize the relationship from trophy to person by multiple roles. I don't have enough experience to know my options. Can someone help?https://airtable.com/shruKrwtvk0k9OEFvAlso, is there a way to limit a date field to year only?Thanks mucho!Sam

Hi there,I am hoping to get some advice on what to do in the following scenario:I have a base created from form entries. I want to add a column to this base to reflect a 'customer_id' that I have separately in an external csv. I cannot import this data to match it within Airtable as it has ~600k rows. I want to match the name and DOB given by the forms in the base in Airtable with the same values in my customer_id dataframe in order to import the customer_id as a new column in my Airtable base. Any tips on the most effective and efficient way to do this, within Airtable as much as possible, would be greatly appreciated! But if there are any integration suggestions, let me know! Thank you 🙂 I see that you can do something similar to what I am asking using the CSV import extension... however this has a 25k row limit which is problematic for my 600k customer dataframe.

Hi there,This might be a simple question, but I'm new to Airtable so decided to bring it to the experts.I'm building a CRM for team use. I have a masterview to the CRM and can see all people and associated companies. That said, I only want my team members to be able to see the companies/contacts I tag their name on. To do this, I've tagged each contact I want to be associated with a team member with that team member's name, and then created different views for each team member.For example, let's say I have a company; Colgate, and a team member I've assigned to Colgate on my sales team; John. I would just tag John in a field I've created "Assigned to", and then create a separate view and group all of the companies John is tagged on.Here's my question – how do I make the view private so ONLY John and I can see John's tagged companies? 

Hi there,I wonder whether the questions asked in a form have to be the column titles of the resulting data table? Many of the form questions are very long and tedious, and I would like the column names of the output table to be much simpler and easier to digest.Thanks!

I have a master Locations table which has a list of locations. Each location then has it's own table that has it's own set of unique records.I'd like to make a lookup field in the master Locations table that links to all the records in each location. I have made multiple lookup fields for each table, but I'd like to make it a single field with the linked records.Is this possible?

Good day all!Currently we schedule training that has been nicely integrated with GCal.  Recently, we decided to track rescheduled training for better communication and reporting.  I've added a "RESCHEDULED" check box to be marked when a training has been rescheduled.  My idea is to have another table, that "holds" all the rescheduling.  I'd like it to hold:Training Title (obviously) which it would get from the linked record to this table.Old training date and timeNew training date and timeNow how can my automation ensure it copies and pastes the Start Date and Time prior to changing that field to the new Start Date and Time without overwriting the old Start Date and Time?  I want to avoid the process from overwriting the data it's intended on tracking LOL.Ideas?

Hello there,I have a base where we are taking job hours and rolling up all the hours into monthly payroll. I attached screenshots of the sample base.Basically, I am trying to create an animation where if {Payroll Link} is empty, then copy and paste  {Payroll Link Calculation} into the linked field. If that record doesn't already exist in the Payroll table already, then create a new record, and just like before, update the {Payroll Link} link with {Payroll Link Calculation}.I've tried multiple versions of this automation and keep getting stuck. Please let me know if I need to provide more information on the base's structure. Thank you in advance for any help!

Hello,We are trying to create a base that allows us to track our workers' capacities (we called them Dimensions: skills, tools, languages, seniority level...), manage project requests and show matching workers for each request. For that, we have created a table for each dimension we want to track in workers (one table for skills, another for tools, another for languages, another for seniority level, etc.).Then, we have a table for workers, where we add every worker and select their dimensions in fields linked to the previous tables. Some dimensions have a 1-to-many relation with workers (for instance, a worker can only have one seniority level, but several workers can have the same seniority level). Other dimensions have a many-to-many relation with workers (for instance, a worker can be proficient with more than one tool, and several workers can be proficient with the same tool). And then, we have another table for requests. In this table, we have several fields linked with

Hi everyone,I am trying to insert in a single select field which has options "true" and "false" (without quotes) a data coming from an application through a webhook which is either "true" or "false" (also without quotes).Unfortunately, when trying to do so, I get an error 422 "Cannot parse value for field blabla".Is there an incompatibility between the values true and false and a single select field ?Shall I add quotes in the original data so it can be inserted into a single select field ?Thanks in advance for your help,Gilles

Hi all!I'm new to Airtable hoping it can help me to design an Investment Tracker including forecast reporting and graphs for the next X years.  If I have an investment which is saved in a table with eg. Start dateEnd dateAmountInterest (per month or year)Exit fee at end of durationInterest payment (month/qtr/yr/rollup)I want to get rid of the 'Excel way of working' where I have to create a large spreadsheet with 12 months a year and many fields to fill. What would be the best way or workaround to have reporting values per month/qtr/yr? Reporting in terms of return per... / Cash Flow per... / etc.Thanks!

Hello All,I have two tables, one have items and second have handling company. I make linked record so for items i linked handling company. Some time back I deleted linked record on the side of handling comany. I really miss this and now I need information about what handling company make what item.It is way how to repair it? I dont want make new linked record collum, because I have really lot of records now. Thank you

Hello all. I'm a total newbie so forgive me for my simple question.I'm building my TMS for my hotshot trucking business, when I created "expenses" field I can't figure out how to formulate or date or maybe some other way im not aware of, weekly, monthly, quarterly and yearly expenses so my end of quarter and YTD calculations are correct.Can someone please give me some guidance?Much appreciated!