-
concat("T", substring-before(substring-after(now(), ":"), ":"), substring-after(substring-after(now(), ":"), ":"), substring-after(substring-after(today(), "-"), "-"))
-
It looks like instead of the form opening, the XML is opening? Is that what's happening? What happens if the user tries to open the form template for a new blank form?
-
The issue you'll have is that it sounds like you need everything where Status = In Progress OR Status = On Hold. The built in query fields in a list data connection can't do that - you could filter for everything where Status = In Progress, for example, or for everything where it is On Hold, but not both. You can just set the query field ...
-
Try this one. Save the file locally by right clicking the URL in the post heading and selecting the option to save locally. Right click the local file and select Design. I pasted a bunch of screenshots and info into the form itself to tell you what changes I made :)
-
Any chance I can see a copy of your form? You can attach it under the options button in a reply.
-
Set your submit to use rules - then make your first rule to send the email (using an email submit connection) and your second rule to submit the form to SharePoint. You can also close the form at this point if you like. Are you having trouble creating the email connection? Or can you be more specific about what you are having trouble with?
-
The today function just returns the date. You can test these things with calculated values. The syntax will be different for a condition - I didn't know that's what you were doing, and thought you'd be pasting this into the function editor for a rule. For a condition, change the first dropdown to "the expression" and use: ...
-
Oh, I'd probably use a translate formula and just turn the date into numbers: translate(today(), "-", "") > 20201204
-
Right - so that's the trouble with a repeating structure. But you are constrained by the limits of SharePoint - you can't have as many columns as they want. If you used a form that submits to SQL, you'd be ok - Or, I imagine some reporting tools could read the XML file data into a report that could be exported. Do you use on-prem or ...
-
Here's a sample form I had in my files - right click the linked file, save locally. Right click the saved file and select design, then you can preview. In this sample there is only one "answer" field, using option buttons, but you could easily extend that to add all 7 of your fields. I use default data to include rows by default, and ...