Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    alex-never
    @alex-never
    Hi all. I'm new to TaskT. Trying to automate my daily routines with Excel files. Maybe someone know how to find out [and save into variable] the address of current cell during the bot execution? Or at least a row index? There is an action to get the last row index, but in my case the active cell can be somewhere in the middle of the table. Thanks in advance.
    Iron-Hunter
    @Iron-Hunter
    @alex-never How about getting the current cell from excel using UI Automation by retrieving the value in the name box (name box shows the current cell that you are on), you can then add one or add a letter (ASCII) to move to the next cell vertically or horizontally. I never tried it but this would be how I would do it if I were you.
    Iron-Hunter
    @Iron-Hunter
    image.png
    I managed to do it but I don;t think this is the smoothest method, I basically click on the Name Box that contains the cell, I copy its contents and then paste it into a variable (Get clipboard text), then displaying a message with it
    image.png
    Like this:
    ⬆⬆
    alex-never
    @alex-never
    @Iron-Hunter, thanks. That should work.
    Iron-Hunter
    @Iron-Hunter
    @alex-never No problem, if you need any more help don't hesitate to ask
    alex-never
    @alex-never
    script.png
    Actually, there are some some questions. Still working with Excel action. With the Get Range i can copy to variable a range of cells. What is a correct action to paste them back in other Excel file (or sheet). Write Range is not working as it produces error. Write Row is also not working.
    error.png
    Iron-Hunter
    @Iron-Hunter
    Get Range returns a delimited string, while write range uses a datatable so you should simply switch out the Get range command with the get range as datatable command and select the output action as datatable to be able to use that variable with write range
    alex-never
    @alex-never
    Change of action to Get Range as Datatable helps. But, now you have to select at least 2 rows of data in the initial range, for example A1, F1. I assume, that one row is reserved for the Header (even if you do not select Add Header). If you select only one row (A1, F1), you get error during the execution Write Range (Index is out of range exception).
    Iron-Hunter
    @Iron-Hunter
    I do not really understand your question but I will try to clarify how both functions work.
    Get Range needs 2 parameters, the first one is the starting cell to start retrieving from and the second one is the last cell to end retrieving at. It can start in A1 for example and End at A10 so that way the range now contains the column from these cells or you can get a whole table ex. A1 to B10 and that way you get everything in that 2 column table. So to clarify even more, if you have a square that you wish to copy on a graph you can do so easily if you know the coordinates of the corners. The first cell location in the function acts as the location of the top left corner of the square while the last cell location in the function acts as the location of the bottom right corner of the square. As such you can specify the range from any cell to any cell which will give you a matrix containg the data but when you write it you only give it the starting cell and it will start placing all the data from that cell (Top left corner of the table) and fill it as necessary
    If you still find it difficult to understand I am willing to help you more even through an online call or something similar
    alex-never
    @alex-never
    My test use case is quite simple. I need to copy data from cell A1 to F1 and put it starting with cell A5. So, Here is my config:
    WRITE_R.png
    GET_R.png
    alex-never
    @alex-never
    And here is the error
    r_error.png
    My assumption, is that because i try to get values only from 1 row. When i change Get Range to A1 - F2, then there is no errors.
    But i need only values in one row (not the full row, only from a range).
    alex-never
    @alex-never
    And one more question in parallel. Where can i find the description of Filter configuration for Outlook actions? There are some in the example scripts and as i can see they differs from what is actually used in Outlook. For example, in Outlook [from] in taskt [SenderName]. Also how can i use partial matches, like 'Invoice *'?
    Iron-Hunter
    @Iron-Hunter
    @alex-never Hi, as for the first question remove the curly braces on the variable name. Unfortunately I don't think I can help you regarding the second questions since I still haven't gone in depth into the outlook and email commands
    alex-never
    @alex-never
    @Iron-Hunter, the curly braces are working fine. Here is an example of working code.
    working.png
    But, as soon as i change F2 to F1, it produces error.
    Maybe this is not the way i should proceed with copying of a range in one row?
    Iron-Hunter
    @Iron-Hunter
    @alex-never For me when I use the curly braces around the variable I get an error, however I tried many different examples using Get and Write Range and I can't seem to reach your error so I would have to take a look at the excel file you are working with as well as the bot file to be able to help you further
    alex-never
    @alex-never
    @Iron-Hunter test table is simple as that
    excel.png
    Ironhunter95
    @Ironhunter95
    @alex-never And what exactly are you trying to do with it?
    alex-never
    @alex-never
    @Ironhunter95 , the idea is to copy a range from one row (not the full row) and paste into another. This is just a test example. I need values A1:F1 to be copied to A5:F5.
    Ironhunter95
    @Ironhunter95
    aaaaasdasd.png
    aaaaasdasd.png
    I just did that, no problesm
    problems
    want me to send the script?
    levandox
    @levandox
    Is takst server available?
    alex-never
    @alex-never
    @Ironhunter95 , please, attache the script. because for some unknown reason similar configuration doesn't work for me. i do not get any errors, but nothing is copied in the file.
    git-volver
    @git-volver
    I want to start to use taskt, but I am facing some difficulties to do with a simple case, that is, log in to a site with name and password in a web page, just it. How to send the credential to work? and how to do this without type the password text plain? I do not find such a sample. Regards!
    Ironhunter95
    @Ironhunter95
    @alex-never
    @git-volver , what I can think of off the top of my head is using the specific class or element of the text boxes for login username and password and then sending keystrokes there..as for the password the only way I can think of to make it secure is that you run a seperate bot at the start to encrypt the passcode with a certain key and place it in a document..then in the login bot you can retrieve that encrypted passcode and decrypt it and use it..There may be other ways but this is what I can think of
    sorry if it wasn't much of a help
    git-volver
    @git-volver

    @git-volver , what I can think of off the top of my head is using the specific class or element of the text boxes for login username and password and then sending keystrokes there..as for the password the only way I can think of to make it secure is that you run a seperate bot at the start to encrypt the passcode with a certain key and place it in a document..then in the login bot you can retrieve that encrypted passcode and decrypt it and use it..There may be other ways but this is what I can think of

    Ok, I will think about it, thanks by your collaboration!

    alex-never
    @alex-never
    @Ironhunter95 , thanks for file. I have included my excel file, but unfortunately it still produce the same error - out of range. Maybe the reason in versions of Taskt (v3.5.0.0) or Excel (MS Office 365 Pro Plus).