Justin_Eppley - profile

Justin_Eppley · Nov 19, 2022

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...

Justin_Eppley · Nov 18, 2022

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 ...

Justin_Eppley · Nov 10, 2022

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...

Justin_Eppley · May 18, 2022

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 ...

Justin_Eppley · May 03, 2022

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...

Justin_Eppley · Jan 06, 2023

@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.

Justin_Eppley · Nov 21, 2022

@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...

Justin_Eppley · Nov 19, 2022

@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.

Justin_Eppley · Nov 11, 2022

@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...

Justin_Eppley · Nov 11, 2022

@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....

User Statistics

User Activity

Linked records conundrum: substitute for vlookup?

Automation to remove a single linked record, not all

Viewing dates from two sources on one view

Using conditional logic in forms - using a field multiple times

Create view with date filtering

Re: Automation to remove a single linked record, not all

Re: Automation to remove a single linked record, not all

Re: Automation to remove a single linked record, not all

Re: Viewing dates from two sources on one view

Re: Viewing dates from two sources on one view