...
| 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 |
|
...
Click "Finish" to Save and exit from the dataset creation.
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...