Join the Team Forms community

T
S
A
C
H
Members
Daniel Kendall
D
Daniel Kendall
Offline, last seen 3 months ago
Joined July 15, 2024

E.g.
Form only with date field and default moment()

Populates successfully, but gives the error that it is invalid.

{ "title": "Blank", "icon": "<svg xmlns=\"http://www.w3.org/2000/svg\" viewBox=\"0 0 24 24\" width=\"24\" color=\"#9f6b53\" stroke=\"#9f6b53\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" fill=\"transparent\">\n <path stroke=\"none\" d=\"M0 0h24v24H0z\" fill=\"none\"></path><path d=\"M9 5h-2a2 2 0 0 0 -2 2v12a2 2 0 0 0 2 2h10a2 2 0 0 0 2 -2v-12a2 2 0 0 0 -2 -2h-2\"></path><path d=\"M9 3m0 2a2 2 0 0 1 2 -2h2a2 2 0 0 1 2 2v0a2 2 0 0 1 -2 2h-2a2 2 0 0 1 -2 -2z\"></path><path d=\"M9 14h.01\"></path><path d=\"M9 17h.01\"></path><path d=\"M12 16l1 1l3 -3\"></path>\n</svg>", "schema": { "display": "form", "components": [ { "label": "Date / Time", "labelPosition": "top", "displayInTimezone": "viewer", "useLocaleSettings": false, "allowInput": true, "format": "yyyy-MM-dd hh:mm a", "placeholder": "", "description": "", "tooltip": "", "customClass": "", "customClassAdvanced": "", "tabindex": "", "hidden": false, "hiddenInPdf": false, "hideLabel": false, "autofocus": false, "disabled": false, "tableView": false, "modalEdit": false, "shortcutButtons": [], "enableDate": true, "datePicker": { "disable": "", "disableFunction": "", "disableWeekends": false, "disableWeekdays": false, "minDate": null, "maxDate": null, "showWeeks": true, "startingDay": 0, "initDate": "", "minMode": "day", "maxMode": "year", "yearRows": 4, "yearColumns": 5 }, "enableTime": true, "timePicker": { "showMeridian": true, "hourStep": 1, "minuteStep": 1, "readonlyInput": false, "mousewheel": true, "arrowkeys": true }, "multiple": false, "defaultValue": "", "defaultDate": "", "customOptions": {}, "redrawOn": "", "clearOnHide": true, "customDefaultValue": "", "calculateValue": "value = moment()", "allowCalculateOverride": false, "validateOn": "change", "validate": { "required": false, "customMessage": "", "custom": "", "customPrivate": false, "strictDateValidation": false, "multiple": false, "unique": false }, "enableMinDateInput": false, "enableMaxDateInput": false, "errorLabel": "", "errors": "", "key": "dateTime", "tags": [], "properties": {}, "conditional": { "show": null, "when": null, "eq": "" }, "customConditional": "", "logic": [], "onChange": "", "attributes": {}, "creatorPermissions": "", "permissions": [ { "user": {}, "permissionLevel": "" } ], "type": "datetime", "timezone": "", "input": true, "prefix": "", "suffix": "", "protected": false, "unique": false, "persistent": true, "refreshOn": "", "dataGridLabel": false, "dbIndex": false, "calculateServer": false, "widget": { "type": "calendar", "displayInTimezone": "viewer", "locale": "en", "useLocaleSettings": false, "allowInput": true, "mode": "single", "enableTime": true, "noCalendar": false, "format": "yyyy-MM-dd hh:mm a", "hourIncrement": 1, "minuteIncrement": 1, "time_24hr": false, "minDate": null, "disabledDates": "", "disableWeekends": false, "disableWeekdays": false, "disableFunction": "", "maxDate": null }, "overlay": { "style": "", "left": "", "top": "", "width": "", "height": "" }, "encrypted": false, "showCharCount": false, "showWordCount": false, "allowMultipleMasks": false, "addons": [], "datepickerMode": "day", "skipRemoveConfirm": true }, { "type": "button", "label": "Submit", "key": "submit", "size": "md", "block": false, "action": "submit", "disableOnInvalid": false, "theme": "primary", "input": true, "placeholder": "", "prefix": "", "customClass": "", "suffix": "", "multiple": false, "defaultValue": null, "protected": false, "unique": false, "persistent": false, "hidden": false, "clearOnHide": true, "refreshOn": "", "redrawOn": "", "tableView": false, "modalEdit": false, "dataGridLabel": true, "labelPosition": "top", "description": "", "errorLabel": "", "tooltip": "", "hideLabel": false, "tabindex": "", "disabled": false, "autofocus": false, "dbIndex": false, "customDefaultValue": "", "calculateValue": "", "calculateServer": false, "widget": { "type": "input" }, "attributes": {}, "validateOn": "change", "validate": { "required": false, "custom": "", "customPrivate": false, "strictDateValidation": false, "multiple": false, "unique": false }, "conditional": { "show": null, "when": null, "eq": "" }, "overlay": { "style": "", "left": "", "top": "", "width": "", "height": "" }, "allowCalculateOverride": false, "encrypted": false, "showCharCount": false, "showWordCount": false, "properties": {}, "allowMultipleMasks": false, "addons": [], "leftIcon": "", "rightIcon": "", "skipRemoveConfirm": true } ] } }

3 comments
D
A

Excel file with Date Field from Dataverse this is stored as for Example as

19/01/2024 17:00:00
Unclear if relevant but Custom column Type formatting as

yyyy-mm-ddThh:mm:ssZ


This is then converted in the form as example:

In real form this is part of a datagrid


var excelTime = instance.root.getComponent("milestones").selectOptions[0].value["Finish"];

var intermediateTime = excelTime - 25569;

var finalTime = intermediateTime * 86400;

var output = moment.unix(finalTime);

value = output;


Source Code below

{ "title": "Date Fail", "icon": "<svg xmlns=\"http://www.w3.org/2000/svg\" viewBox=\"0 0 24 24\" width=\"24\" color=\"#9065b0\" stroke=\"#9065b0\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" fill=\"transparent\">\n <path stroke=\"none\" d=\"M0 0h24v24H0z\" fill=\"none\"></path><path d=\"M9 5h-2a2 2 0 0 0 -2 2v12a2 2 0 0 0 2 2h10a2 2 0 0 0 2 -2v-12a2 2 0 0 0 -2 -2h-2\"></path><path d=\"M9 3m0 2a2 2 0 0 1 2 -2h2a2 2 0 0 1 2 2v0a2 2 0 0 1 -2 2h-2a2 2 0 0 1 -2 -2z\"></path><path d=\"M9 14h.01\"></path><path d=\"M9 17h.01\"></path><path d=\"M12 16l1 1l3 -3\"></path>\n</svg>", "schema": { "display": "form", "components": [ { "label": "Date / Time", "labelPosition": "top", "displayInTimezone": "viewer", "useLocaleSettings": false, "allowInput": true, "format": "yyyy-MM-dd hh:mm a", "placeholder": "", "description": "", "tooltip": "", "customClass": "", "customClassAdvanced": "", "tabindex": "", "hidden": false, "hiddenInPdf": false, "hideLabel": false, "autofocus": false, "disabled": false, "tableView": false, "modalEdit": false, "shortcutButtons": [], "enableDate": true, "datePicker": { "disable": "", "disableFunction": "", "disableWeekends": false, "disableWeekdays": false, "minDate": null, "maxDate": null, "showWeeks": true, "startingDay": 0, "initDate": "", "minMode": "day", "maxMode": "year", "yearRows": 4, "yearColumns": 5 }, "enableTime": true, "timePicker": { "showMeridian": true, "hourStep": 1, "minuteStep": 1, "readonlyInput": false, "mousewheel": true, "arrowkeys": true }, "multiple": false, "defaultValue": "", "defaultDate": "", "customOptions": {}, "redrawOn": "", "clearOnHide": false, "customDefaultValue": "", "calculateValue": "var excelTime = instance.root.getComponent(\"milestones\").selectOptions[0].value[\"Finish\"];\r\nvar intermediateTime = excelTime - 25569;\r\nvar finalTime = intermediateTime * 86400;\r\nvar output = moment.unix(finalTime);\r\nvalue = output;", "allowCalculateOverride": false, "validateOn": "change", "validate": { "required": false, "customMessage": "", "custom": "", "customPrivate": false, "strictDateValidation": false, "multiple": false, "unique": false }, "enableMinDateInput": false, "enableMaxDateInput": false, "errorLabel": "", "errors": "", "key": "dateTime", "tags": [], "properties": {}, "conditional": { "show": null, "when": null, "eq": "" }, "customConditional": "", "logic": [], "onChange": "", "attributes": {}, "creatorPermissions": "", "permissions": [ { "user": {}, "permissionLevel": "" } ], "type": "datetime", "timezone": "", "input": true, "widget": { "type": "calendar", "displayInTimezone": "viewer", "locale": "en", "useLocaleSettings": false, "allowInput": true, "mode": "single", "enableTime": true, "noCalendar": false, "format": "yyyy-MM-dd hh:mm a", "hourIncrement": 1, "minuteIncrement": 1, "time_24hr": false, "minDate": null, "disabledDates": "", "disableWeekends": false, "disableWeekdays": false, "disableFunction": "", "maxDate": null }, "skipRemoveConfirm": true, "prefix": "", "suffix": "", "protected": false, "unique": false, "persistent": true, "refreshOn": "", "dataGridLabel": false, "dbIndex": false, "calculateServer": false, "overlay": { "style": "", "left": "", "top": "", "width": "", "height": "" }, "encrypted": false, "showCharCount": false, "showWordCount": false, "allowMultipleMasks": false, "addons": [], "datepickerMode": "day" }, { "label": "Milestones", "labelPosition": "top", "widget": "html5", "placeholder": "", "description": "", "tooltip": "", "customClass": "", "customClassAdvanced": "", "tabindex": "", "hidden": false, "hiddenInPdf": false, "hideLabel": false, "autofocus": false, "disabled": false, "tableView": true, "modalEdit": false, "multiple": false, "dataSourceId": "j6t9tjq62emy", "labelProperty": { "label": "Project Task Name", "value": "Project Task Name" }, "template": "<span>{{ item['Project Task Name'] }}</span>", "filterQuery": "", "refreshOn": "", "clearOnRefresh": false, "clearOnHide": true, "customOptions": {}, "calculateValue": "", "sortBy": "", "sortDirection": "", "removeDuplicates": true, "selectFields": "", "sampleItem": { "Project Task Name": "Enter Project Name Here", "Owner (Lookup)": "Daniel Kendall", "Project (Lookup)": "Project Template Light Example", "Project Bucket (Lookup)": "Not Started", "Project Task Status": "Active", "% Complete": 0.06, "Critical": true, "Display Sequence": 2, "Due Date": 45310.7083333333, "Duration": 35, "Effort": 70, "Effort Completed (Hours)": 8, "Effort Remaining (Hours)": 62, "Finish": 45310.7083333333, "Is Milestone": false, "Manually Scheduled": false, "Notes": "", "Notes - Plain text": "", "Outline Level": 1, "Parent Task (Lookup)": "", "Priority": 5, "Project for the web CreatedBy (Lookup)": "Daniel Kendall", "Project for the web ModifiedBy (Lookup)": "Nicol Cutts", "Project Sprint (Lookup)": "", "Resourcing unit (Deprecated in v3.0) (Lookup)": "", "Role (Deprecated in v3.0) (Lookup)": "", "Start": 45264.375, "Start Date": 45264.375, "Summary Task": true, "Created By (Lookup)": "Microsoft Project", "Created By (Delegate) (Lookup)": "", "Created On": 45240.5483564815, "Import Sequence Number": "", "Modified By (Lookup)": "Microsoft Project", "Modified By (Delegate) (Lookup)": "", "Modified On": 45244.3578819444, "Owning Business Unit (Lookup)": "stoneseedsandbox", "Owning Team (Lookup)": "", "Record Created On": "", "Status Reason": "Active", "Time Zone Rule Version Number": 4, "Traversed Path": "", "UTC Conversion Time Zone Code": "", "Version Number": 2411011, "Project task ID": "8c823e62-ca7f-ee11-8171-000d3a467ca0", "Process Id": "", "Created By": "643dcc5e-5f7d-ee11-8179-000d3aa9254e", "Created By (Delegate)": "", "Modified By": "643dcc5e-5f7d-ee11-8179-000d3aa9254e", "Modified By (Delegate)": "", "Owner": "6e61cbe6-627d-ee11-8179-000d3aa9254e", "Owning Business Unit": "ef49924b-967a-ee11-8179-000d3abf51a9", "Owning Team": "", "Parent Task": "", "Project": "74cff85d-ca7f-ee11-8179-0022488ab225", "Project Bucket": "96823e62-ca7f-ee11-8171-000d3a467ca0", "Project for the web CreatedBy": "6e61cbe6-627d-ee11-8179-000d3aa9254e", "Project for the web ModifiedBy": "cb82193b-647d-ee11-8179-0022488ab225", "Project Sprint": "", "Resourcing unit (Deprecated in v3.0)": "", "Role (Deprecated in v3.0)": "", "Owning User": "", "Owning User2": "6e61cbe6-627d-ee11-8179-000d3aa9254e", "_stageid_value": "", "_stageid_value3": "", "Finish Text": "" }, "validateOn": "change", "validate": { "required": false, "customMessage": "", "custom": "", "customPrivate": false, "strictDateValidation": false, "multiple": false, "unique": false, "onlyAvailableItems": false }, "errorLabel": "", "errors": "", "key": "milestones", "tags": [], "properties": {}, "conditional": { "show": null, "when": null, "eq": "" }, "customConditional": "", "logic": [], "onChange": "", "attributes": {}, "creatorPermissions": "", "permissions": [ { "user": {}, "permissionLevel": "" } ], "type": "spSelect", "input": true, "prefix": "", "suffix": "", "protected": false, "unique": false, "persistent": true, "redrawOn": "", "dataGridLabel": false, "dbIndex": false, "customDefaultValue": "", "calculateServer": false, "overlay": { "style": "", "left": "", "top": "", "width": "", "height": "" }, "allowCalculateOverride": false, "encrypted": false, "showCharCount": false, "showWordCount": false, "allowMultipleMasks": false, "addons": [], "dataSrc": "custom", "authenticate": false, "ignoreCache": false, "idPath": "id", "data": { "values": [ { "label": "", "value": "" } ], "json": "", "url": "", "resource": "", "custom": "values = instance.customQuery(component)" }, "limit": 100, "valueProperty": "", "lazyLoad": true, "filter": "", "searchEnabled": true, "searchDebounce": 0.3, "searchField": "", "minSearch": 0, "readOnlyValue": false, "selectThreshold": 0.3, "uniqueOptions": false, "fuseOptions": { "include": "score", "threshold": 0.3 }, "indexeddb": { "filter": {} }, "useExactSearch": false, "tag": "h1", "skipRemoveConfirm": true, "defaultValue": {} }, { "type": "button", "label": "Submit", "key": "submit", "size": "md", "block": false, "action": "submit", "disableOnInvalid": false, "theme": "primary", "input": true, "placeholder": "", "prefix": "", "customClass": "", "suffix": "", "multiple": false, "defaultValue": null, "protected": false, "unique": false, "persistent": false, "hidden": false, "clearOnHide": true, "refreshOn": "", "redrawOn": "", "tableView": false, "modalEdit": false, "dataGridLabel": true, "labelPosition": "top", "description": "", "errorLabel": "", "tooltip": "", "hideLabel": false, "tabindex": "", "disabled": false, "autofocus": false, "dbIndex": false, "customDefaultValue": "", "calculateValue": "", "calculateServer": false, "widget": { "type": "input" }, "attributes": {}, "validateOn": "change", "validate": { "required": false, "custom": "", "customPrivate": false, "strictDateValidation": false, "multiple": false, "unique": false }, "conditional": { "show": null, "when": null, "eq": "" }, "overlay": { "style": "", "left": "", "top": "", "width": "", "height": "" }, "allowCalculateOverride": false, "encrypted": false, "showCharCount": false, "showWordCount": false, "properties": {}, "allowMultipleMasks": false, "addons": [], "leftIcon": "", "rightIcon": "", "skipRemoveConfirm": true } ] } }

2 comments
D
A