I have a base where I have a table that is a list of product names. I have another table in the base which is a synced source of data from emails, where I have the same product names and a few other fields coming in. Basically, the goal of the exer...
I have a table of products that includes a linked record field to a “tags” table. Each product can have multiple tags. I want to create an automation that auto applies one of the tags, called “New Product”, to the product and auto removes the same ...
I have one table with a list of products and their delivery date. I have another table with a list of marketing campaigns and a “Go Live Date” and a “End Date”. I simply want to have this information together in one view so it’s easy to tell what p...
Hey all! Anyone have experience using conditional logic in the Airtable Forms view? I am using it currently to conditionally show a field based on the input of the type of product category the user filling out the form selects (to help skinny down ...
Does anyone have any advice for how to create a filtered view of data I have that only keeps the oldest date of a “group” of records? I have a table where a product iD can show up multiple times but have different data for it depending on another un...
@Karlstens Very sorry for the super slow response. Finally got around to re-implementing and this did work just as advertised. Thanks and super helpful in helping me learn exactly what happening in the script too.
@Karlstens This looks great! I think this does achieve what we’re trying to do. I’m just not getting it to work in my environment – I’ve not really used scripting much to this point.
In my case:
-the products table name is “Product Catalog Referenc...
@Zack_S Thanks. I’m not the best scripter in the world but it’s good to hear some validation that it doesn’t look possible outside a script. I’ll let you know how it goes.
@kvachon Thanks for working with me on some suggestions. I tried the rollup approach and then realized I could just use the original lookup fields and only select records that have occurred during the past month or so as that’s really the time frame...
@KVachon Thanks for the suggestion. Not exactly what I’m looking for… the screenshot I shared earlier in the thread with the pretty color-coded calendar is what I’m trying to achieve (i.e., on the calendar view). Or even a timeline view or Gantt....