Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoI believe the gist of the answer is here.
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MessageKey=6a90230c-f6c7-4a05-a47b-1b42128bcfef&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer&ReturnUrl=%2fcommunities%2fallrecentposts
Post back if you need more help in adapting it to your situation.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MessageKey=6a90230c-f6c7-4a05-a47b-1b42128bcfef&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer&ReturnUrl=%2fcommunities%2fallrecentposts
Post back if you need more help in adapting it to your situation.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- AlexKnox16 years agoQrew MemberHi Mark - Thank you! I am going to look at this over the weekend and if I have any questions, I will post here
------------------------------
Alex Knox
------------------------------- MarkShnier__You6 years ago
Qrew Legend
So when you're a use case you would wanna populate that 53 week table with perhaps several hundred or 1000 records corresponding to how many days a project could last. Then the formula would calculate to know if the date did not qualify because it was outside the start and stop dates of the project or because it was on a weekend.Then the saved table to table import will just copy across the non null and hence qualified records.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------