I’m building a database for a small factory that needs to track their time and motion but keep their admin section separately.
I first thought to build everything in one base.
However, that gives me problems with access to potentially sensitive information and there is not enough budget to bump the whole company up to pro users.
I though the way out of this would be to make a ‘primary base’ (the admin base) and a ‘secondary base’ the base where staff will track their time and motion. And have integromat to facilitate and automate the workflow between them.
I want all the main data creation to be created in the ‘primary base’ and have integromat to copy and update it into the ‘secondary base’ where users can chose them and link them to time records that track how long tasks take to perform. When everything has been tracked then copy it back into the ‘primary base’ again.
Has anyone experience with doing something similar?
If so is there somewhere I can learn how to do it?
I’ve so far been fooling around in integromat, and I got a hard time to get it to work.
All help is much appreciated.