Service Help – EntryForm
The Sharperlight service offers a wide variety of presentation methods, each with its own set of parameters.
In this post, we will introduce the following method from among the various presentation methods available.
http://abcd.com/mdService1Rest/EntryForm/…
EntryForm
To see this information with your sharperlight service help
{sharperlight service url}/Help#EntryForm
{sharperlight service url}/Help#EntryForm
| productcode=[code] | MetaData Product code. e.g. productcode=ADVW |
| supercode=[value] | If the Product has a super field (optional) that is filtered before the Tables, then set it here. e.g. supercode=CompanyID |
| tablecode=[value] | The unique internal Table Code that the Entry Form is writing back too |
| editkey=[uniqueKey] |
Find and display the table record that matches the primary unique column or columns (Note this is not an identity column) If the table has multiple unique columns flaged as unique in the Datamodel then separate the values with a pipe separator character |
e.g.
e.g. Compound unique columns using | as a separator character |
| editid=[identityNo] |
The record identity number. This will be the database table row identity number e.g. http://abcd.com/mdService1Rest/EntryForm/?productcode=ADVW&tablecode=PurVen&editid=12004 |
| title=[text] | Change the default title e.g. &title=Timesheet To suppress the title set to blank &title= |
| titleAlign=[left|center|right] | Set both the title and descripton alignment e.g &titleAlign=right |
| titleFontSize=[n] | Override the default title font size e.g &titleFontSize=14 |
| description=[text] | Change the default description e.g. &description=Year to date To suppress the description set to blank &description= |
| descriptionFontSize=[n] | Override the default description font size e.g &descriptionFontSize=10 |
| labelAlign=[left|center|right] | Label description alignment e.g &labelAlign=right |
| customHTML=[group.code] |
Use the defined Custom CSS, Header and Footer sections in the specified Published Report and apply them to this entry form &customHTML=MyGroup.MyCode This is a good way to inject your own HTML, CSS Styling and Javascript into the Entry Form to do things like calculate running Totals and other custom logic |
| sval:code=[value] | Override the value to appear in the form for the specified field given it’s unique code defined in the Datamodel e.g &sval:AccCode=AB345&sval:Amount=1000.12 |
| lock=[code+code2+code(n)] |
Lock all the field codes or descriptions contained in the list separated by + e.g &lock=AccCode+Description+Amount To lock ALL fields use &lock=* |
| lock:code=[0|1] | Lock the specified field given it’s unique code defined in the Datamodel e.g &lock:AccCode=1 |
| hide=[code+code2+code(n)] | Hide all the field codes or descriptions contained in the list separated by + e.g &hide=AccCode+Description+Amount |
| hide:code=[0|1] | Hide the specified field given it’s unique code defined in the Datamodel e.g &hide:AccCode=1 |
| hideid=[0|1] | Hide the identity field if present e.g &hideid=1 |
| submitContinueFields=[code+code2+code(n)] | Display a Submit & Continue button on the Form and after saving the data reload the Form with the previous values already set for the specified field code paths e.g &submitContinueFields=AccCode+Department+Date |
| language=[en|de|es|ja…] |
Override the default user account language. Defaults to English if no translations exist
language=es |
| layout=[panel|mobile|form|auto] | The default layout is form while panel or mobile is a better layout for mobile devices with small screens. auto will auto switch between form and panel depending on the device e.g &layout=panel |
| minHeight=[20..2000] | The minimum Form height. This is useful to ensure tabs are all set to the same height otherwise it will use auto height. e.g &minHeight=700 |
| fieldsPerLine=[1..4] | The number of fields to display on one line,where the default is 1. Except for fields with multiple lines, the fields will be display on one line. e.g &fieldsPerLine=2 |
| stackContent=[0|1] | Stack the field lables and inputs so the labels are above the inputs. This format is good for question answer style entry forms. e.g &stackContent=1 |
| lineHeightSpace=[1..60] | The margin height above each line. default is 1. e.g &lineHeightSpace=5 |
| maxInputWidth=[50..420] | Set the max width of the input box. default is 420. e.g &maxInputWidth=350 |
| zoomContent=[0.3..5] | Apply zoom to the entry form body, where 1 is 100% and 0.5 is 50% e.g. &zoomContent=0.8 |
| zoomAll=[0.3..5] | Apply zoom to the entry form body, where 1 is 100% and 0.5 is 50% e.g. &zoomAll=0.8 |
| overflow=[auto|visible|hidden|scroll] | Control the HTML overflow, useful when Scroll bars are appearing &overflow=hidden. Defaults to auto http://www.w3schools.com/cssref/pr_pos_overflow.asp |
| overflow-x=[auto|visible|hidden|scroll] | Control the HTML overflow &overflow-x=hidden |
| overflow-y=[auto|visible|hidden|scroll] | Control the HTML overflow &overflow-y=hidden |
| fontSize=[n] | Default font size is 11 but it can be changed e.g &fontSize=12 |
| showBorders=[0|1] | Show or hide the form borders. By default there are on e.g &showBorders=0 |
| showNav=[0|1] | Show or hide the form navigation buttons that move from tab to tab and finaly submit. By default there are off e.g &showNav=1 |
| showSignIn=[0|1] | Show user sign in at top. by default it’s not shown e.g &showSignIn=1 |
| linkLabel=[value] | Override the link Label that appears next to the buttons e.g &linkLabel=Back To Main Page |
| linkURL=[url] | Override the link URL that appears next to the buttons e.g &linkURL=http://www.sl.com |
| submitMes=[value] | Message to display after successful submit e.g &submitMes=Data has been updated |
| submitLabel=[value] | Submit button label e.g &submitLabel=Update |
| submitReload=[0|1..(n)] | Refresh the html parent page where 1 is itself and 2 is it’s parent and 3 is the parent.parent etc when successfully submitted e.g &submitReload=2 |
| submitReloadAttr=[iframe_id_or_class|2nd_id_or_class] |
Used in combination with submitReload to only refresh the iFrame with the jquery style #id or .className e.g &submitReload=2&submitReloadAttr=#MyIframeID or &submitReload=2&submitReloadAttr=#MyIframeID|.ClassName |
| submitUrl=[address] | On a successful submit jump to the URL address. Use in combination with submitReload. e.g &submitReload=2&submitUrl=/Report/?query=Approval.NextStep2 |
| deleteLabel=[value] | Delete button label e.g &deleteLabel=Remove |
| deleteReload=[0|1..(n)] | Refresh the html parent page where 1 is itself and 2 is it’s parent and 3 is the parent.parent etc when successfully submitted e.g &deleteReload=3 |
| deleteReloadAttr=[iframe_id_or_class] | Used in combination with deleteReload to only refresh the iFrame with the jquery style #id or .className e.g &deleteReload=2&deleteReloadAttr=#MyIframeID |
| deleteUrl=[address] | On a successful delete jump to the URL address. Use in combination with deleteReload. e.g &deleteReload=2&deleteUrl=/Report/?query=Approval.Reset |
| deleteMes=[value] | Message to display after delete e.g &deleteMes=Deleted |
| closeWinOnSuccess=[0|1] | Close the windows on Submit or Delete when successful e.g &closeWinOnSuccess=1 |
| clearLabel=[value] | Clear button label e.g &clearLabel=Reset |
| refreshLabel=[value] | Refresh button label e.g &refreshLabel=Refresh display |
| closeLabel=[value] | Lookup Close button label e.g &closeLabel=Done |
| previousLabel=[value] | Previous navigation button label e.g &previousLabel=Previous |
| nextLabel=[value] | Next navigation button label e.g &nextLabel=Next |
| hideButtons=[buttonNames] |
Hide the buttons by name Submit=submit Clear=clear Delete=delete Refresh=refresh To hide the delete button e.g &hideButtons=delete To hide the delete,clear and refresh buttons e.g &hideButtons=delete_clear_refresh To hide all but submit e.g &hideButtons=submit_only |
| hideButtonsOnSuccess=[0|1] | After a successful submit or delete hide all the buttons to prevent a re-submission e.g &hideButtonsOnSuccess=1 |
| fcolor=[htmlColor] | Default font colour for labels etc e.g &fcolor=black |
| bcolor=[htmlColor] | Default background colour e.g &bcolor=green |
| ifcolor=[htmlColor] | Default input font colour e.g &ifcolor=black |
| ibcolor=[htmlColor] | Default input background colour e.g &ibcolor=yellow |
| iocolor=[htmlColor] | Default border colour or boxes e.g &iocolor=blue |
| allowParentOverlay=[1|0] | Allow the form to appear in the parent document as a overlay when calling WinOverlayExtShow in JavaScript e.g &allowParentOverlay=1 |
| mandatoryStyle=[NONE|BOLD|STAR|STAR-AFTER|STAR-RED|STAR-RED-AFTER] | Define how mandatory fields are shown on the Data Entry Form. By default they are shown in bold but this can be suppressed or instead a * can be displayed near the label e.g &mandatoryStyle=STAR-RED |