jjl-pdx - profile

jjl-pdx · Aug 02, 2023

Hi there... We are trying to use Airtable to forecast workload capacity vs. demand. Each project in our forecast has a number of tasks. Each task is assigned a "skill" (the skill required to complete that task), a person-week effort to complete it, a...

jjl-pdx · Oct 20, 2023

I'm having this exact same issue... as this query is 6 years old, I'm not holding out much hope... unless there is some newer function that does this?

jjl-pdx · Oct 19, 2023

Just tried this out to solve my exact same problem - and it worked! Including the delete portion you added (which was like my first question - great update). Thanks so much!!! Though, it was a bit confusing as you have tables and fields with the same...

jjl-pdx · Sep 18, 2023

I don't see any way to do this, but as a work-around, I rename the old record detail layouts as "delete1" "delete2", etc... so I know not to use them. Some day, I'll actually be able to delete them... someday.

jjl-pdx · Aug 07, 2023

This works, but...If you are applying a Record Template that uses a relative date, and that relative date is blank, you'll get an error. If you do this same operation in a traditional view, it asks you to enter the missing date before applying the te...

jjl-pdx · Aug 03, 2023

Thanks, that's at least encouraging that I seem to be on the right track in general. Though, writing scripts to help manage this is probably beyond my capability... or at least would take more time than it's worth for me for this particular problem. ...

User Statistics

User Activity

Database structure for forecasting analysis

Re: How to compare two linked-to-other-records fields

Re: Automatically Populate Junction Tables!

Re: How to delete an interface LAYOUT

Re: Apply record template in interface

Re: Database structure for forecasting analysis