To set default value of a non-db field

Hi @Shneor Cheshin,

thanks for your feedback.

Yes, I have tried using client script (using same function setControlValue).

The only difference is, the fields to set are from a view.  They are dummy fields.

The reason I don’t use the field from a table because those fields are used only in UI and flags for process in other client-script.

So the idea is not to use up fields of a (baseline) table.

Is it possible to achieve that?

Cheers,

~Juni.

Hi @JuniSihombing,

Either way, as the primary table does not persist these particular columns in the database, isn’t it possible to directly refer the columns from the view itself by creating the custom metadata for the view  and then joining the view with the primary table keys on the UI designer? Once this is done, you can simply drag and drop the required fields to the ui from the view’s custom metadata and ideally it should show the correct results. 

Hi @Shneor Cheshin ,

custom metadata of the view was created.  In custom metadata default value of the field was also set.

@Saranga Amaraweera’s suggestion was also set before, but the field still cannot get default value set.

I thought it was because of “CHECKBOX” field type.  I tried to change the field type to TEXTBOX and removed the masktype  = “YORN” from metadata, but still no default value.

~Juni

Hi @Saranga Amaraweera,

sorry for the late reply.

Here is setting in UI designer:

 the setup of field REOCCURRING in custom-metadata:

Here is the statement for view:

CREATE VIEW [dbo].[c_exc_mgmt] as
SELECT 
 exception_id as exception_id,
 DATEDIFF(HOUR, start_dttm, end_dttm) as duration,
 DATEPART(WK,start_dttm) -1 as week,
 DATEPART(YY,start_dttm) as year,
 CONCAT (DATEPART(WK,start_dttm)-1,' - ', DATEPART(YY,start_dttm)) as weekyear,
 NULL as reoccurring,
 NULL as exclude_weekend
FROM person_cal_except

I did try to set the default values of reoccurring and exclude weekend fields (in the create view statement), but also didn’t work in the runtime.

 ‘N’ as reoccurring,
 ‘Y’ as exclude_weekend

Any thoughts based on the setups?

Cheers,

~Juni

Hi @Saranga Amaraweera ,

 “In Database” flag was also marked, but same result.

I set “NULL” for reoccurring/exclude_weekend fields in the view, because just don’t want to give wrong information in the result of view itself.

The exception calendar can be weekend, but if the “exclude_weekend” in view = ‘Y’, the view give not too precise info.