Page Comparison

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

...

1. We create custom field ERP_salesmen_id

2. Image RemovedImage Added

3. In database we have a table with salesman

4. Image RemovedImage Added

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

6. 

7. Image RemovedImage Added

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

   Image Removed

8. Image Added

9. Custom field value is added for user

10. Image Added

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

12. Image Added

    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. Image Added

15. Let also show practical use for custom field.

16. Image Added

    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. Image Added