About
The Fields setup section allows you to define which specific data points are included in your custom data source. You can also apply transformations to these fields to ensure the information is presented in a user-friendly format within your Dash blocks.
To access these settings, navigate to Site administration > Plugins > Local plugins > Dash Addons > Manage data sources and select Create custom data source or Edit.
Available settings
Placeholder fields – Select fields from the main table and joined tables to act as placeholders for use in transformed field values.
Field – Choose a specific database field from your tables to be included in the data source.
Transform the format
Change how the raw database value is displayed. You can apply multiple transformations to a single field by clicking the + button. Transformations are processed sequentially.
Additional format value
Provide custom static content or parameters for the transformation. When you add multiple transformations using the + button, a corresponding Additional format value field is created for each step. Ensure you enter the parameters in the field that matches the position of your transformation.
Trash bin icon – Remove a specific field configuration or an individual transformation step from the settings.
Add 3 field(s) to form – Add three new field configuration groups to the settings.
Available transformations
You can use the following formats to modify your data:
None – No transformation is applied.
Bool – Displays values as true or false.
Date – Converts Unix timestamps into readable date formats.
Identifier – Formats the field as a unique identifier.
Image – Displays the field value as an image.
Link – Displays the value as a clickable link using the additional format value for the URL.
Linked data – Connects the field to data from related tables.
Moodle url – Formats the value as an internal Moodle URL.
Percent – Calculates and displays a percentage.
Time – Displays Unix timestamps as readable clock time.
User image url – Automatically generates the URL for a user profile image.
Course image url – Automatically generates the URL for a course image.
Timeago – Shows the relative time difference between a timestamp and the current time.