topic Re: Automation Not Applying Variable Bookmark For WriteBack Solution in Qlik Automate

Automation Not Applying Variable Bookmark For WriteBack Solution

marcusva — Wed, 24 May 2023 17:32:39 GMT

Hi all,

I've been trying set up an automation to writeback some variables set by the end user to an external excel file in a sharepoint folder.

For that, I'm following the basic example from Michael Tarallo on the Qlik youtube channel (https://www.youtube.com/watch?v=hYER2nGKctM&ab_channel=Qlik) , which is based on another article (https://community.qlik.com/t5/Official-Support-Articles/How-to-build-a-write-back-solution-with-native-Qlik-Sense) .

However, I'm having a problem when replicating the current state of variables to the Automation.

I tried replicating exatcly the same steps:

1. Setting the layout, creating the variables, update and reload buttons:

(layout - as you can see, the standard values for the variables are '-', since I'm using the fields as definition)

(Update button settings - Include Selections checked!)

2. Creating the automation using the 'Copy Input Block' blocks and adding the three Get Expression Value blocks.

To check whether it is getting the current variable value from the temporary bookmark, I also added an Output block:

(note that the app and bookmark IDs are the same from the used input block)

However, I'm not getting the expected result:

After setting different values to the variables with the Input visuals and clicking the Update button in the Analysis App, the output always gives me the default value of my variable.

(note that in the app front-end, the variables are updated)

It's as if my variables were not being updated (or bookmarked) to the current values when sent to the automation.

In this specific example, it's not generating any output, since my variables by definition are the fields, which gives me '-' as an output, as per my first step.

I also did another test, setting the definition of the variables as fixed strings. In this case, I always get the same strings as output.

Would anyone know if there's any step I'm missing? Or if there is any kind of limitation to a specific type of environnment?

PS: I found some other posts about selections issues for generating reports, but I coudn't find something specific for variables and writeback function so far.

Re: Automation Not Applying Variable Bookmark For WriteBack Solution

AfeefaTk — Fri, 26 May 2023 14:31:29 GMT

Hi @marcusva

If I understand correctly you are not able to get the variable value that is being selected from the app as the output of the Get Expression block in the automation once the button is clicked?

Is that correct?

In order to look into the configuration of the app and automation, could you please share them both?

Thanks

Re: Automation Not Applying Variable Bookmark For WriteBack Solution

AfeefaTk — Fri, 26 May 2023 15:49:22 GMT

Hi @marcusva

Are you sure that you are using the correct expression in the definition parameter while creating the variables in the UI and also mapping the correct variable name in the Get Expression Value block?

I have run a few tests from my end and it works as expected.

Thanks

Re: Automation Not Applying Variable Bookmark For WriteBack Solution

marcusva — Fri, 26 May 2023 17:54:04 GMT

Hi @AfeefaTk , thanks for your reply!

That's right, the current variable selection or setting is not going to the automation through the apply bookmark block. It seems that it only keeps the variable standard value.

For example, following the steps provided in the video, the standard values for my variables shoud be the field itselt:

vTitle = Title (vComentario = Comentario in my case)

Since there is more than one value for Title, the standard value for the variable is shown as '-' (or null).

Front end before setting values for the variables

In this case, even if I set new values for the variables using the Input visuals, and they are shown in the front end as these updated values and then click the "Update" button, the new setting is not reflected to the automation blocks. Then I get an error, because the automation tries to read a null() value.

Front end after setting new values for the variables

Result from the Get Expression Value block. Note that there's no output, since the value is null

However, if I reload the app before clicking update, then the standard values for the variables are set according to the input visuals, for instance:

vComentario = 'New Comment'

Then, if i click the Update button, the automation runs as it was supposed to and there's an output in the Get Expression Value block:

I think the problem is in the Run Automation visual or the Apply Bookmark block, I'm almost sure I'm doing exactly what the tutorials show, but maybe I'm missing something...

Please find attached the app and the automation I'm using. Also, the excel spreadsheet from which I read the data and write back to has the following format:

Any help is appreciated, thank you very much!

Re: Automation Not Applying Variable Bookmark For WriteBack Solution

AfeefaTk — Mon, 29 May 2023 06:09:38 GMT

Hi @marcusva

I think the variable expression (vComentarios) defined in the UI is invalid.

Please take a look at the screenshot for reference.

Please correct the error in the expression and see if that solves the issue.

Thanks

Re: Automation Not Applying Variable Bookmark For WriteBack Solution

marcusva — Mon, 29 May 2023 11:16:41 GMT

HI @AfeefaTk ,

I think I got it wrong when setting the variable to its standard value before sharing the app.

However, I believe that wasn't the problem. After setting it back to "Comentarios" and running the automation, I got the same error as before. Also, it wasn't working for the other two variables aswell.

variable vComentarios with no output after setting a new value in the UI and hitting the update button.

Re: Automation Not Applying Variable Bookmark For WriteBack Solution

d_abbatelli — Mon, 29 May 2023 12:23:19 GMT

Hi,

Just wanting to mention that I had the same issue as @marcusva , and that similar issues are also mentioned here.

In my case, i simply reloaded the app visualization (hitting the refresh button on the browser) and after that the Variable Inputs seems to have started communicating with the Automation as expected.

Re: Automation Not Applying Variable Bookmark For WriteBack Solution

marcusva — Mon, 29 May 2023 12:30:52 GMT

Hi, @d_abbatelli

Thanks for sharing. I've just tried doing the same here, but unfortunatelly I'm still having the same problem...

Re: Automation Not Applying Variable Bookmark For WriteBack Solution

marcusva — Fri, 02 Jun 2023 20:17:30 GMT

Hi all,

Did anyone else have the same problem or any updates? I just can't figure what may be wrong...

Re: Automation Not Applying Variable Bookmark For WriteBack Solution

AfeefaTk — Tue, 06 Jun 2023 07:23:03 GMT

Hi @marcusva @d_abbatelli

If you define an expression in the variable created in the UI, then on the automation side it will just run the expression so user input will be ignored.

If you want to have a user-inputted variable then best to give the variable with no definition/formula.

Could you please try removing the expression from the definition field in the variable and see if that takes the value that is being provided in the input box?

We are also working on updating the demo video to clarify how the variables should be configured on the app side to pass the user-inputted values to the automation.

Thanks!

Re: Automation Not Applying Variable Bookmark For WriteBack Solution

danabb — Tue, 06 Jun 2023 07:44:32 GMT

Hi @AfeefaTk ,

I can confirm that if the variable is defined as an expression (starting with the equal sign, like "=Comentarios") the automations ignores the user value.

If the variable is defined as a 'constant' (without the equal sign, as example using the string 'Default comment') then the user input is passed to the Automation.

The problem is, using a constant, the value does not change with user selection, so the variable input will always show 'Default value' (or whatever the user has input there) even if the selected record already has another comment (making it very easy to overwrite a record with the wrong value).

All in all, this behaviour seems to be different than what is shown in the video.

Re: Automation Not Applying Variable Bookmark For WriteBack Solution

AfeefaTk — Tue, 06 Jun 2023 13:29:15 GMT

Hi @danabb

I would suggest you follow a different approach mentioned below to get the user-inputted values passed over automation and also have the selected values auto-populated in the input box.

Ensure Include selections are selected in the Execute automation action in the button.
Clear the definitions from old variables.In the example app, the variables are vDealName and vPrediction.
Create new variables with definitions.For eg vDealName2 and vPrediction2 with the definitions =DEALNAME and =PREDICTION.
Set the input boxes to show new variables that is vDealName2 and vPrediction2
In this example,add two set variable actions before executing the automation. The first one will set the variable vDealName to =vDealName2. The second one will set the variable vPrediction to =vPrediction2
Click on the Copy input block from the Execute automation action in the button and paste this into the automation.
Use the Get expression value blocks to get the vDealName and vPrediction variables in the automation. Use the formulas =vDealName and =vPrediction.

Please find the automation and app configured following the above steps for your reference.

Please let me know if that works.

Thanks

Re: Automation Not Applying Variable Bookmark For WriteBack Solution

marcusva — Tue, 06 Jun 2023 13:21:50 GMT

Hi, @AfeefaTk

Thanks, using 2 set of variables works like a charm!

The only step I had to add was to add more "set variable actions" to make sure the new variables returned to the standard value (vDealName2 = DealName).

So for me it worked like this:
(step 6 added)

Ensure Include selections are selected in the Execute automation action in the button.
Clear the definitions from old variables.In the example app, the variables are vDealName and vPrediction.
Create new variables with definitions.For eg vDealName2 and vPrediction2 with the definitions =DEALNAME and =PREDICTION.
Set the input boxes to show new variables that is vDealName2 and vPrediction2
In this example,add two set variable actions before executing the automation. The first one will set the variable vDealName to =vDealName2. The second one will set the variable vPrediction to =vPrediction2
Add two set variable actions after executing the automation to set the new variables back to the standard values. The first one will set the variable vDealName2 to =DealName. The second one will set the variable vPrediction2 to =Prediction.
Click on the Copy input block from the Execute automation action in the button and paste this into the automation.
Use the Get expression value blocks to get the vPlatform and vName variables in the automation. Use the formulas =vDealName and =vPrediction.

Thank you very much. I will run some tests, but I think this will be sufficient.

However, would you know if more than one user can run this automation at the same time?

For example: I have a team of salesmen and they are using this tool to check and update information for their customers. They both are using the dashboard at the same time with different customers.

Re: Automation Not Applying Variable Bookmark For WriteBack Solution

AfeefaTk — Wed, 07 Jun 2023 10:04:19 GMT

Hi @marcusva

Yes, those who have access to the button can click on the button and run automation if it's set to run in triggered mode.

As mentioned in this article (check Limitations section) automation cannot have parallel runs. So if the button is clicked by different users at the same time, it won't get executed at the same time. The new runs will get queued and start running once the previous run is completed.

Hope this answers your question.

Thanks

Re: Automation Not Applying Variable Bookmark For WriteBack Solution

André — Thu, 06 Jul 2023 20:07:57 GMT

I had the exact same issue. I suggest the demo material for this specific case (loading a value to an input box, then updating and writing back) for this functionality be removed/updated.

Creating a basic write back solution with Qlik Cloud - YouTube

Video ‒ Creating a basic write-back example with Qlik Cloud | Qlik Help

Thanks for the solution/work-around @AfeefaTk!

Re: Automation Not Applying Variable Bookmark For WriteBack Solution

antonio_velarde — Tue, 12 Dec 2023 21:53:08 GMT

I had the same issue and your solution helped me a lot. Thank you very much.

Re: Automation Not Applying Variable Bookmark For WriteBack Solution

tomdegroot — Tue, 25 Feb 2025 14:28:55 GMT

Hi @AfeefaTk also now (today) this is a very useful post for me. Thanks again for the clarifications here.

I wonder if the updated demo video ever took shape?

Also, what is confusing to me (though not blocking) is the following. I was able to create the automation and run it from the UI, which is the intended use of course. When I used the "Run" button from within the automation though, the automation runs for several minutes with no output.

As I wrote this is not blocking and I can run the automation from the UI side.

Re: Automation Not Applying Variable Bookmark For WriteBack Solution

tomdegroot — Thu, 27 Feb 2025 11:35:32 GMT

I started from the input from @AfeefaTk from ‎2023-06-06 and the addition from @marcusva. Thanks guys!

Issue: after I hit the "Update" button, my variables (vDealName, vDealName2, vPrediction, vPrediction2) "stick" to a single value even if I selected another record from the table. So the value of vDealName2 and vPrediction2 did not change with the selection, as I would want them to.

I solved this by adding a "Set Variable Value" action for vDealName and vPrediction. I set the variable values to Null. I removed the actions "vDealName2 to =DealName" and "vPrediction2 to =vPrediction".

It seems to work for me now!