Terry

In my database, I want to record timestamps as a request moves through different statuses (I have 12). I would like for the system to pop off an email (to the requester or manager) if a request lingers in one status for too long. Is this a function inhering in Caspio Bridge, or is this something that may need a bit of coding? Thank you.

I am trying to determine the best way to handle multiple roles per user in one database. Example: Multiple applications use the same "users" table for authentication. One user may be a manager with elevated rights in a request database, but may be a requestor in say, another application to submit an expense report. Is it better to have the "users" table and the "roles" table joined as one to many to a third table, or to have a "roles" table per application? Thanks.