topic Re: Creating a basic write back solution with Qlik Cloud in Qlik Automate

Creating a basic write back solution with Qlik Cloud

salmankojar — Tue, 23 May 2023 04:09:31 GMT

Hey Guys,

i am trying to replicate a write back solution with qlik cloud as shown in Do More with Qlik Playlist in youtube but i am not getting the same result as shown in that video.

If i select a particular row and then click on update button it works properly but if i type something in input box and then press enter button then update doesnt works at all and it also overwrite the variable assigned to that particular variable input box permanently. can you help me with this problem?

The YouTube video link is here: https://youtu.be/hYER2nGKctM.

Re: Creating a basic write back solution with Qlik Cloud

J_Lindberg — Fri, 26 May 2023 07:54:37 GMT

Hello @salmankojar, difficult to tell what might go wrong here. Can you share the app and automation that you've created?

Re: Creating a basic write back solution with Qlik Cloud

salmankojar — Fri, 26 May 2023 12:51:03 GMT

Sure..i have attached app qvf file and json file for automation...do let me know if you need anything else.

Thankyou..

Re: Creating a basic write back solution with Qlik Cloud

J_Lindberg — Fri, 26 May 2023 14:08:46 GMT

It seems as if the automation is missing the input blocks. To add them follow "2. Configure the automation" as described here: https://community.qlik.com/t5/Official-Support-Articles/How-to-build-a-write-back-solution-with-native-Qlik-Sense/ta-p/2059047
(and displayed here in the video: https://youtu.be/hYER2nGKctM). Notice that these blocks should be connected to the start block, not after the blocks you already have in the automation.
Once added you should be able to pick up the values from the app and use that to update the data source.

Re: Creating a basic write back solution with Qlik Cloud

salmankojar — Mon, 29 May 2023 04:15:37 GMT

i have done exactly as shown in the post and youtube video you mentioned.My records gets updated but only for the selection but when i manually input some data in variable input box then the update doesnt works and it permanently overwrites the variable i created for that variable input box with the input i manually entered..

Re: Creating a basic write back solution with Qlik Cloud

AfeefaTk — Tue, 06 Jun 2023 07:26:38 GMT

Hi @salmankojar

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: Creating a basic write back solution with Qlik Cloud

salmankojar — Tue, 06 Jun 2023 09:51:14 GMT

hi,

i tried removing expression from definiton field of all variables as you said..but after that any selections made on table doesnt pass in variable input box for all variables.what do you suggest now?

Re: Creating a basic write back solution with Qlik Cloud

AfeefaTk — Wed, 07 Jun 2023 11:44:30 GMT

Hi @salmankojar

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.
Add Reload Data action after execute automation.
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(check sheet name: button config) configured following the above steps for your reference.

Please let me know if that works.

Thanks