This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal


Aug 1, 2014, 8:30 AM
3 Posts

Progress

  • Category: Application Development
  • Platform: Windows
  • Release: 9.0.1
  • Role: Developer
  • Tags:
  • Replies: 9

Thank you all, these are proving useful.

I am here to inform you about my progress as I actually managed to achieve kind-of what I wanted.

I created a new form, with a single input field that is a dialog list (it contains the countries), and then I have multiple computed fields:

  • First, I fetch the employees whose main countries are the selected country, and the job descriptions (w. dblookup). I also fetch their serials to a hidden field.
  • Then, in a computed field, I use a rather complex formula to fetch the responsibilities (at least complex for me):
    • I check for each employee found, in which field is the current country defined for them. Then I fetch the responsibilities for that country. (this is done by a field-naming trick, eg. I have stored countries one-by-one as mctry_1, mctry_2 ...; and their respective tasks as mtask_1, mtask_2, ...).
    • Currently, I have a form that can display per country, who are the main and backup employees for them, and what are their tasks for the country.
  • Now I am looking for a method to display all countries in a view, if possible.

I made some screenshots: Country form, Employee form, Result

I can upload the current state, however as it is much easier for me to use actual data than dummy, It would take some time to anonymize the database.

Aug 1, 2014, 9:41 AM
28 Posts
is it possible for you, to Copy the database without ACL, and ZIP it ?
And to Anonymize, just change the Names of individuals in the few records you got.
Aug 6, 2014, 11:04 AM
28 Posts
Doesn't matter now, I won't be available for the next 3 weeks.

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal