{ "EmbeddedFormsConfig": [], "Description": { "Description": "Use this template to enable users submit timesheets. It contains a layout, workflow and some logic that provides auto-setting the date. It also contains a default value that sets the Submitter and their email along with cascading dropdowns linking a Country and City. This is a good example of the use of workflow and Logic.", "Title": "Template-Timesheets" }, "FormFields": [ { "CalculatedValueFormula": null, "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "Definition": { "DefaultValue": "", "EnforceUniqueValues": false, "Id": "fa564e0f-0c70-4ab9-b863-0177e6ddd247", "IsRequired": true, "IsSystemField": false, "Metadata": { "MaxLength": 255, "TypeName": "TextFieldMetadata" }, "Name": "Title", "Title": "Title", "Type": 9 }, "FieldDefinitionName": "Title", "HasCalculatedValue": false, "IsHidden": false, "IsTitleSyncedWithDefinition": true, "LabelPosition": 0, "LabelTooltip": "", "LabelWidth": 100, "Properties": { "Placeholder": "", "TypeName": "TextFieldProperties" }, "State": 3, "Title": "Title", "LabelFont": null, "BodyColor": null, "ThemeInherited": true, "PrintMode": 0, "VirtualFieldType": null }, { "CalculatedValueFormula": null, "DefaultValue": { "CustomDefaultValue": "getCurrentUser()", "DefaultValueType": 1 }, "Definition": { "DefaultValue": "", "EnforceUniqueValues": false, "Id": "6dba4871-7381-4c8f-8e0b-91c5788bb500", "IsRequired": false, "IsSystemField": false, "Metadata": { "SharePointGroupId": 0, "AllowMultipleValues": false, "SelectionMode": 0, "TypeName": "UserFieldMetadata" }, "Name": "Submitter", "Title": "Submitter", "Type": 3 }, "FieldDefinitionName": "Submitter", "HasCalculatedValue": false, "IsHidden": false, "IsTitleSyncedWithDefinition": true, "LabelPosition": 0, "LabelTooltip": "", "LabelWidth": 100, "Properties": { "Placeholder": "", "TypeName": "UserFieldProperties" }, "State": 2, "Title": "Submitter", "LabelFont": null, "BodyColor": null, "ThemeInherited": true, "PrintMode": 0, "VirtualFieldType": null }, { "CalculatedValueFormula": null, "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "Definition": { "DefaultValue": "", "EnforceUniqueValues": false, "Id": "c8f2113b-dd69-4783-b24e-c5a000c0c6ed", "IsRequired": false, "IsSystemField": false, "Metadata": { "DependentLookupFieldNames": [], "IsDependentLoookup": false, "IsMultiSelect": false, "LookupFieldId": "Title", "LookupListId": "5594fe4f-f2f9-4ac5-92ad-917dbf2c89d1", "TypeName": "LookupFieldMetadata" }, "Name": "Country", "Title": "Country", "Type": 7 }, "FieldDefinitionName": "Country", "HasCalculatedValue": false, "IsHidden": false, "IsTitleSyncedWithDefinition": true, "LabelPosition": 0, "LabelTooltip": "", "LabelWidth": 100, "Properties": { "AllowAutocomplete": false, "FilterMode": "beginsWith", "EnableFiltering": false, "Placeholder": "", "TypeName": "LookupFieldProperties" }, "State": 3, "Title": "Country", "LabelFont": null, "BodyColor": null, "ThemeInherited": true, "PrintMode": 0, "VirtualFieldType": null }, { "CalculatedValueFormula": null, "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "Definition": { "DefaultValue": "", "EnforceUniqueValues": false, "Id": "7ce6ab0d-e58f-46ab-a36a-bad3a49a9a82", "IsRequired": false, "IsSystemField": false, "Metadata": { "DependentLookupFieldNames": [], "IsDependentLoookup": false, "IsMultiSelect": false, "LookupFieldId": "Title", "LookupListId": "5b238173-ab06-44a3-a3ed-74a8cd47f437", "TypeName": "LookupFieldMetadata" }, "Name": "City", "Title": "City", "Type": 7 }, "FieldDefinitionName": "City", "HasCalculatedValue": false, "IsHidden": false, "IsTitleSyncedWithDefinition": true, "LabelPosition": 0, "LabelTooltip": "", "LabelWidth": 100, "Properties": { "AllowAutocomplete": false, "FilterMode": "beginsWith", "EnableFiltering": false, "Placeholder": "", "TypeName": "LookupFieldProperties" }, "State": 3, "Title": "City", "LabelFont": null, "BodyColor": null, "ThemeInherited": true, "PrintMode": 0, "VirtualFieldType": null }, { "CalculatedValueFormula": null, "DefaultValue": { "CustomDefaultValue": "getCurrentUser().emailAddress || \"\"", "DefaultValueType": 1 }, "Definition": { "DefaultValue": "", "EnforceUniqueValues": false, "Id": "d2783493-d463-4e44-a0b6-29fb430f2747", "IsRequired": false, "IsSystemField": false, "Metadata": { "MaxLength": 255, "TypeName": "TextFieldMetadata" }, "Name": "SubmitterEmail", "Title": "SubmitterEmail", "Type": 9 }, "FieldDefinitionName": "SubmitterEmail", "HasCalculatedValue": false, "IsHidden": false, "IsTitleSyncedWithDefinition": false, "LabelPosition": 0, "LabelTooltip": "", "LabelWidth": 100, "Properties": { "Placeholder": "", "TypeName": "TextFieldProperties" }, "State": 3, "Title": "Submitter Email", "LabelFont": null, "BodyColor": null, "ThemeInherited": true, "PrintMode": 0, "VirtualFieldType": null }, { "CalculatedValueFormula": null, "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "Definition": { "DefaultValue": "", "EnforceUniqueValues": false, "Id": "350387b0-3948-4b34-9d32-4a680c321bf6", "IsRequired": false, "IsSystemField": false, "Metadata": { "MaxLength": 255, "TypeName": "TextFieldMetadata" }, "Name": "SubmitterDepartment", "Title": "SubmitterDepartment", "Type": 9 }, "FieldDefinitionName": "SubmitterDepartment", "HasCalculatedValue": false, "IsHidden": false, "IsTitleSyncedWithDefinition": false, "LabelPosition": 0, "LabelTooltip": "", "LabelWidth": 100, "Properties": { "Placeholder": "", "TypeName": "TextFieldProperties" }, "State": 3, "Title": "Submitter Department", "LabelFont": null, "BodyColor": null, "ThemeInherited": true, "PrintMode": 0, "VirtualFieldType": null }, { "CalculatedValueFormula": null, "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "Definition": { "DefaultValue": "", "EnforceUniqueValues": false, "Id": "79781add-fdaf-455a-be96-70a6ffe079b1", "IsRequired": false, "IsSystemField": false, "Metadata": { "SharePointGroupId": 0, "AllowMultipleValues": false, "SelectionMode": 0, "TypeName": "UserFieldMetadata" }, "Name": "Manager", "Title": "Manager", "Type": 3 }, "FieldDefinitionName": "Manager", "HasCalculatedValue": false, "IsHidden": false, "IsTitleSyncedWithDefinition": true, "LabelPosition": 0, "LabelTooltip": "", "LabelWidth": 100, "Properties": { "Placeholder": "", "TypeName": "UserFieldProperties" }, "State": 3, "Title": "Manager", "LabelFont": null, "BodyColor": null, "ThemeInherited": true, "PrintMode": 0, "VirtualFieldType": null }, { "CalculatedValueFormula": null, "DefaultValue": { "CustomDefaultValue": "today()", "DefaultValueType": 1 }, "Definition": { "DefaultValue": "", "EnforceUniqueValues": false, "Id": "a924fc11-a6cd-4bd8-b1f3-bbed4444943a", "IsRequired": false, "IsSystemField": false, "Metadata": { "DisplayType": 1, "TypeName": "DateTimeFieldMetadata" }, "Name": "Date", "Title": "Date", "Type": 4 }, "FieldDefinitionName": "Date", "HasCalculatedValue": false, "IsHidden": false, "IsTitleSyncedWithDefinition": true, "LabelPosition": 0, "LabelTooltip": "", "LabelWidth": 100, "Properties": { "Placeholder": "", "TypeName": "DateTimeFieldProperties" }, "State": 2, "Title": "Date", "LabelFont": null, "BodyColor": null, "ThemeInherited": true, "PrintMode": 0, "VirtualFieldType": null }, { "CalculatedValueFormula": "sum({{RelatedTimesheets_Total}})", "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "Definition": { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "2885c6b7-2f68-4c63-973e-3c5ec6af6304", "IsRequired": false, "IsSystemField": false, "Metadata": { "DecimalPlaces": -1, "MaxValue": null, "MinValue": null, "TypeName": "NumericFieldMetadata" }, "Name": "TotalHours", "Title": "TotalHours", "Type": 1 }, "FieldDefinitionName": "TotalHours", "HasCalculatedValue": true, "IsHidden": false, "IsTitleSyncedWithDefinition": false, "LabelPosition": 2, "LabelTooltip": "", "LabelWidth": 100, "Properties": { "Placeholder": "", "TypeName": "NumberFieldProperties" }, "State": 3, "Title": "Total hours", "LabelFont": null, "BodyColor": null, "ThemeInherited": true, "PrintMode": 0, "VirtualFieldType": null }, { "CalculatedValueFormula": "", "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "Definition": { "DefaultValue": "", "EnforceUniqueValues": false, "Id": "cdae0a1c-9b1a-479b-9f07-facb2fbe817f", "IsRequired": false, "IsSystemField": true, "Metadata": { "MaxLength": 255, "TypeName": "TextFieldMetadata" }, "Name": "SintelFormsStatus", "Title": "SintelFormsStatus", "Type": 9 }, "FieldDefinitionName": "SintelFormsStatus", "HasCalculatedValue": false, "IsHidden": false, "IsTitleSyncedWithDefinition": true, "LabelPosition": 0, "LabelTooltip": "", "LabelWidth": 100, "Properties": { "Placeholder": "", "TypeName": "TextFieldProperties" }, "State": 3, "Title": "SintelFormsStatus", "LabelFont": null, "BodyColor": null, "ThemeInherited": true, "PrintMode": 0, "VirtualFieldType": null }, { "CalculatedValueFormula": "", "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "Definition": { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "1d22ea11-1e32-424e-89ab-9fedbadb6ce1", "IsRequired": false, "IsSystemField": true, "Metadata": { "DecimalPlaces": 0, "MaxValue": null, "MinValue": null, "TypeName": "NumericFieldMetadata" }, "Name": "ID", "Title": "ID", "Type": 1 }, "FieldDefinitionName": "ID", "HasCalculatedValue": false, "IsHidden": false, "IsTitleSyncedWithDefinition": true, "LabelPosition": 0, "LabelTooltip": "", "LabelWidth": 100, "Properties": { "Placeholder": "", "TypeName": "NumberFieldProperties" }, "State": 3, "Title": "ID", "LabelFont": null, "BodyColor": null, "ThemeInherited": true, "PrintMode": 0, "VirtualFieldType": null }, { "CalculatedValueFormula": "", "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "Definition": { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "28cf69c5-fa48-462a-b5cd-27b6f9d2bd5f", "IsRequired": false, "IsSystemField": true, "Metadata": { "DisplayType": 1, "TypeName": "DateTimeFieldMetadata" }, "Name": "Modified", "Title": "Modified", "Type": 4 }, "FieldDefinitionName": "Modified", "HasCalculatedValue": false, "IsHidden": false, "IsTitleSyncedWithDefinition": true, "LabelPosition": 0, "LabelTooltip": "", "LabelWidth": 100, "Properties": { "Placeholder": "", "TypeName": "DateTimeFieldProperties" }, "State": 3, "Title": "Modified", "LabelFont": null, "BodyColor": null, "ThemeInherited": true, "PrintMode": 0, "VirtualFieldType": null }, { "CalculatedValueFormula": "", "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "Definition": { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "8c06beca-0777-48f7-91c7-6da68bc07b69", "IsRequired": false, "IsSystemField": true, "Metadata": { "DisplayType": 1, "TypeName": "DateTimeFieldMetadata" }, "Name": "Created", "Title": "Created", "Type": 4 }, "FieldDefinitionName": "Created", "HasCalculatedValue": false, "IsHidden": false, "IsTitleSyncedWithDefinition": true, "LabelPosition": 0, "LabelTooltip": "", "LabelWidth": 100, "Properties": { "Placeholder": "", "TypeName": "DateTimeFieldProperties" }, "State": 3, "Title": "Created", "LabelFont": null, "BodyColor": null, "ThemeInherited": true, "PrintMode": 0, "VirtualFieldType": null }, { "CalculatedValueFormula": "", "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "Definition": { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "1df5e554-ec7e-46a6-901d-d85a3881cb18", "IsRequired": false, "IsSystemField": true, "Metadata": { "SharePointGroupId": 0, "AllowMultipleValues": false, "SelectionMode": 0, "TypeName": "UserFieldMetadata" }, "Name": "Author", "Title": "Created By", "Type": 3 }, "FieldDefinitionName": "Author", "HasCalculatedValue": false, "IsHidden": false, "IsTitleSyncedWithDefinition": true, "LabelPosition": 0, "LabelTooltip": "", "LabelWidth": 100, "Properties": { "Placeholder": "", "TypeName": "UserFieldProperties" }, "State": 3, "Title": "Created By", "LabelFont": null, "BodyColor": null, "ThemeInherited": true, "PrintMode": 0, "VirtualFieldType": null }, { "CalculatedValueFormula": "", "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "Definition": { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "d31655d1-1d5b-4511-95a1-7a09e9b75bf2", "IsRequired": false, "IsSystemField": true, "Metadata": { "SharePointGroupId": 0, "AllowMultipleValues": false, "SelectionMode": 0, "TypeName": "UserFieldMetadata" }, "Name": "Editor", "Title": "Modified By", "Type": 3 }, "FieldDefinitionName": "Editor", "HasCalculatedValue": false, "IsHidden": false, "IsTitleSyncedWithDefinition": true, "LabelPosition": 0, "LabelTooltip": "", "LabelWidth": 100, "Properties": { "Placeholder": "", "TypeName": "UserFieldProperties" }, "State": 3, "Title": "Modified By", "LabelFont": null, "BodyColor": null, "ThemeInherited": true, "PrintMode": 0, "VirtualFieldType": null }, { "CalculatedValueFormula": "", "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "Definition": { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "67df98f4-9dec-48ff-a553-29bece9c5bf4", "IsRequired": false, "IsSystemField": true, "Metadata": null, "Name": "Attachments", "Title": "Attachments", "Type": 13 }, "FieldDefinitionName": "Attachments", "HasCalculatedValue": false, "IsHidden": false, "IsTitleSyncedWithDefinition": true, "LabelPosition": 0, "LabelTooltip": "", "LabelWidth": 100, "Properties": null, "State": 3, "Title": "Attachments", "LabelFont": null, "BodyColor": null, "ThemeInherited": true, "PrintMode": 0, "VirtualFieldType": null }, { "CalculatedValueFormula": null, "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "Definition": { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "3aa4eb7f-e90d-4760-9f45-a71fe3dc52ed", "IsRequired": false, "IsSystemField": false, "Metadata": { "Fields": [ { "DefaultValue": "", "EnforceUniqueValues": false, "Id": "fa564e0f-0c70-4ab9-b863-0177e6ddd247", "IsRequired": false, "IsSystemField": false, "Metadata": { "MaxLength": 255, "TypeName": "TextFieldMetadata" }, "Name": "Title", "Title": "Title", "Type": 9 }, { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "f95e646c-4ce6-48c7-b233-5df7ff454483", "IsRequired": false, "IsSystemField": false, "Metadata": { "DecimalPlaces": -1, "MaxValue": null, "MinValue": 0.0, "TypeName": "NumericFieldMetadata" }, "Name": "Mon", "Title": "Mon", "Type": 1 }, { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "c5772f1d-e268-41fd-ae0e-480319d31d92", "IsRequired": false, "IsSystemField": false, "Metadata": { "DecimalPlaces": -1, "MaxValue": null, "MinValue": 0.0, "TypeName": "NumericFieldMetadata" }, "Name": "Tue", "Title": "Tue", "Type": 1 }, { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "b04a0bed-926f-42ed-9465-2fa186bcd35d", "IsRequired": false, "IsSystemField": false, "Metadata": { "DecimalPlaces": -1, "MaxValue": null, "MinValue": 0.0, "TypeName": "NumericFieldMetadata" }, "Name": "Wed", "Title": "Wed", "Type": 1 }, { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "bc588a13-80e9-44df-87f3-4695c1b6647b", "IsRequired": false, "IsSystemField": false, "Metadata": { "DecimalPlaces": -1, "MaxValue": null, "MinValue": 0.0, "TypeName": "NumericFieldMetadata" }, "Name": "Thu", "Title": "Thu", "Type": 1 }, { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "d68ecda1-9ca3-4b67-b933-c242819ab0fd", "IsRequired": false, "IsSystemField": false, "Metadata": { "DecimalPlaces": -1, "MaxValue": null, "MinValue": 0.0, "TypeName": "NumericFieldMetadata" }, "Name": "Fri", "Title": "Fri", "Type": 1 }, { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "055b6998-1c53-4c68-ab26-132f719552c5", "IsRequired": false, "IsSystemField": false, "Metadata": { "DecimalPlaces": -1, "MaxValue": null, "MinValue": 0.0, "TypeName": "NumericFieldMetadata" }, "Name": "Sat", "Title": "Sat", "Type": 1 }, { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "71d18a9f-7b9b-470b-8c6a-f58195949778", "IsRequired": false, "IsSystemField": false, "Metadata": { "DecimalPlaces": -1, "MaxValue": null, "MinValue": 0.0, "TypeName": "NumericFieldMetadata" }, "Name": "Sun", "Title": "Sun", "Type": 1 }, { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "511e5baa-9b56-4b68-85ee-059f2c5f5152", "IsRequired": false, "IsSystemField": false, "Metadata": { "DecimalPlaces": -1, "MaxValue": null, "MinValue": null, "TypeName": "NumericFieldMetadata" }, "Name": "Total", "Title": "Total", "Type": 1 }, { "DefaultValue": "", "EnforceUniqueValues": false, "Id": "eefc4a4a-0045-4f6a-9eef-7bffdf2fe52a", "IsRequired": false, "IsSystemField": true, "Metadata": { "MaxLength": 255, "TypeName": "TextFieldMetadata" }, "Name": "SintelFormsStatus", "Title": "SintelFormsStatus", "Type": 9 }, { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "1d22ea11-1e32-424e-89ab-9fedbadb6ce1", "IsRequired": false, "IsSystemField": true, "Metadata": { "DecimalPlaces": 0, "MaxValue": null, "MinValue": null, "TypeName": "NumericFieldMetadata" }, "Name": "ID", "Title": "ID", "Type": 1 }, { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "28cf69c5-fa48-462a-b5cd-27b6f9d2bd5f", "IsRequired": false, "IsSystemField": true, "Metadata": { "DisplayType": 1, "TypeName": "DateTimeFieldMetadata" }, "Name": "Modified", "Title": "Modified", "Type": 4 }, { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "8c06beca-0777-48f7-91c7-6da68bc07b69", "IsRequired": false, "IsSystemField": true, "Metadata": { "DisplayType": 1, "TypeName": "DateTimeFieldMetadata" }, "Name": "Created", "Title": "Created", "Type": 4 }, { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "1df5e554-ec7e-46a6-901d-d85a3881cb18", "IsRequired": false, "IsSystemField": true, "Metadata": { "SharePointGroupId": 0, "AllowMultipleValues": false, "SelectionMode": 0, "TypeName": "UserFieldMetadata" }, "Name": "Author", "Title": "Created By", "Type": 3 }, { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "d31655d1-1d5b-4511-95a1-7a09e9b75bf2", "IsRequired": false, "IsSystemField": true, "Metadata": { "SharePointGroupId": 0, "AllowMultipleValues": false, "SelectionMode": 0, "TypeName": "UserFieldMetadata" }, "Name": "Editor", "Title": "Modified By", "Type": 3 }, { "DefaultValue": null, "EnforceUniqueValues": false, "Id": "67df98f4-9dec-48ff-a553-29bece9c5bf4", "IsRequired": false, "IsSystemField": true, "Metadata": null, "Name": "Attachments", "Title": "Attachments", "Type": 13 } ], "LinkedListId": "3aa4eb7f-e90d-4760-9f45-a71fe3dc52ed", "LookupFieldId": "dd3aed1a-424b-4a31-8442-36185a6a145b", "LookupFieldName": "Submission", "Name": "RelatedTimesheets", "Title": "RelatedTimesheets", "TypeName": "LinkedListFieldMetadata" }, "Name": "3aa4eb7f-e90d-4760-9f45-a71fe3dc52ed", "Title": "RelatedTimesheets", "Type": 0 }, "FieldDefinitionName": "3aa4eb7f-e90d-4760-9f45-a71fe3dc52ed", "HasCalculatedValue": false, "IsHidden": false, "IsTitleSyncedWithDefinition": false, "LabelPosition": 4, "LabelTooltip": "", "LabelWidth": 100, "Properties": { "Columns": [ { "Width": 200, "Title": "Title", "Name": "Title", "IsVisible": false, "HasCalculatedValue": false, "CalculatedValueFormula": null, "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "IsAdditionalColumn": false, "State": 3, "Properties": { "Placeholder": "", "TypeName": "TextFieldProperties" } }, { "Width": 200, "Title": "Mon", "Name": "Mon", "IsVisible": true, "HasCalculatedValue": false, "CalculatedValueFormula": null, "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "IsAdditionalColumn": false, "State": 3, "Properties": { "Placeholder": "", "TypeName": "NumberFieldProperties" } }, { "Width": 200, "Title": "Tue", "Name": "Tue", "IsVisible": true, "HasCalculatedValue": false, "CalculatedValueFormula": null, "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "IsAdditionalColumn": false, "State": 3, "Properties": { "Placeholder": "", "TypeName": "NumberFieldProperties" } }, { "Width": 200, "Title": "Wed", "Name": "Wed", "IsVisible": true, "HasCalculatedValue": false, "CalculatedValueFormula": null, "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "IsAdditionalColumn": false, "State": 3, "Properties": { "Placeholder": "", "TypeName": "NumberFieldProperties" } }, { "Width": 200, "Title": "Thu", "Name": "Thu", "IsVisible": true, "HasCalculatedValue": false, "CalculatedValueFormula": null, "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "IsAdditionalColumn": false, "State": 3, "Properties": { "Placeholder": "", "TypeName": "NumberFieldProperties" } }, { "Width": 200, "Title": "Fri", "Name": "Fri", "IsVisible": true, "HasCalculatedValue": false, "CalculatedValueFormula": null, "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "IsAdditionalColumn": false, "State": 3, "Properties": { "Placeholder": "", "TypeName": "NumberFieldProperties" } }, { "Width": 200, "Title": "Sat", "Name": "Sat", "IsVisible": true, "HasCalculatedValue": false, "CalculatedValueFormula": null, "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "IsAdditionalColumn": false, "State": 3, "Properties": { "Placeholder": "", "TypeName": "NumberFieldProperties" } }, { "Width": 200, "Title": "Sun", "Name": "Sun", "IsVisible": true, "HasCalculatedValue": false, "CalculatedValueFormula": null, "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "IsAdditionalColumn": false, "State": 3, "Properties": { "Placeholder": "", "TypeName": "NumberFieldProperties" } }, { "Width": 200, "Title": "Row total", "Name": "Total", "IsVisible": true, "HasCalculatedValue": true, "CalculatedValueFormula": "Number({{RelatedTimesheets_Mon}} || 0) + Number({{RelatedTimesheets_Tue}} || 0) + Number({{RelatedTimesheets_Wed}} || 0) + Number({{RelatedTimesheets_Thu}} || 0) + Number({{RelatedTimesheets_Fri}} \n|| 0) + Number({{RelatedTimesheets_Sat}} || 0) + \nNumber({{RelatedTimesheets_Sun}}\n|| 0)", "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "IsAdditionalColumn": false, "State": 3, "Properties": { "Placeholder": "", "TypeName": "NumberFieldProperties" } }, { "Width": 200, "Title": "ID", "Name": "ID", "IsVisible": false, "HasCalculatedValue": false, "CalculatedValueFormula": "", "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "IsAdditionalColumn": false, "State": 3, "Properties": { "Placeholder": "", "TypeName": "NumberFieldProperties" } }, { "Width": 200, "Title": "Modified", "Name": "Modified", "IsVisible": false, "HasCalculatedValue": false, "CalculatedValueFormula": "", "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "IsAdditionalColumn": false, "State": 3, "Properties": { "Placeholder": "", "TypeName": "DateTimeFieldProperties" } }, { "Width": 200, "Title": "Created", "Name": "Created", "IsVisible": false, "HasCalculatedValue": false, "CalculatedValueFormula": "", "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "IsAdditionalColumn": false, "State": 3, "Properties": { "Placeholder": "", "TypeName": "DateTimeFieldProperties" } }, { "Width": 200, "Title": "Created By", "Name": "Author", "IsVisible": false, "HasCalculatedValue": false, "CalculatedValueFormula": "", "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "IsAdditionalColumn": false, "State": 3, "Properties": { "Placeholder": "", "TypeName": "UserFieldProperties" } }, { "Width": 200, "Title": "Modified By", "Name": "Editor", "IsVisible": false, "HasCalculatedValue": false, "CalculatedValueFormula": "", "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "IsAdditionalColumn": false, "State": 3, "Properties": { "Placeholder": "", "TypeName": "UserFieldProperties" } }, { "Width": 100, "Title": "Attachments", "Name": "Attachments", "IsVisible": false, "HasCalculatedValue": false, "CalculatedValueFormula": "", "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "IsAdditionalColumn": false, "State": 3, "Properties": null }, { "Width": 200, "Title": "SintelFormsStatus", "Name": "SintelFormsStatus", "IsVisible": false, "HasCalculatedValue": false, "CalculatedValueFormula": "", "DefaultValue": { "CustomDefaultValue": "", "DefaultValueType": 0 }, "IsAdditionalColumn": false, "State": 3, "Properties": { "Placeholder": "", "TypeName": "TextFieldProperties" } } ], "FitToWidth": true, "SortByFieldName": "ID", "SortOrder": 0, "EditionMode": 0, "ManageInPopup": false, "AllowInlineEdition": true, "PreventAddingItems": false, "PreventEditingItems": false, "PreventDeletingItems": false, "ItemActionButtonsPosition": 0, "TypeName": "LinkedListFormFieldProperties" }, "State": 3, "Title": "Time", "LabelFont": { "FontType": "Segoe UI", "FontSize": 14, "FontColor": "#333" }, "BodyColor": "#dde1dd", "ThemeInherited": true, "PrintMode": 0, "VirtualFieldType": null } ], "FormSettings": { "AnonymousAccessSettings": { "AllowEdition": false, "AllowSendingInvitationEmails": true, "AllowSharing": false, "EditLinkMailNotificationSettings": { "Body": "Thank you for submitting your form using Sintel Forms.\n\nYou can see/edit it here.", "CcUsers": [], "BccUsers": [], "Subject": "Thank you for your submission!", "ToUsers": [] }, "InvitationMailSettings": { "Body": "You have been granted access to a form.\n\nYou can see/edit it here.", "CcUsers": [], "BccUsers": [], "Subject": "A form has been shared with you", "ToUsers": [] }, "IsAnonymousAccessEnabled": true, "PeoplePickersVisibilityInCreateMode": 0, "PeoplePickersVisibilityInEditAndViewModes": 0, "PreventSendingSubmissionEmails": false, "RedirectUrl": "", "ShowCaptcha": true, "ShowWorkflowHistoryWidgets": false }, "AreButtonsDisplayedOnTheBottom": false, "AreConversationsEnabled": false, "AreFormsEnabled": true, "BottomButtonsAlignment": 0, "CloseRedirectSettings": { "CustomURLText": "", "RedirectType": 0 }, "ConversationsMentionMailSettings": { "Body": "{{[commentAuthor]}} mentioned you in a comment:\n\n{{[comment]}}\n\nYou can see the comment here.", "CcUsers": [], "BccUsers": [], "Subject": "New comment for you", "ToUsers": [] }, "CustomSaveScript": null, "DoesWorkflowHistoryHasNewUserColumn": false, "ExistingItemConfirmationScreenSettings": { "ScreenContent": "
Thank you for taking the time to submit your suggestion we really appreciate it!\r\nFor reference your Submission ID is {{ID}}\r\n
\r\nBuilt with by Sintel", "ShowConfirmationScreen": false }, "PDFExportType": 0, "PDFPageNumbering": 0, "SaveRedirectSettings": { "CustomURLText": "", "RedirectType": 0 }, "SettingsListId": "b053d36d-60c1-45a3-94ef-f9b213634ddc", "SettingsListItemId": 1, "ShouldSendMailForMentions": true, "StripePaymentsSettings": { "AccountId": "", "TestModeEnabled": true }, "ThemeAndStylingSettings": { "MaximumFormWidth": 0, "Theme": "Custom", "CustomStyling": "", "SectionTitleFont": { "FontType": "Sagoe UI", "FontSize": 22, "FontColor": "#333" }, "SectionDescriptionFont": { "FontType": "Sagoe UI", "FontSize": 14, "FontColor": "#333" }, "SectionIcon": { "IconSize": 4, "IconColor": "#000000", "IconAlignment": 0 }, "FieldLabelsFont": { "FontType": "Sagoe UI", "FontSize": 14, "FontColor": "#333" }, "TabTextFont": { "FontType": "Segoe UI", "FontSize": 14, "FontColor": "#333" }, "TabIcon": { "IconSize": 1, "IconColor": "#333", "IconAlignment": 0 }, "PageBackgroundColor": "#EEEEED", "FormBackgroundColor": "#FFFFFF", "SectionHeaderColor": "#FFFFFF", "SectionBodyColor": "#FFFFFF", "TabBackgroundColor": "#FFFFFF", "ActiveTabTextColor": "#333", "ActiveTabBackgroundColor": "#FFFFFF", "ActiveTabIconColor": "#333", "ActiveTabUnderlineColor": "#0078D4", "SaveButton": { "BackgroundColor": "#0078d7", "LabelColor": "#ffffff", "HoverBackgroundColor": "#106ebe", "HoverLabelColor": "#ffffff" }, "TopPanelButton": { "BackgroundColor": "#333333", "LabelColor": "#ffffff", "HoverBackgroundColor": "#eaeaea", "HoverLabelColor": "#212121" }, "BottomPanelButton": { "BackgroundColor": "#f4f4f4", "LabelColor": "#333333", "HoverBackgroundColor": "#eaeaea", "HoverLabelColor": "#212121" } }, "UnsavedChangesPromptEnabled": false }, "LayoutString": "{\"sections\":[{\"id\":\"963ad4d3-4a05-11e8-b299-7fe59d64c962\",\"typeName\":\"Section\",\"title\":\"Timesheets\",\"isTitleVisible\":true,\"headerBackgroundColor\":\"#50e3c2\",\"state\":0,\"isHidden\":false,\"htmlHeader\":\"\",\"tooltip\":\"\",\"detailsText\":\"All timesheet submissions will be reviewed and approved by your manager.\",\"printMode\":\"Continuous\",\"columns\":[{\"rows\":[],\"id\":\"963ad4d5-4a05-11e8-b299-7fe59d64c962\",\"size\":12}],\"themeInherited\":false,\"titleProperties\":{\"fontType\":\"Segoe UI\",\"fontColor\":\"#ffffff\",\"fontSize\":22},\"contentProperties\":{\"fontProperties\":{\"fontType\":\"Segoe UI\",\"fontColor\":\"#333\",\"fontSize\":14},\"backgroundColor\":\"#50e3c2\"},\"detailsTextProperties\":{\"fontType\":\"Segoe UI\",\"fontColor\":\"#ffffff\",\"fontSize\":18},\"iconProperties\":{\"iconType\":\" fal fa-alarm-clock\",\"iconSize\":4,\"iconColor\":\"#ffffff\",\"iconAlignment\":0}},{\"id\":\"b92054d0-3e5b-11e8-a94f-09543d85bcc4\",\"typeName\":\"Section\",\"title\":\"Your Details\",\"isTitleVisible\":true,\"headerBackgroundColor\":\"#dde1dd\",\"state\":0,\"isHidden\":false,\"htmlHeader\":\"\",\"tooltip\":\"\",\"detailsText\":\"\",\"printMode\":\"Continuous\",\"columns\":[{\"rows\":[\"Submitter\",\"SubmitterEmail\",\"Country\",\"Date\"],\"id\":\"b92054d1-3e5b-11e8-a94f-09543d85bcc4\",\"size\":6},{\"rows\":[\"SubmitterDepartment\",\"Manager\",\"City\",\"\"],\"id\":\"b92054d2-3e5b-11e8-a94f-09543d85bcc4\",\"size\":6}],\"themeInherited\":false,\"titleProperties\":{\"fontType\":\"Segoe UI\",\"fontColor\":\"#656262\",\"fontSize\":22},\"contentProperties\":{\"fontProperties\":{\"fontType\":\"Segoe UI\",\"fontColor\":\"#333\",\"fontSize\":14},\"backgroundColor\":\"#dde1dd\"},\"detailsTextProperties\":{\"fontType\":\"Segoe UI\",\"fontColor\":\"#333\",\"fontSize\":14},\"iconProperties\":{\"iconType\":\" fal fa-user\",\"iconSize\":2,\"iconColor\":\"#656262\",\"iconAlignment\":0}},{\"id\":\"c3854fc3-3e5b-11e8-a94f-09543d85bcc4\",\"typeName\":\"Section\",\"title\":\"Time Entries\",\"isTitleVisible\":true,\"headerBackgroundColor\":\"#dde1dd\",\"state\":0,\"isHidden\":false,\"htmlHeader\":\"\",\"tooltip\":\"\",\"detailsText\":\"\",\"printMode\":\"Continuous\",\"columns\":[{\"rows\":[\"3aa4eb7f-e90d-4760-9f45-a71fe3dc52ed\"],\"id\":\"c3854fc4-3e5b-11e8-a94f-09543d85bcc4\",\"size\":12}],\"themeInherited\":false,\"titleProperties\":{\"fontType\":\"Segoe UI\",\"fontColor\":\"#656262\",\"fontSize\":22},\"contentProperties\":{\"fontProperties\":{\"fontType\":\"Segoe UI\",\"fontColor\":\"#333\",\"fontSize\":14},\"backgroundColor\":\"#dde1dd\"},\"detailsTextProperties\":{\"fontType\":\"Segoe UI\",\"fontColor\":\"#333333\",\"fontSize\":14},\"iconProperties\":{\"iconType\":\" fal fa-hourglass\",\"iconSize\":2,\"iconColor\":\"#656262\",\"iconAlignment\":0}},{\"id\":\"79248bc0-d91c-11e8-829f-19441b0c3909\",\"typeName\":\"Section\",\"title\":\"New Section\",\"isTitleVisible\":false,\"headerBackgroundColor\":\"#dde1dd\",\"state\":0,\"isHidden\":false,\"htmlHeader\":\"\",\"tooltip\":\"\",\"detailsText\":\"\",\"printMode\":\"Continuous\",\"columns\":[{\"rows\":[\"\"],\"id\":\"9c4d8d94-d91c-11e8-829f-19441b0c3909\",\"size\":3},{\"rows\":[\"\"],\"id\":\"79248bc1-d91c-11e8-829f-19441b0c3909\",\"size\":3},{\"rows\":[\"\"],\"id\":\"8178a3e5-d923-11e8-9ba5-77c62db13e38\",\"size\":3},{\"rows\":[\"TotalHours\"],\"id\":\"82300d06-d923-11e8-9ba5-77c62db13e38\",\"size\":3}],\"themeInherited\":false,\"titleProperties\":{\"fontType\":\"Segoe UI\",\"fontColor\":\"#656262\",\"fontSize\":22},\"contentProperties\":{\"fontProperties\":{\"fontType\":\"Segoe UI\",\"fontColor\":\"#333\",\"fontSize\":14},\"backgroundColor\":\"#dde1dd\"},\"detailsTextProperties\":{\"fontType\":\"Segoe UI\",\"fontColor\":\"#333333\",\"fontSize\":14},\"iconProperties\":{\"iconType\":\"\",\"iconSize\":4,\"iconColor\":\"#656262\",\"iconAlignment\":0}}]}", "Lists": [ { "DoesListAllowFolders": false, "DefaultViewQuery": "