Using a Datatable variable to fill a Google form using TypeInto activity

[Nat_Khoo]

Hi All,

I need to fill up 12 different blanks in one Google form, so need data from 12 cells under 1 column.

I used the Read Range activity and saved the data table variable called DT.

However, I encounter the following problem when I try to use the TypeInto activity to fill in the blank in my Google form.

Is there any way I can iterate through all 12 rows and fill up the form at once?

[mahmoud.zaky]

Hi Nat,
Just add .Tostring and final command will be DT.Rows(0).Item(0).Tostring but it will be better to add For each Data Table and loop on the whole DT without adding that you can check below for more info and update us if you want any support

Fill data from EXCEL on WEB FORM - UiPath RPA Tutorial

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @Nat_Khoo,

Data Table type into google form

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

Hope this help

[Nat_Khoo]

Thank you for the suggestion. It works!

[Nat_Khoo]

Hi,

Thank you for this suggestion as well. I learnt something new!

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@Nat_Khoo Thats great.

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…