How to automattically update drop down values

Hi Experts,
 
Our requirement is to create a dropdown when ticket category is install.
The dropdown values will be from 1 to 10.Our exact requirement is when we create an incident and the ticket category is install the user has to select any of the values from 1 - 10.
If the user is giving 1 as the value , for next incident only from 2 to 10 they can select and only those value should be displayed in the dropdown. (But am sure this is not possible with GL) and if they select 1 error message has to show since it is already assigned to one incident.
This will be same for all the upcoming or available incident, once all the 10 values are assigned to incident then no other incident should not select the value from the dropdown. If they select it has to show the error message.
If any of the incident assigned with the value from 1 to 10 is closed then the allocated no: should display for other incident to assign.

We have done in form level changes and created GL. Need to know any other option to achieve this.
 
Thanks in advance.
 
Regards,
Abarna Arunraj

Parents
  • Verified Answer

    Here is a way to achieve it:

    1.  Create a table that has the columns: number, active

    2.  Populate the table as:

    1, true
    2, true
    etc

    3.  On the form, have the drop-down list do a select on this table for the numbers where active is true.

    4.  On creation of a ticket have SM search this table, find the row where the number is the one selected from the drop-down and change the value of active to false.

    5.  On close of a ticket have SM have SM search this table, find the row where the number is the one selected from the drop-down and change the value of active to true.

  • Thanks for your reply.

    As you said, for the 1st 3 points I will be able to do, and please can you elabrate the 4th and 5th point, how come I will be doing this, need to do in FC or where? can you share any coding/query for this.

    Thanks in Advance.

    Regards,

    Abarna Arunraj

Reply Children
No Data