Populate table fields on insert in view cluster

[former_member382625]

Hello,

I have created 2 tables. Each of these tables has a field created by.

Now, I created maintenance view for these tables and view cluster for these tables. (I did not include created by field in these view since I dont want those to be shown to user).

Whenever data is entered in the view cluster, I want the created by to be updated. How can I achieve this?

If I implement event in the view cluster would these fields be available?

Thanks and Regards,

Neha

[former_member382625]

Hello,

I have created 2 tables. Each of these tables has a field created by.

Now, I created maintenance view for these tables and view cluster for these tables. (I did not include created by field in these view since I dont want those to be shown to user).

Whenever data is entered in the view cluster, I want the created by to be updated. How can I achieve this?

If I implement event in the view cluster would these fields be available?

Thanks and Regards,

Neha

[kakshat]

Hello Neha,

I think you will have to add the CREATED_BY field in the maintenance view but you can hide it from appearing on the screen by entering 'H' in column 'P' on the View Fields tab.

Regards,

Akshat

[former_member382625]

Hi Akshat,

Thanks for the response. So, I should implement an event in view cluster now to ensure these checks?

Best Regards,

Neha

[kakshat]

Yes, I believe so. But, you don't mean 'checks', right? Rather, you mean setting those fields in the event.

[Venkat_Sesha]

Goto SE54,

Enter you view Cluster name

goto the TMG

From the menu Environment--> Modification--> Events

Click on the New Entries Button

Event Number 05 TEST_SAVE Click on the button Just beside this field 'FORM Routine'

It will ask to create a new Sub-routine in a Include.

Say yes in a New Include.

A blank Include will be open for Editing.

Enter the code as follows.

FORM TEST_SAVE.

Break-Point.------> You can write your code. This will be triggered when ever user saves some data.

ENDFORM.

This should solve your problem..