Forum Discussion

DavidHalter2's avatar
DavidHalter2
Qrew Member
4 years ago

Filter a lookup table based on a date in the current record?

Hi: I'm working with staff / managers and activity tables. Each staff --> multiple activities.  Let's say I want to enter an activity for last week, but this week one of my staff was promoted to a ...
Relationships
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
If you want a lookup field to "freeze" once looked up, then you can use a snapshot field type

https://help.quickbase.com/user-assistance/setting_up_snapshot_fields.html

Conceptis you have your normal look up field but then in addition to that you have a field of the same type as the look up field but you set the field properties at the bottom of the field properties page to snapshot a frozen value when the record is initially saved and never change it.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
DavidHalter2's avatar
DavidHalter2
Qrew Member
4 years ago
Thanks Mark

No I don't think that's quite it. But, I have used some snapshots here.

And I've kinda decided that it probably shouldn't be a big deal. For those few times it is, the person involved can maybe pick a less busy time, switch back to the old status, and then switch back to the new status. It'd probably be fine.

Dave

------------------------------
Dave Halter
------------------------------