Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 2131 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted (edited)

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 by Lola
Posted

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

Posted

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.

Posted (edited)

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 by Lola
Posted

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

This topic is 2131 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.