Good morning,
Rumana, it will not work if you copy & paste. You must insert each function separately. I am hoping someone can chime in and better articulate this.
Michelle
Hi Michelle,
I tried both. But, what I am struggling with is, how to insert Saved.Values(Of System.Int32) . As you can see the training Workflow use F LastRowIndex_WeeklySales to bring that function. If I write this using text builder, then I get the error message saying I have not defined the Save! I do not find any other way of defining the Saved.Values(Of System.Int32
How did your workflow worked without it? I don’t see it in your function in step #5.
Rumana,
I did not have to do this. But, if you feel that you need to do this...It is done in the Data Manager. You will isolate the variable and select the > to open the option:
Michelle
Hi Michelle, I re-did the workflow copy pasting and updating each resource/activity from the training workflow and it worked!!
Thank you so much for staying with me with this!
Rumana,
That is great to hear!!! This was the absolute most frustating project of them all! I am glad that you stuck with it as well!!!
Michelle
Agreed!! And thanks again!!
For some reason this course does not remember where I left off. Anyone else noticed this issue or knows how to get around it?
I was having a hard time with the write cell activities. I put the solution for listing the week numbers in the Sales Overview tab of the Book Inventory report below.
Write Cell Activity 1
- What to write: Select plus sign>CurrentSheet>Name
- Where to write: Select plus sign>bookinventory>custom input. Worksheet name: select plus sign>bookinventory>Sales Overview. Cell Address: select plus sign>Text> Type the letter A>select plus sign>Use Variable>LastRowIndex_BookInventory
Note that the letter A stands for column A. This lets the bot know to place the name of the current sheet from the WeeklySales report document into the first open cell in column A of the Sales Overview tab of the Book Inventory document.
yes!! I had to completely start from scratch and then it would populate, but then after running properly a few times then reverted back to showing a blank cell and the run failed -_- very frustrating
I have an issue with “Write Cell” Activity. When I just choose in What to Write “Last_Row_Index_WeeklySales”, then returns the acrtual row number, and not the value it has… Could somebody help me with that?
Thank you
BR
Lena
To get the cell value you should define it through custom input menu. First select sheet and then write “A” or etc. (corresponding column letter) to cell input box and then use variable Last_Row_Index_WeeklySales.
At the end cell should be something like ALast_Row_Index_WeeklySales.
Así, es un buen curso, para desarrollarlo bien hay que tomarse un tiempito. Me dificultó un poquitín que el material no esté en español. Saludos!