fmp17 User See thier Own record

[Lola]

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

 

Hours.fmp12

Edited January 15, 2019 by Lola

[dwdata]

Hello Lola,

I added a new table that stores your ProjectCodes. Then a few calculated fields to streamline the report you are trying to generate. Check out the last LAYOUT I created. As far as Isolating Users, simply populate the gUser field accordingly 😉

Good Luck!!!

Hours.fmp12

[Lola]

Thank you so much Don...

Can you please also help me to generate the total hours of each user they spent Activities versus project Code..

 

Thank you so much.

[Lola]

Hi Don,

I noticed that the calculation result summary for each user is not giving me the correct result...how can I fix this?.

 

Thank you.

Edited January 27, 2019 by Lola

[dwdata]

Sorry Lola - Did you figure this out? I don't check the site much these days and I did not get an email echoed that you replied.

So did you just want to total each column? I added that.

Hopefully this helps. If not please let me know!


 

HoursRev2.fmp12