Difference between revisions of "Reporting on Custom Fields"
From SmartWiki
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | There is a pre-built report that provides a list of all custom fields you have added to your copy of SmartSimple. | + | There is a pre-built report that provides a list of all custom fields you have added to your copy of SmartSimple. You will find this report in the report category of "Custom Fields." |
| − | When you run this report it will generate a list of all custom fields in the system. | + | When you run this report it will generate a list of all custom fields in the system. The following columns are available: |
| − | *'''Display Order''' – order of the field on the object. | + | * '''Display Order''' – order of the field on the object. |
| − | *'''Object Entity''' – related object – role, UTA level object, event etc. | + | * '''Object Entity''' – related object – role, UTA level object, event etc. |
| − | *'''Tab Name''' – the tab name in the object for this field. | + | * '''Tab Name''' – the tab name in the object for this field. |
| − | *'''Field Name''' – name of the field. | + | * '''Field Name''' – name of the field. |
| − | *'''Field Caption''' – the caption of the field. | + | * '''Field Caption''' – the caption of the field. If the caption is blank then the field name is used for display purposes. |
| − | *'''Field Type''' – One of the 50+ SmartSimple [[:Category:Custom Field Types|field types]]. | + | * '''Field Type''' – One of the 50+ SmartSimple [[:Category:Custom Field Types|field types]]. |
| − | *'''Field ID''' – [[Custom Field ID|Internal ID number]] for the field. | + | * '''Field ID''' – [[Custom Field ID|Internal ID number]] for the field. |
If you need to use this data in MS Excel, click the Show All button, select all the records and copy and paste into MS Excel. | If you need to use this data in MS Excel, click the Show All button, select all the records and copy and paste into MS Excel. | ||
| Line 15: | Line 15: | ||
==See Also== | ==See Also== | ||
* [[Report Recordsets]] | * [[Report Recordsets]] | ||
| + | * [[Custom Field Type IDs]] | ||
[[Category:Reports]][[Category:Custom Fields]] | [[Category:Reports]][[Category:Custom Fields]] | ||
Latest revision as of 15:41, 9 July 2019
There is a pre-built report that provides a list of all custom fields you have added to your copy of SmartSimple. You will find this report in the report category of "Custom Fields."
When you run this report it will generate a list of all custom fields in the system. The following columns are available:
- Display Order – order of the field on the object.
- Object Entity – related object – role, UTA level object, event etc.
- Tab Name – the tab name in the object for this field.
- Field Name – name of the field.
- Field Caption – the caption of the field. If the caption is blank then the field name is used for display purposes.
- Field Type – One of the 50+ SmartSimple field types.
- Field ID – Internal ID number for the field.
If you need to use this data in MS Excel, click the Show All button, select all the records and copy and paste into MS Excel.
