Store identical values in a list variable

Publié Thu, 04 May 2023 10:58:42 GMT par Jalila Manal

Hello, I would like to configure a loop in a workflow. For that reason, I've created a keyword variable named List_NewClient, this variable should get the value of the field NewClient1, NewClient2, ..NewClient4. in each iteration. The issue is: in this field only two values are possible: yes or no. While testing, I noticed that the keyworld variable will restetute only different values, which means that if I should have this result on the list: Yes No No Yes My variable List_NewClient will get Yes, No And this is not good for the logic of my WF, what I need to have is List_NewClient: Yes, No, No, Yes. Do you have any idea how I can get this result? PS: I've unchecked the box "replace" on the WF. Thank you in advance. Regards,

Publié Thu, 04 May 2023 11:55:25 GMT par Simon H. Hellmann Toshiba Tec Germany Imaging Systems GmbH IT-Consultant Document Management Solutions

Hi Jalila,  you could try to work with checking the box "replace" and use an arithmetic expression like the following: <code>Split(KeywordAsString(GV_List__NewClient,";") & ";" & DW_NEWCLIENTn,";")</code> This will first take the values from your list and put it into a string separated with ";", then add the new value to the end and split it again into a keyword field. Example: <pre class="linenums prettyprint">// Starting values: Yes No // next value to add: No // result after: <code>KeywordAsString(GV_List__NewClient,";") </code>Yes;No // result after: <code>KeywordAsString(GV_List__NewClient,";")</code> <code>& ";" & DW_NEWCLIENT3 Yes;No;No </code>// result after: <code>Split(KeywordAsString(GV_List__NewClient,";") & ";" & DW_NEWCLIENT3,";") Yes No No</code> </pre> Hope this helps. Greetings from Germany, Simon H. Hellmann DocuWare System Consultant

Publié Mon, 08 May 2023 14:37:41 GMT par Jalila Manal

Hello Simon, Many thanks for your reply. If I understood you right, the final result will in a string variable. If this is the case, It wont help me as I could not use the keyworld variable to loop. I just give you this example to simplify the problem, but what I'm trying to do is the following: 1. A user will fill a web form like the following: <table border=1 cellpadding=1 cellspacing=1 style="width:500px;"> <tbody> <tr> <td>Client NAme</td> <td>New client</td> <td>Amount</td> </tr> <tr> <td>client1</td> <td>yes</td> <td></td> </tr> <tr> <td>Client2</td> <td>yes</td> <td></td> </tr> <tr> <td>Client3</td> <td>no</td> <td></td> </tr> </tbody> </table> My WF should be able to calculate the amount and put it on the corresponding fill area, depending on the New client column value. Let's say, if New client=yes, then amont= 5000, else, amount =0 I can have up to 7 clients, so I would like to implement a loop with a counter. What I've done, is creating a keyworld variable to read the new client column data from the index entries like the following: GV_List__NewClient <--- NewClient1 (index entry)  GV_List__NewClient <--- NewClient2 (index entry)  .... GV_List__NewClient <--- NewClient7 (index entry)  Then having a string variable ST_NewClient <--- GV_List__NewClient[GV_counter -1] (Arithmetic expression) Then put the condition on  ST_NewClient If ST_NewClient="Yes" GV_List_Amount[GV_counter -1]=5000 (it should be also a keworld variable) if not GV_List_Amount[GV_counter -1]=0 And then update the counter. Over to you. Regards,

Publié Fri, 12 May 2023 15:20:07 GMT par Tobias Getz DocuWare GmbH Team Leader Product Management

Hi Jalila Manal, a keyword field can always have single values, it is not like an ordered lists. If you want individual entries for lines, than you could think about solving this with a table as index fields. This way you can even calculate inside the table and maybe then you even maybe can prevent to add a loop. So the "Amount" column would be filled by a calculation if the column "New Client" is "Yes". But this advice is very general without actually knowing the specific use case. Regards Tobias Getz Team Leader Product Management DocuWare GmbH

Store identical values in a list variable

Obtenir de l'aide