Lola Posted January 14, 2019 Posted January 14, 2019 (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 January 15, 2019 by Lola
dwdata Posted January 21, 2019 Posted January 21, 2019 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 Posted January 21, 2019 Author Posted January 21, 2019 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 Posted January 27, 2019 Author Posted January 27, 2019 (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 January 27, 2019 by Lola
dwdata Posted February 2, 2019 Posted February 2, 2019 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
Recommended Posts
This topic is 2373 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 accountSign in
Already have an account? Sign in here.
Sign In Now