Wrap Signoff
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-the-wrapsignoff-widget/
Wrap signoff control replace conventional paper signatures and integrates with user roles. The control will be available for signoff only when the signoff enable cell is true. XLW's SIGNOFF() function is inserted into the cell.
REMEMBER: SIGNOFF() functions can be fully debugged within Excel. Set Excel's debug user role using 'About XLW Subdomain' button. When the enabling cell becomes enabled Excel assumes that a username and signature has been entered and the cell value becomes 'Signed'. You may also wish to use XLW's SIGNED() function to check if a signature has been made. E.g. ='SIGNED(G6) assumes G6 is the cell reference of a SIGNOFF() and returns TRUE it is signed or FALSE if not.
The SIGNOFF Wizard insert a =SIGNOFF() function in the spreadsheet. It cannot contain formulas as it will hardcoded in the server to enable server side checks for security reasons. In this example a user with the role 'Owner' can create a signature by entering his username and password. No role is assigned for unsigning a signature. The wrap signoff form will have a username dropdown list which will show all usernames able to sign and a password will be required. On signing the form an email alert will be sent to 'AdminTenant'. This appears in an excel formula:
=SIGNOFF(F9,"Owner","",TRUE,FALSE,TRUE,"","AdminTenant","")