To load record creation dates in an application; Add =SpreadsheetWebRecordInfo(”EntryDate”) named range to your workbook. Go to User Interface module. Add a textbox control and bind the named range to it Finally, publish your...
To load the email address of active users in an application; Add =SpreadsheetWebUserInfo(”EmailAddress”) named range to your workbook. Go to User Interface module. Add a textbox control and bind the named range to it Finally, publish your...
To hide pages for specific users; Add =SpreadsheetWebUserInfo(”UserName”) named range to your workbook. Add an If function. We added =IFERROR(IF(C1=”joedoe@pagos.com”;TRUE;FALSE);TRUE) to disable a page for ”joedoe@pagos.com” user. Go to Pages...
To hide pages for specific users; Add =SpreadsheetWebUserInfo(”UserName”) named range to your workbook. Add an If function. We added =IFERROR(IF(C1=”joedoe@pagos.com”;TRUE;FALSE);TRUE) to hide a control for ”joedoe@pagos.com” user. Go to User...
To change the font family in Stylesheets; Open Designer Interface, Go to ‘Stylesheet’ module. Add a new stylesheet. Add following CSS code; font-family: “Font Name”, sans-serif; Replace “Font Name” with the name of the font you want to use....
To set defaults in Dropdown controls; Open Designer interface, Click on the dropdown control, Select the desired default value from the ‘Default Value’ dropdown located on the right side of the...
To configure short and long dates in Calendar controls; Open Designer interface, Click on the calendar control, Choose short or long date options from the ‘DateTime Format’ dropdown located on the right side of the...
To set defaults in Textbox controls; Open Designer interface, Click on a textbox control. Enter a default value for the ‘Default Value’ field located on the right side of the...
To format data in Textbox controls; Open Designer interface, Click on a textbox control. Choose desired option from ‘Text Mask’ dropdown located on the right side of the...
To make cells not editable in Grid controls; Open Designer Interface, Go to the ‘Using Interface’ module. Select the input grid. Check the ‘Use Metadata Formatting’ and ‘Disable Formula-based Cells’...
