Custom fields

Owned by Saša Bajsić
Last updated: Jul 22, 2024
2 min read

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. image-20240722-082919.png

  3. In database we have a table with salesman

  4. image-20240722-080818.png

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

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

  9. Custom field value is added for user

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

  12. 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.  

  15. Let also show practical use for custom field.

  16. 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