Objects

Adding Objects to your Edit Form will allow you to display and edit a record's data.

Each type of Object has a different purpose.

You can use Arrange Objects to rearrange Objects you have placed on the Form along with their tabbing order.

The All Tab contains information required by all Objects (with a few exceptions).

The Custom Code Tab allows Javascript events to be added to all Objects (with a few exceptions).

All other Tabs relate specifically to the Object of the same name.

All Properties

Tab-Form

Select the Tab (and therefore the Edit Form it belongs to.) to add this Object to.

Type

Choose 1 of the following 11 types.

• Calc A Number Field that value is based on other Number Objects of the current Edit Form.
• Display A readonly field that will display the first field of the first record from a SQL Select statement
• HTML A readonly area that can be used to display html.
• Image A readonly area that will display an image.
• Input Generally used for entering text, it can also be used for other HTML5 Input types. Along with some types exclusive to nuBuilder.
• Lookup A lookup allowing the selection of a value from another table.
• Run Creates either a Button to allow the user to run another Form/Report or Procedure, or creates an iFrame on the Edit Form in which a Form/Report or Procedure is placed.
• Select Allows the selection of one or more values from a finite list.
• Subform Can contain rows (Subform Forms) that relate to the Edit Form.
• Textarea Allows for unformatted text.
• Word A readonly object that simply creates a phrase in Bold.

Label

Description of Object.

ID

A valid HTML element id that is unique to this Edit Form.

Top

Value in pixels.

Left

Value in pixels.

Width

Value in pixels.

Height

Value in pixels.

Cloneable

Yes or No.

In the case of Yes on a customer field, when an invoice is cloned the customer name is retained.

But an invoice number field would be set to No so that any cloned invoice could get a new number.

Used by..

• Calc
• Input
• Lookup
• Select
• Textarea

Align

Left, Right or Center.

Used by..

• Calc
• Display
• Input
• Textarea
• Word

Validation

None, No Blanks or No Duplicates.

Used by..

• Input
• Lookup
• Select
• Textarea

Access

Editable, Readonly or Hidden.

HTML

Calc

A Calc Field is a numberic field that will be recalculated after any onchange event.

The Formula for this calculation is simply created by clicking on a combination of the Fields Object and the Operators Object.

The Fields Object is a list of available Number Fields on the Edit Form.

Custom Code

If an Object has a Javascript event, the Custom Code Tab will be in bold.

These events are standard HTML5 events such as onclick or onchange.

The exception to this is a Subform Object which has ony 2 events.

• beforeinsertrow
• afterinsertrow

Javascript

• Event - Column Title
• Javascript - Table field name.