Automated Sign-in Sheet - Revision history

Kyle.Madsen at 17:12, 15 March 2023

2023-03-15T17:12:50Z

← Older revision		Revision as of 17:12, 15 March 2023
Line 2:		Line 2:
	As of right now, only the first page has a selectable date. The next 13 pages will always run from tomorrow to 2 weeks from the current date. Still a work in progress.		As of right now, only the first page has a selectable date. The next 13 pages will always run from tomorrow to 2 weeks from the current date. Still a work in progress.
	Current version is [https://hu.sharepoint.com/:b:/r/sites/FAS-CES/Shared%20Documents/CES-Documents/Administration/Automation%20Test.pdf?csf=1&web=1&e=Xcb2sT here.]		Current version is [https://hu.sharepoint.com/:b:/r/sites/FAS-CES/Shared%20Documents/CES-Documents/Administration/Automation%20Test.pdf?csf=1&web=1&e=Xcb2sT here.]

			This method puts the code on the entire document, instead of just the field that needs editing. This is less elegant but works. The reason is that Adobe has not patched a bug that deletes relevant code from the validation box in date fields randomly.
	===Steps to create sheet===		===Steps to create sheet===
	<ol>		<ol>

Kyle.Madsen at 17:08, 15 March 2023

2023-03-15T17:08:27Z

← Older revision		Revision as of 17:08, 15 March 2023
Line 33:		Line 33:
	<li>In the '''Add an Action''' pane, select the trigger '''Page Open''' and the action '''Run a JavaScript'''. Click '''Add...'''.		<li>In the '''Add an Action''' pane, select the trigger '''Page Open''' and the action '''Run a JavaScript'''. Click '''Add...'''.
	<li>In the Actions pane, click on the "Run a JavaScript" line and click '''Edit'''.		<li>In the Actions pane, click on the "Run a JavaScript" line and click '''Edit'''.
	<li>Paste ~~this~~ text:		<li>Paste the text below. Referenced and edited from [https://community.adobe.com/t5/acrobat-discussions/adding-increasing-dates-to-fillable-pdf/td-p/11018767 here.]
	<dl><dd><pre>		<dl><dd><pre>
	var date = util.scand("dddd mmmm d, yyyy", event.value);		var date = util.scand("dddd mmmm d, yyyy", event.value);

Kyle.Madsen at 17:03, 15 March 2023

2023-03-15T17:03:54Z

← Older revision		Revision as of 17:03, 15 March 2023
Line 43:		Line 43:
	this.getField("Date"+i).value = util.printd("dddd mmmm d, yyyy", date);}}		this.getField("Date"+i).value = util.printd("dddd mmmm d, yyyy", date);}}
	</pre></dd></dl></li>		</pre></dd></dl></li>
			<li> Click OK then OK.
	</ol>		</ol>
	</ol>		</ol>
	<li> ~~Test Text~~		<li> The form is now ready to save. Pages 2-14 (Date1-13 fields) will generate from tomorrow to 13 days away. Page 1 (Day0) can be manually set to any date and printed individually, if needed.
			</ol>

Kyle.Madsen at 16:44, 15 March 2023

2023-03-15T16:44:57Z

← Older revision		Revision as of 16:44, 15 March 2023
Line 1:		Line 1:
	==Instructions for Automated Sign-in Sheet for printing consecutive dates==		==Instructions for Automated Sign-in Sheet for printing consecutive dates==
	As of right now, only the first page has a selectable date. The next 13 pages will always run from tomorrow to 2 weeks from the current date. Still a work in progress.		As of right now, only the first page has a selectable date. The next 13 pages will always run from tomorrow to 2 weeks from the current date. Still a work in progress.
	Current version is [~~here.~~ https://hu.sharepoint.com/:b:/r/sites/FAS-CES/Shared%20Documents/CES-Documents/Administration/Automation%20Test.pdf?csf=1&web=1&e=Xcb2sT]		Current version is [https://hu.sharepoint.com/:b:/r/sites/FAS-CES/Shared%20Documents/CES-Documents/Administration/Automation%20Test.pdf?csf=1&web=1&e=Xcb2sT here.]
	===Steps to create sheet===		===Steps to create sheet===
	<ol>		<ol>
Line 30:		Line 30:
	<li>Right click on the first page and select '''Page Properties'''.		<li>Right click on the first page and select '''Page Properties'''.
	<li>Select the second tab, '''Actions'''.		<li>Select the second tab, '''Actions'''.
	<ol>		<ol>
	<li>In the '''Add an Action''' pane, select the trigger '''Page Open''' and the action '''Run a JavaScript'''. Click '''Add...'''.		<li>In the '''Add an Action''' pane, select the trigger '''Page Open''' and the action '''Run a JavaScript'''. Click '''Add...'''.
	<li>In the Actions pane, click on the "Run a JavaScript" line and click '''Edit'''.		<li>In the Actions pane, click on the "Run a JavaScript" line and click '''Edit'''.
	<li>Paste this text:		<li>Paste this text:
	<dl><dd><pre>		<dl><dd><pre>
	var date = util.scand("dddd mmmm d, yyyy", event.value);		var date = util.scand("dddd mmmm d, yyyy", event.value);
	for( var i=1; i<=14; i++){		for( var i=1; i<=14; i++){
Line 42:		Line 42:
	date.setDate(date.getDate() +1);		date.setDate(date.getDate() +1);
	this.getField("Date"+i).value = util.printd("dddd mmmm d, yyyy", date);}}		this.getField("Date"+i).value = util.printd("dddd mmmm d, yyyy", date);}}
	</pre></dd></dl></li>		</pre></dd></dl></li>
	</ol>		</ol>
	</ol>		</ol>
	<li> Test Text		<li> Test Text

Kyle.Madsen: Created page with "==Instructions for Automated Sign-in Sheet for printing consecutive dates== As of right now, only the first page has a selectable date. The next 13 pages will always run from..."

2023-03-15T16:41:14Z

Created page with "==Instructions for Automated Sign-in Sheet for printing consecutive dates== As of right now, only the first page has a selectable date. The next 13 pages will always run from..."

New page

==Instructions for Automated Sign-in Sheet for printing consecutive dates==
As of right now, only the first page has a selectable date. The next 13 pages will always run from tomorrow to 2 weeks from the current date. Still a work in progress.
Current version is [here. https://hu.sharepoint.com/:b:/r/sites/FAS-CES/Shared%20Documents/CES-Documents/Administration/Automation%20Test.pdf?csf=1&web=1&e=Xcb2sT]
===Steps to create sheet===
<ol>
<li> Initial document was made in Microsoft Word, original [https://hu.sharepoint.com/:w:/r/sites/FAS-CES/Shared%20Documents/CES-IT/Automated%20Document%20Testing/Automation%20Test.docx?d=w8360631c440f4911a131d8ec03c00b58&csf=1&web=1&e=jPqp0x here.]
<li> Saved as PDF.
<li> Edit with Adobe Acrobat Pro. Using '''Edit PDF''' from the right hand sidebar, clean up any text and tables to fit to page. Remove date, as that field will be created later.
<li> On the right hand sidebar, select '''More Tools'''
<ol>
<li>Under '''Forms & Signatures''', select '''Prepare Form'''.
<li>In the new Prepare Form ribbon, select the calendar for '''Add a Date Field'''. Put the new field where the deleted date was.
<li>Right click on the date field and select '''Properties'''.
<ol>
<li>Select the '''Format''' tab.
<li>In the scroll window for formats, scroll to the bottom for custom. In the field below, enter: <code>dddd mmmm d, yyyy</code>
<li>This will set the date to the long form, with full day and month spelled out.
</ol>
</ol>
<li> On the right hand sidebar, select '''Organize Pages'''.
<ol>
<li>On the new screen, copy and paste the first page until there are 14 total pages. Click '''Close'''.
</ol>
<li> Return the the '''Prepare Form''' menu. Between the PDF and the right hand sidebar should be a new sidebar. The lower section will show each page with each date field beneath.
<ol>
<li>Rename the date fields. Page 1 Date Field should be named "Date0", Page 2 "Date1", etc.
</ol>
<li> On the left hand sidebar, select the top option '''Page Thumbnails'''.
<ol>
<li>Right click on the first page and select '''Page Properties'''.
<li>Select the second tab, '''Actions'''.
<ol>
<li>In the '''Add an Action''' pane, select the trigger '''Page Open''' and the action '''Run a JavaScript'''. Click '''Add...'''.
<li>In the Actions pane, click on the "Run a JavaScript" line and click '''Edit'''.
<li>Paste this text:
<dl><dd><pre>
var date = util.scand("dddd mmmm d, yyyy", event.value);
for( var i=1; i<=14; i++){
if(event.value == "")
this.getField("Date"+i).value = "";
else {
date.setDate(date.getDate() +1);
this.getField("Date"+i).value = util.printd("dddd mmmm d, yyyy", date);}}
</pre></dd></dl></li>
</ol>
</ol>
<li> Test Text