Hello Gliders. My app has many users. Some have the role of ADMIN and others WORKERS. In the morning an ADMIN will set the exchange rate writing it in his user profile, in the “exchange rate” column. At that point I would like to copy that exchange rate to all rows in the USER table. How do I do it?
Then, I use that exchange rate to calculate money amounts in the EXPENSES table. But since an ADMIN changes the exchange rate every morning, the money amounts change every day. I dont want that. Money amounts calculated in one day must stay fixed. How do I fix this?
Don’t write it to the user profile. Write it to a different table and use a single value column to bring it into the user table.
You should be writing that expense rate to the expense table when a row is added so it sticks at that point in time when using it in your math.
1 Like
Awesome Jeff. Thanks!!!
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.