Pre-Completion of a Form from another sheet

Simon Wilcock

Hi

I've got a couple of sheets that work together. On the first, I enter the basic details and then send a request to a manager that has the link to a form on the second sheet with a number of fields pre-completed with the data from the first sheet. They then complete all the other required fields.

It works just as I want but I'm having issues with a date field I have added.

It works and sends the second form over with all the dates pre completed, including the date, but its putting the date in as DD/MM/YY and when the user submits, the error comes up that its not in correct DD/MM/YYYY format. They change it by clicking the date drop down and it works.

I've set the date field in both sheets to DD/MM/YYYY but can't seem to get it to work. Both fields are in the date format.

Its a big formula so I've extracted the date element here,

FORM LINK GOES HERE then SUBSTITUTE([Employee Name]@row, " ", "%20") + "&Effective%20Date=" + SUBSTITUTE([Effective Date]@row, " ", "%20")

Any ideas?

Thanks

Paul Newcome

Is there a reason you are going through this route instead of sending an Update Request?

Simon Wilcock

Yeah, I use the form so it visually looks much better for the end user. Forms look much more appealing than the update requests and you can use the forms logic functionality, etc.

Paul Newcome

Is the Effective Date column set as a date type column? Are you able to provide a screenshot of the data populating that column?