- Last Field Value (*Last)

Last Field Value (*Last)

Introduction

The Field Descriptors have a Default Value property under the Basic settings. In this property there is

a Session setting that allows users to set default values for the same session only. There may be multiple

field descriptors set with this setting and can have different data types as well.

An example of how users can benefit from this feature:

Let’s say I am the H.R. Manager and have about a dozen new hires coming in for Orientation today. All of

these new hires will belong to the same department for the first two weeks of training and will all be given

the same training before they can start in their respective departments. They will all be given a company

email address as well as a employee number.

What I can do is set five known fields to a session default value so that I am not retyping any of this out.

First I can set their work department to “Education,” their employee number will start with “30700” and I

will have to input only the last digit, their employee email address will end with “@mycompany.com” but will

place new at the beginning since the database won’t accept it without something before the '@' symbol, and

their start date will all be today’s date, I can also set their job title to “Intern” to let others know they are

starting with us as new employees. This will save me a lot of time since I have about a dozen expected new

hires.

This is implemented by either change:

• • Editing a row of information.

  • Inserting a new row of information.

NOTE: This is intended for a single session only.

Setup

• • create an Operation or use an existing Operation of your choice.

  • choose the field you would like to set with a default value for the session.

  • click on the Field Descriptor icon for the field(s) chosen.

example:

• • set the Default Value property to Last Field Value.

  • click the Update button at the top of the page.

example:

Now the way this will work is when you edit or insert a row, the value entered for this field will then be

remembered and for the next time a row is inserted, it will have this field automatically filled in with

whatever value was entered in last.

example:

For my example, I will be inserting a new row into the employee table. I can add the first employee into the system so that the field will then be set for this session.

Note: The way this feature works when editing a row, is that if I go to an existing employees row and

update some information on this employee but their hire date is “04/04/2018” when I go to insert

a new employee, the HIREDATE field will now be automatically be filled with “04/04/2018” instead of the previous

empty value.

Keep in mind that if you go into an existing row of information, this last value that was set for this HIREDATE field

will not change that employees hire date from what it originally was set as. This will only affect new

row inserts.

Now that I have inserted my first employee into the database, the next time I click on the Insert button to

add a new employee, the field will be filled.

example: