...
- Remove: If you added the field by accident, you can remove it by clicking the red "X" to the left of the field name.
- Rename: In the text box to the right of the field name, you can choose a different name for that table to appear by in the dataset. This is helpful if the original name of the field is long or vague.
Info | ||
---|---|---|
| ||
If you are creating a map report, be sure to include the Geometry column from the PermitApps table in the fields section. If the Geometry column is empty but you do have a map on the application, please contact support through the service desk link in the top right corner of the site. |
Step 5: "Formulas"
This step allows you to add fields to the dataset and format them to display differently than they do in the original table. This step includes mathematical operations, and date formatting.
...
appid | Datetime Completed | Date On/Before/After |
---|---|---|
123 | 2018-01-01 09:38:00 | Before |
321 | 2018-04-20 15:01:00 | On |
456 | 2018-09-30 07:19:00 | After |
789 | N/A |
Step 7: "Formatting"
...
Info | ||
---|---|---|
| ||
If you are planning on creating a Map Report and want to include a link to the application, since the link builder is not available in the Map Report type, you will need to add a link column to the dataset. The link to an application follows a set formula: "https://onegov.site.com/view.php?id=###" where the ### is the UID of the application. On the Formatting step, use the Concatenate operation to build the link. The first box of the Concatenate operation will use the Manual Entry box to enter the whole link without the UID at the end (https://onegov.site.com/view.php?id=) and the second box will be the appid (Called UID on the dashabord of the site) field from the main table (PermitApps or AppValuesByTypeId/XX). When you preview the application, you should see a column for the link that has a fully functioning link to the application in question. Try copying and pasting the link into your browser to test that it is working properly. |
Operation | Use | Requirements | Operation Format |
---|---|---|---|
Coalesce | Returns the value of the first field in the listing that isn't null/empty | Two or more fields | |
Concatenate | Returns two or more fields formatted together as one field | One or more fields | |
Currency | Returns a number formatted as a dollar value | A field containing a numeric value | |
Date Format | Returns the date provided in a format specified in the formula | A field containing date data | |
Date Only | Returns only the date portion of a datetime field | A field containing a date | |
Date Part | Returns a portion of the provided date as specified in the formula | A field containing a date | |
Epoch to Datetime | Returns a datetime value converted from an epoch value(the number of seconds since January 1, 1970 not counting leap seconds) | A field containing a numeric value (Must be an epoch value to function correctly) | |
Join | Returns a listing of values associated with a single value (Explained below) | A field and a separator value (space, comma, semi-colon, etc.) | |
Leftmost | Returns a number of the leftmost digits of a field as specified by the second value of the formula | Any field | |
Number | Returns a number field converted from a text datatype | A text field containing a number | |
Rightmost | Returns a number of the rightmost digits of a field as specified by the second value of the formula | Any field | |
Text to Date | Returns a date field converted from a text datatype | A text field containing a date | |
Text to Datetime | Returns a datetime field converted from a text datatype | A text field containing a date |
...
Example 2: Filter out all applications submitted after a certain date and all application applications where the approval date is blank (the application hasn't been approved)
...
Click "Finish" to Save and exit from the dataset creation.
Related articles
Filter by label (Content by label) | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...