Track Active Employees by Day
I have a table which lists employees and a formula field which determines if they are currently active based on their start and end date. Any suggestions on how I could generate a table or report that...
Forum Discussion
QuickBaseJunkie
Qrew Legend
Qrew LegendHi Mary!
What you're referring to is commonly referred to as a snapshot table or report. (not to be confused with the snapshot field option)
Quick Base has outlined this in a blog post here: https://community.quickbase.com/browse/blogs/blogviewer?BlogKey=4df369e1-76fc-42da-87d2-90419820d890
Let me know if you find this helpful 😊👍
------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
What you're referring to is commonly referred to as a snapshot table or report. (not to be confused with the snapshot field option)
Quick Base has outlined this in a blog post here: https://community.quickbase.com/browse/blogs/blogviewer?BlogKey=4df369e1-76fc-42da-87d2-90419820d890
Let me know if you find this helpful 😊👍
------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
Thanks, Sharon! This worked great. Do you happen to know if there is any other way to do this through calculations instead of snapshots? Just thinking (1) the snapshot table will have a ton of records and (2) if someone is unable to enter a new hire or departure in time, it may miss the snapshot. No worries if not.. this solution is great and I really appreciate the help! -Mary
------------------------------
Mary Gaughan
------------------------------
------------------------------
Mary Gaughan
------------------------------