Difference between revisions of "SignatureView Options"
Yvonne.milne (Talk | contribs) (→Overview) |
Yvonne.milne (Talk | contribs) |
||
Line 1: | Line 1: | ||
− | |||
− | |||
==See Also== | ==See Also== | ||
[[SignatureView Section Attributes]] | [[SignatureView Section Attributes]] | ||
Line 47: | Line 45: | ||
===Using a Signatureview Section=== | ===Using a Signatureview Section=== | ||
− | In the browser, touch or click the '''Edit''' icon and the panel will be enabled. '''Save''', '''Cancel''' and '''Clear''' icons will now be shown | + | In the browser, touch or click the '''Edit''' icon and the panel will be enabled. |
+ | |||
+ | '''Save''', '''Cancel''' and '''Clear''' icons will now be shown. | ||
+ | |||
+ | Draw the signature in the panel and Save/Cancel/Clear as required. | ||
+ | |||
[[{{ns:file}}:signatureview_browser.png|800px|left|border|link={{filepath:signatureview_browser.png}}|example_signatureview]] | [[{{ns:file}}:signatureview_browser.png|800px|left|border|link={{filepath:signatureview_browser.png}}|example_signatureview]] | ||
<br clear=all> | <br clear=all> | ||
− | ==Database== | + | ==Attributes== |
+ | Signatureview sections have the following section specific attributes. | ||
+ | |||
+ | ===Database=== | ||
+ | The name of the database. | ||
+ | |||
+ | For the example_signatureview App, this is: | ||
+ | |||
+ | <pre>southwind</pre> | ||
+ | |||
+ | ===Table=== | ||
+ | The name of the database. | ||
+ | |||
+ | For the example_signatureview App, this is: | ||
+ | |||
+ | <pre>signatures</pre> | ||
+ | |||
+ | ===Filter=== | ||
+ | An optional logical filter expression, not used in the example_signatureview App. | ||
+ | |||
+ | ===Image column=== | ||
+ | The name of the blob column that will be used to store the signatures. | ||
+ | |||
+ | For the example_signatureview App, this is: | ||
+ | |||
+ | <pre>image</pre> | ||
+ | |||
+ | ===Keyfield=== | ||
+ | The name of the unique id column that the keyfield expression will be inserted into when a signature image is added. | ||
+ | |||
+ | For the example_signatureview App, this is: | ||
− | + | <pre>id</pre> | |
− | == | + | ===Keyfield expression=== |
+ | The keyfield value that will be inserted when a signature image is added. | ||
− | + | For the example_signatureview App, this is: | |
− | + | <pre>{strzero( {{EMPLOYEES.EMPLOYEEID}} ) }</pre> | |
− | + | enabling the SignatureView section to be related to the employee details (employee table) Form section by the unique signatures.id / employees.employeeid fields. | |
[[Category:Attribute Categories]] | [[Category:Attribute Categories]] | ||
[[Category:Sections]] | [[Category:Sections]] | ||
[[Category:Lianja v9.5]] | [[Category:Lianja v9.5]] |
Revision as of 12:16, 1 March 2024
Contents
See Also
SignatureView Section Attributes
Overview
SignatureView sections are used for signature capture in touch enabled web/mobile Apps.
example_signatureview App
The example_signatureview App is included in the App Builder distribution to demonstrate the use of a SignatureView section. It is shown running in a web browser above.
And here in the App Builder:
Note that SignatureView sections can only be used in touch enabled web/mobile Apps. Preview live in browser to display the signature panel and try it.
The example_signatureview App has TabView Section with three tabs:
- Employee: Form Section with employee details from the southwind!employees table
- Employee Photo: Form Section with an Image gadget showing the southwind!employees.photo (blob) field
- Employee Signature: SignatureView section to display and capture the southwind!signatures.image (blob) field
Signatures Table
The example_signatureview App uses the southwind!signatures table. Its structure is listed below. Your table can have different field names and fewer/additional fields, but must include a unique id field and a blob field to store the signature image.
Field | Field Name | Type | Width | Notes |
---|---|---|---|---|
1 | ID | Character | 36 | Required unique key field. |
3 | CREATED | DateTime | 8 | Optional creation datetime field. |
4 | MODIFIED | DateTime | 8 | Optional modified datetime field. |
5 | IMAGE | Blob | 8 | Required field to store the signature image. |
Using a Signatureview Section
In the browser, touch or click the Edit icon and the panel will be enabled.
Save, Cancel and Clear icons will now be shown.
Draw the signature in the panel and Save/Cancel/Clear as required.
Attributes
Signatureview sections have the following section specific attributes.
Database
The name of the database.
For the example_signatureview App, this is:
southwind
Table
The name of the database.
For the example_signatureview App, this is:
signatures
Filter
An optional logical filter expression, not used in the example_signatureview App.
Image column
The name of the blob column that will be used to store the signatures.
For the example_signatureview App, this is:
image
Keyfield
The name of the unique id column that the keyfield expression will be inserted into when a signature image is added.
For the example_signatureview App, this is:
id
Keyfield expression
The keyfield value that will be inserted when a signature image is added.
For the example_signatureview App, this is:
{strzero( {{EMPLOYEES.EMPLOYEEID}} ) }
enabling the SignatureView section to be related to the employee details (employee table) Form section by the unique signatures.id / employees.employeeid fields.