Possible to do If no job number from webpage then write remark to excel?

Hi,

Possible to write remark to excel column if there is no report in web system?

Below are an example as case study.

example for having report

example for no report ( shown empty )

IfActivity.xaml (9.8 KB)

example.xlsx (8.9 KB)

Use Element exists activity and select one of the images under the Actions column in your first image. If the element doesn’t exists, then this means there was no job found and then you can update the column accordingly in the for loop of your IfActivity.xaml file.

HI @Alfred_Gan

Surround the Get Text activity with Try catch

Use Get Text activity → Store it in GetVal

In the catch Use Assign activity

image

Use If activity pass the

String.IsNullOrEmpty(GetVal)

image

Regards
Gokul

1 Like

Hi,

Possible to tag this as IF “Show 0 to 0 of 0 entries” from the web then write remark to the remark column?

image

Thanks.

Yes @Alfred_Gan You can do like that. Use Element exist / Text exist activity

Hi @Gokul001

I tried this but seems like no respond after execute the process,

Would you advise

You need to give this invoice line in the get text and use it in Try catch block @Alfred_Gan

Hi @Gokul001

Yes did input this under in try catch but somehow no respond.

image

it should prompt log message if there is a NO

image

Indicate this text in the screens and check it @Alfred_Gan

Hi @Gokul001

Sorry it doesnt work either.

in this process am trying to achieve when there is no number and have text “Showing 0 to 0 of 0 entries” and then write a remark.

What doesn’t work. can you tell why it not working ? @Alfred_Gan

Hi @Gokul001 ,

It doesnt tell or prompt for message indicate that is 0

in this process, the robot will input number, if there is no showing means then it will write data, else will continue to read other job number.

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