AnsweredAssumed Answered

User see Own Record

Question asked by thong127 on Jan 12, 2019
Latest reply on Jan 17, 2019 by mark-it

Hello All,

 

The attached file is the simulation of my excel worksheets. I have three (3) accounts Admin, John & Lola all the three (3) accounts has no password.

 

In my layout "ReportsEquipmentTime",  I want that If I click the "project x equipment" button I will see only the record of the current account that is login.

 

The script that Im using is

Set Error Capture [on]

Allow User abort [off]

Set variable[$_columns; Value: ValueListItems ( Get(FileName) ; "Equipment" )]

Set variable[$_rows; Value: ValueListItems ( Get(FileName) ; "ProjectCode" )]

 

Set Field[Users::RELOGIN; Get(AccountName)

Enter Find Mode [Pause: off]

Set Field [DailyReports::CreatedBy;

Set Error Capture [on]

Perform Find []

Go to layout ["ReportsEqipmentTime" (ReportsEquipmentTime; Animation: None]

 

Set Field [ReportsEquipmentTime::_Column Headers; $_columns]

Set Field [ReportsEquipmentTime::_Column Source; "EquipmentUsed"]

Set Field [ReportsEquipmentTime::_Row Headers; $_rows]

Set Field [ReportsEquipmentTime::_Row Source; "ProjectCode"]

Commit Records / Request [With dialog: off]

 

Please see attached File.

 

Thank you

 

Lola

 

Please see attached File.

 

Thank you

 

Lola

Attachments

Outcomes