Data Table type into google form

Help Robot
1

Hi all, I am currently trying to extract row of numbers to be input into a google form, but every time i press run file, when it reaches the SKU part, the whole rows of numbers will be type into the same “SKU001”. Is there any ways to separate the numbers into their each “SKU”. Example at picture as attached.

image
image856×1132 34.2 KB

1 Like
2

Hi @Allyson_Ang,
Welcome to UiPath Community.

Are you getting row of numbers from data table?
If yes,then those numbers resides in single cell?

3

Hi @sangeethaneelavannan1 yes i am getting just one row of numbers from data table, but the numbers are not in a single cell, it is in a different cell. Picture as attached. May i know if it is possible to get just one row of data and input it into the google form as i have posted above?

image
image286×1038 4.63 KB

4

Well then you have to use for each row in data table inside that we need to have type into for SKU and counter for each iteration.Giving the counter inside type into selector to enter the quantity number in each field separately.Counter should be incremented for each iteration.
Dt.row(“qty”) should be in type into activity.

5

hi @sangeethaneelavannan1 thank you so much for your help, do you have a screenshot that I can make reference to? as i am just a few weeks old to UI path, so some things i may not be really sure yet. appreciate your help on this!

6

If I have sample website I could do.please share the screenshot of your selector.I can help you

7

Hi please do help me from SKU Number 001 onwards, you can just create an excel from your side to fill in any numbers into the google form. Really appreciate if you could show me what you input into UI Path to make it work. Thanks!

8

May I know excel sheet table format @Allyson_Ang

9

Hi Sangeetha, the table will look like this, I only need the “Qty” row data into the google form. Thank you!

Image.jpeg
Image.jpeg1072×677 110 KB

10

@Allyson_Ang
As you requested,
Main.xaml (14.3 KB)

image
image1333×548 39.4 KB

intcount default value is 17 and it is incremented by 4 for each iteration.
P.S: I have used c# and windows combination project
New Microsoft Excel Worksheet.xlsx (8.2 KB)

1 Like
11

Hi @sangeethaneelavannan1 you have been a great help! I have found a way to solve my issues with your guidance! Thank you!

1 Like
12

That’s great.Mark it as solution if it helps you

13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.