FSM: How to default a date field to now

Can you use the SQL expression SYSDATE?

Even better, in a global environment, you might want to use the site date for the user’s default site:

site_api.get_site_date(user_allowed_site_api.get_default_site)

Thanks for the reply ‘durette’, however I think you must be using IFS APPS rather than IFS FSM.

Hi @nickz ,

Not entirely sure whether you could set coverage_start_dt, end_dt  with expressions on UI designer as the values are being populated them selves based on the contract and contr_product parent-child relationship defined in the fsm metadata level.

As mentioned, it would be better to give it a try by updating the field with a client script.

A value BR (with now() expression on output column)  could also be an option, but you would not see the current date in real-time (will always pick what has been mentioned in the contract.start_dt) on the screen when adding the new line. Current date will be highlighted only after saving the record.

Hi 

Below are the steps I followed to get today’s date as default in any additional line included.

Step 1 : Go to UI Designer → Select “Coverage”

Step 2 : Select the coverage start date field from “Lines” tab

Set 3 : In the fields value → default Value → enter “Today” and save

Below is the test steps I did in the app.

After saving above changes, you can get the today’s date by default to ”Coverage start date” when adding new lines to contracts.

Thank you,

Rasangi