Datatable to Web Table

Help
1

Afternoon All

So the scenario is I have a datatable with invoice line items stored. I need to enter them into separate Lines in an web based accounting platform.

I am using a For each row enter the description, then the price and the qty, but not sure how it to go to the next line and enter the next row data in a new line on the web app

2

Hi,
Can you please share screenshot of your web table?

Thank you!

3

Hi Sat

image
image1208×550 20.2 KB

4

Check if the element have any attributes for Row Id. And check if it increases in sequence. If so, you can use a incremental counter in place of RowId.

1 Like
5

Hi

I have foudn out that all the rows and columns are signified in the selector

idx is the row number,

I did an assign before the For Each Row, and gave it a value IDX = 1

but when I try and change the selector to idx=IDX but it doesn’t work it just changes it back to the above

6

If Idx is the sequence number starting from 1 and it is incremental, the use selector IDX=Idx.tostring (variable as int) then as soon as you done with one entry assign idx=idx+1

7

Thanks for your reply this is what im getting

image

this is the sequence

image
image433×783 19.8 KB

8

@Jersey_Practical_Sho, You need to specify IDX within double quotes.

tablerow = ‘" + IDX.tostring + "’

9

I have its right a the bottom in the Assign

10

Give selector as

<html title='Xero | Edit Bill | MasonBreeseTest' /> <webctrl parentid='ext-gen18‘ tag='TABLE' idx:'1' /> <webctrl tableCo|='3' tag='TD' tableRow='" + IDX.tostring + "' />

1 Like
11

Your variable should be out of single quote and start n end with +

12

Is it supposed to change to this after you’ve input it?

image

13

Can you try sending special key(Send Hotkey Activity) like - [Tab] to go to next line and then follow the process using for each row activity.

14
  • Paste the below string in selector field without opening it.

“ <webctrl parentid=‘ext-gen18‘ tag=‘TABLE’ idx:‘1’ /> <webctrl tableCo|=‘3’ tag=‘TD’ tableRow=’” + IDX.tostring + “’ />”

image

image
image800×190 6.36 KB

15

This combined with the IDX incrimination worked successfully. Sometimes the simple answer is the best answer :wink:

16

Hi all,
I’m having the same issue and i have done all the proposed solutions and still yet no result, can anyone please share theirs.