Calendar and submit button

[Frank Thompson]

Hello All,

I am trying to get a form to auto fill the date in a calendar. I cannot share it because it is locked but I can show you the code for  the calendar question before entering date:

<input type="text" id="DatePicker0-label" role="combobox" aria-expanded="true" aria-haspopup="dialog" placeholder="Please input date (M/d/yyyy)" aria-labelledby="QuestionId_r774071368a0b4276a292d2c2edc23fee QuestionInfo_r774071368a0b4276a292d2c2edc23fee" class="ms-TextField-field field-216" aria-label="Date picker" aria-describedby="TextFieldDescription3" aria-invalid="false" aria-controls="DatePicker-Callout1">

and after entering date:

<input type="text" id="DatePicker0-label" role="combobox" aria-expanded="false" aria-haspopup="dialog" placeholder="Please input date (M/d/yyyy)" aria-labelledby="QuestionId_r774071368a0b4276a292d2c2edc23fee QuestionInfo_r774071368a0b4276a292d2c2edc23fee" class="ms-TextField-field field-216" aria-label="Date picker" aria-describedby="TextFieldDescription3" aria-invalid="false">

I followed the basic calendar advice but it has not worked.

I am also trying to click the submit button at the end and I've tried some things from the javascript tutorial but to no avail. Here is the script from inspecting the button:

<button data-automation-id="submitButton" class="css-170">Submit</button>

Any and all help is most appreciated!!!

[Autofill Extension]

Hi Bob,

Try this rule for date field...

Type = Text

Name = ^DatePicker0-label$

Value = 3/29/2023

To click submit button, add this JS rule...

Type = JavaScript

Value = 

const submitBtn = document.querySelector('[data-automation-id="submitButton"]');

if (submitBtn) submitBtn.click();

To add a delay, use this code instead for Value:

setTimeout(() => {

  const submitBtn = document.querySelector('[data-automation-id="submitButton"]');

  if (submitBtn) submitBtn.click();

}, 1000); // 1s delay

Tom

[Frank Thompson]

Hey thanks for the reply and help!

I tried both and neither worked.

For the calendar I realized when you first click on the text area a calendar pops open and you cannot type, only click on the date. You have to click on the text area again to be able to type the date out manually. So it requires two clicks into the text box to be able to type if that is what is messing up the code. Also I am not sure if it should be in overwrite mode? Picture below.

I also tried the JS code exactly as you wrote for the button and it did not work.:

const submitBtn = document.querySelector('[data-automation-id="submitButton"]');

if (submitBtn) submitBtn.click();

Any other suggestions would help, especially with the calendar as it is the biggest roadblock to getting the form filled out quickly, and would be appreciated!

[Autofill Extension]

Sorry, it's hard for me to troubleshoot further without have access to the actual page -- do you have a URL I can use for testing? This doesn't look like a normal form -- it's definitely using JavaScript in the background which is conflicting with the autofilling.

[Frank Thompson]

Here is the link but I dont think youll be able to access it.

https://forms.office.com/Pages/ResponsePage.aspx?id=BKaW0ZPZKECQ3-Ij1oEm0j0jFcHDepFEsPILnF6rdxlUMEtBUjBQTk1OR0VYUFJGOUxMOUlXQUlZUC4u

[Autofill Extension]

Hi, this rule worked for me just now:

Type = Text

Name = ^Please input date \(M/d/yyyy\)$

Value = 4/4/2023

[Frank Thompson]

That still did not work. What mode did you set it in? Also I still can not get the submit button to work.

[Autofill Extension]

It worked on the preview form, but not the live form. In order to make it work on the live form, I had to use a JS rule. Replace the previous rule with this rule:

Type = JavaScript

Value =

setTimeout(() => {
  const dob = document.querySelector('[placeholder="Please input date (M/d/yyyy)"]');
  if (dob) {
    dob.value = '4/4/2023';
    dob.dispatchEvent(new Event('input'));
  }
}, 0); // Replace 0 with a larger number if it's unreliable

Hope the above works for you.

FYI I won't be available until April 16th.

[Autofill Extension]

P.S. Don't forget to set a site filter...

Site = forms.office.com