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, 20196 yr by Lola

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

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.

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, 20196 yr by Lola

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