Announcements
No record found.
Hi All,
I want to create a dropdown that would populate the job numbers for a user who have filled their timesheet in a specified time frame .
This I want to do in a request page of a report. Any idea how this could be achieved?
So once the dates are filled in you want a procedure to determine what jobs have had timesheets posted to for that user? Procedure to return a filter string? Does it make sense to have it on the request page? If they want to override maybe have that as an option instead and then let the report otherwise calculate the filter when the user doesn’t override.
Hi ,
Thank you for the reply. Actually there are many jobs in our organisation.Hence for the ease of the user if the dropdown populates only those that is relevant to him would make it easier for him to choose the job number which in turn would generate a excel template based report.
Regards,
Indira
Gotcha. Perhaps the report needs to be based on a temporary table of the jobs table. OnInitReport trigger you then populate the table based on looping through timesheets for a chosen period of time with job numbers. You’ll need to do a IF GET with each loop to skip repeated jobs
Cud you share an example Please
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 753 Super User 2026 Season 2
YUN ZHU 583 Super User 2026 Season 2
AndrewThomas81 302 Super User 2026 Season 2
