Knowing where to make certain changes to fields and view columns is not always that obvious. I will cover some of the basics that I have found to be useful or not obvious. I cannot list them all and I have not used them all but this should cover the majority of standard data types and how you may want to use them.
One key thing to note when you are hiding a field, remember
that the hide option works on paragraphs not individual items. Make sure you
consider this when you are designing the layout of you form. If you have multiple
fields, that are automatically calculated and do not need to be displayed,
group them in a single paragraph at the bottom of the form. I colour these
fields RED to indicate they are always hidden. These are not essential but do
make it easier to find and identify hidden fields.
To resize any field you need to set the style to Native OS style.
- Use "Calendar/Time control" if you want the user to have a pop up calendar. (Only works when use selecting date, does not pop up if you have display time selected)
- On the second tab, control, use the options to change formatting and include time.
- In control tab, enter choices. Can be a list, one entry per line, found by formula, address book.
- Click "Allow values not in list" to give the user a manual entry box
- Create a new field with the name.
- Go into the control tab and enter the choices one per line.
- In Control tab, use the display options to line the buttons up as desired; number per line, border style, etc.
- In the Options section of the Control tab select the refresh options if the form needs to be changed with different options, i.e. if fields are hidden on different choices.
- Used to enter a name from an address book. Automatically links to SameTime if it is being used.
- In the Control tab, Display section; click "Show online status" to link directly to SameTime.
- The Choices sections, select "Use address dialog for
choices" to pop up local address book.
Useful template formulas
There are some formulas that are used a lot or should be used in place of basic ones. Here is a list of the ones I have found useful.
Validate field is not empty before saving:
In the object input validation section, enter:
@If(@ThisValue = NULL; @Failure("FAILURE NOTIFICATION"); @Success)
A better way of coding a save and close button:
A discard and close button:
FIELD SaveOptions := "0";
Save document and write a message to the status bar:
Adjusting date/time fields:
Format of @ADJUST is (TIME ; y ; m ; d ; h ; m ; s) Use @Today if you only want the date, @Now for date and time.
Set field when a new document is created:
@If(@IsNewDoc;"NEW DOC VALUE";@ThisValue)