Custom fields

Custom fields are custom values that can be used to set value for user or group and used in queries and reports.

Example of user custom field:

1. We create custom field ERP_salesmen_id

2. Open

   

3. In database we have a table with salesman

4. Open

   

5. We also added one of the salesman as a user in BladeFx

6. Open

   

7. Open

   

   Click “+“ and add value for custom field. We are using value from database 6 because this is salesmen Id in database

8. Open

   

9. Custom field value is added for user

10. Open

    

11. Now we can try to use this field in query

12. Open

    

    With right click, you can open menu from which you can select custom field.

13. Try to run query, and you will receive value for custom field

14. Open

    

     

15. Let also show practical use for custom field.

16. Open

    

    Here we will get all customers which are connected to user/ salesmen.

17. You can also use custom field value in report. You can find all field values in table TblCustomParameters

18. Open