Base Design

I have a base that stores plant information, including photos of each plant in an attachment field. I use a formula to put the attachment URL into a field. Here's what I do with that information to create a web map of my plants:1. Download a CSV of a table that contains the relevant data, including the attachment URLs.2. Upload the CSV into ArcGIS Online to serve as the data for a web map.3. Use the Attachment URL field data to display the plant photos in map pop-ups. You can see the result here. My attachment URLs are still working, but I know at some point they will switch to expiring URLs. I need to find an external storage solution that will allow me to do the following:1. Easily (automatically?) upload attachments from Airtable to an external storage location.2. Automatically link the new URL for each image so the Attachment URL field in Airtable now points to the storage location for each image. When I download the CSV from Airtable, I need a URL that points to the corr

Hey Airtable community,My service business has multiple income streams, ranging from one-time to ongoing projects.I am attempting to create a table that can total both one-time revenue and requiring revenue for the month that income comes in. I am having a hard time getting my head around how to do this.I first have a date column with the date the project started and then a formula column that formates the date to just the month so that I can group by month.Currently, I'm only accounting for one-time revenue. I was thinking I could create another date column with automation to duplicate on the same day every month for recurring payments. From here, I don't know how I would total both one-time and recurring payments in a given month?Any help would be greatly appreciated!

I run a small company that makes products using parts from an inventory and sells them to vendors. I'm trying to achieve the following - I receive an order, I enter the order as an invoice which includes all the information about which products are ordered, the database checks the amount of raw parts I have in stock and tells me whether I have enough to make the products in the order. Currently I have few tables with junctions between them - a table with a list of parts, a table with the details of products and what parts are needed to make them, a table with a list of products with each product as a one line entry. Then I have invoices and a junction with invoice detail which use the product information. Currently I am using a one line entry to indicate whether an invoice is yet to be made or completed, I want a system that will tell me which parts I need to complete an invoice and then whether I have enough, which parts of the order can be made ok and which can't. I don't w

hello I am looking to get some bits of the base name " the index of the DTC Brands", do ou know how to get it please? 

I have a problem with CSV import that is messing up all the data. When I try to import CSV with more than one record with the same Primary field name, it updates another field to be the same. For example: Data 1:  Frederik (Primary Field) | Kiyomizu 1 (Field) Data 2:  Frederik (Primary Field) | Kiyomizu 2 (Field) Data 3:  Frederik (Primary Field) | Kiyomizu 3 (Field) It updates as: Data 1:  Frederik (Primary Field) | Kiyomizu 1 (Field) Data 2:  Frederik (Primary Field) | Kiyomizu 1 (Field)  <--- incorrect data in fieldData 3:  Frederik (Primary Field) | Kiyomizu 1 (Field)  <--- incorrect data in field Is there any way to work around this glitch? Please help! Thank you

Hi All,I'm trying to sync an extension (page designer) from my primary base to another base.All of the information are reading from the primary base and been syncing to the 2nd base. I just need to reflect whatever is on the extension to the 2nd base.Is there a way to do this?Thanks in advance!

Please bear with me since I'm new to Airtable and this is hard to explain.  I've inherited a base which contains details on job descriptions which is to be used to merge into a Formstack docs.Main Tab lists the details of each job description in rows. (eg. title, reports to, requirements level, requirements...).  2nd Tab contains job requirement levels in rows.  (eg Level 1, Level 2...)  A column in this second tab contains bulleted lists of the requirements.  The main tab has a column for Requirement Level(s) and a job can have multiple levels linking to the records in the 2nd tab. So this column has links to multiple records/levels. The problem is with a lookup field/column in this main tab. It pulls Levels requirements (pulling from multiple records if more than one Level). So returning and combining bulleted lists from multiple records.However when it does this, it will automatically adds a comma into the lookup field between the bulleted lists from the rec

I have one table in a base that has a list of different artists under management, the "Artists Base", lets say group A, group B, group C, etc. In another table of contacts, I have a field that is a link to the "Artists Base". Instead of selecting all the artists from group A, is there a way I can create a group tag to assign all artists in Group A to a particular contact?

I have a course of instruction which is 65 days long.  Inside of each day I have specific learning objectives to accomplish.  Currently my objective table links to a course flow table which is 65 days of training.  Along with these 2 tables is an instructor table and a table which covers the 20 teams we have coming through the course’s start date and graduation date for this fiscal year.  My question, is there an easier way to populate in a calendar the 65 days of training for each team to be only on week days based off the start and graduation date table?  I have tried creating a specific table addressing every day of the week, however it is quite time consuming especially when dealing with 20 different teams each covering 65 days of training.  Thank you for your time.

Hi, I use Group by option on field Project (linked field). But I don't understand why 2 groups for the same project are displayed. An idea ?  

Hi all,I think I'm close, but I just can't workout how to get the forecasting base I'm building to show Monthly sales vs Monthly Forecasts when I want to track them across an additional split out by stream.I have this Monthly table linked to the projects table, but only solution I can see next is to pull in Each Stream's target as a look up field regardless if it's relevant to that project. Monthly ForecastingProject TableI'm also trying to see if I can get it to work visually instead using the Chart Extension, so any advice there also welcome. And please - if this isn't clear enough - do ask questions! Any help greatly appreciated!

Hi, I'm a complete beginner to airtable so sorry if this is a dumb question, but here goes anyway.. I created a product table which is a collection of parts grouped by name. I want to then use the name of each product as a single select field in a new table, but instead I get all the entries for every part within that product.Ultimately I want to display price information for each product - sum of all the parts cost, wholesale price etc. 

Hello all, I'm getting to know Airtable and might have this newbee question: I'm trying to select the distinct entries of a table after a group by, something like in SQL would be done bySELECT DISTINCT ActorsFROM MovieDetailsGROUP BY ActorsI'm finding some difficulties in doing this easily in Airtable: is this easily done?Many thanks in advance for your help and best wishes,G.

HiI have two tables - Registration and BookingsBoth tables relate to the same customers.Customers submit their Registration forms and they are updated at least annually. There is an automation that links new or updated Registration records to another table, which has a roll-up to find the most recently created record for each customer. There is a formula field in the Registration table that compares the created date of a record to the most recent date from the roll-up. I filter on that formula field so in the Registration table I only see the most recent submission although all previous submissions are still available.Customers submit a Booking form every time they want to make a booking so there may be a number of booking records for each customer.I would like to link the tables so that I can create a view which has the most recent Registration record and all the Booking records for each customer.What is the best/simplest way to do this.Thank you. 

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