Hello everyone
I’m currently beginning to use pipefy for inventory control as described in: https://help.pipefy.com/en/articles/875875-inventory-control, everything is ok except that I need associate an equipment or group of equipment to a user once, this is in order to avoid associate the same resource to different users twice. So I wonder: is there a way to associate one or more equipment to a user in order (from my equipment data base) to avoid resource reuse?
Inventoty Control
Best answer by genietim
@pedro-barrios I see. The only possibility (yet, as far as I know) to require fields to have unique values, is for certain database fields.
Principally, I can imagine you to add a third, relational database then: a EquipmentToUser database. This database would include (min.) three fields:
- - The user (Employee-Connection)
- - The equipment (Equipment-Connection)
- - The equipment-ID (numeric field, which you require to be unique)
Now, in the Inventory pipe, I suppose you have some phase where you have the fields:
- - The user (Employee-Connection)
- - The equipment (Equipment-Connection)
All you need to do now is to add a third field: the EquipmentToUser database connection field. Make it required. One entry only. Create only. Add the autofill-options to set all the three values of this database to the values of the card you have to set the field in. Thanks to the required field, the database entry has to be created for the crad to progress. Thanks to the database requiring equipment to be unique, the database entry cannot be created if the equipment is already assigned somewhom. Therefore, the card can only progress when the equipment is not assigned yet.
Reply
Join us in the Pipefy Community! 🚀
No account yet? Create an account
Login with your Pipefy credentials
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.