Forum Engagement Daily Reports

[system]

Daily Forum Report | 22 May 2021

Top 3 Topics with Most Views

Condition on excel sheet made by @rpa13 with 31 views.

Count number of files with variable made by @Saurabh_Grover with 27 views.

KintoneのHTTP要求(POST)の作成方法について made by @Timmy0303 with 25 views.

Top 3 Topics with Most Replies

Condition on excel sheet made by @rpa13 with 23 replies.

KintoneのHTTP要求(POST)の作成方法について made by @Timmy0303 with 12 replies.

If we select on the any type of browser its should open it our system ,if not in your system it shows the app is not there made by @kowshik with 11 replies.

Top 3 Users Who Posted The Most

@prasath17 made 11 posts!

@NIVED_NAMBIAR made 10 posts!

@rpa13 made 10 posts!

Top 3 Most Liked Posts

This post made by @Hiba_B received 3 likes!

Add columns if certain rules are met

Hi @abhide ! Yes you can exchange it by index values. I have assumed that you treat only with integers. So I changed the conversion + changed with index instead of column names: [image] Here is a suggestion that could work with your case: Cumulate_numbers.xaml (6.9 KB)

This post made by @prasath17 received 2 likes!

Match two excel columns and write to new column( advanced)

@Duleepa_Krishan - Here you go… [image] My Sample Output [image] Here’s how you have to code it… [image] If Condition CurrentRow("comment").ToString.Contains("_") Inside Then Condition CurrentRow("comment") = System.Text.RegularExpressions.Regex.Match(CurrentRow("comment").ToString,"\d+(?=_)").Value Inside the Else write an another if condition(This will check if first 2 characters are alphabets) system.Text.RegularExpressions.regex.Match(CurrentRow("comment").ToString,"^[A-z]{2}"…

This post made by @Adrian_Star received 2 likes!

Condition on excel sheet

I checked the flow of @Hiba_B and it works well. When working with Sheet4, you need to customize the column names in the workflow. Column order_number to order. Column sku to *product [image]

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Match two excel columns and write to new column( advanced)

@Duleepa_Krishan - Here you go… [image] My Sample Output [image] Here’s how you have to code it… [image] If Condition CurrentRow("comment").ToString.Contains("_") Inside Then Condition CurrentRow("comment") = System.Text.RegularExpressions.Regex.Match(CurrentRow("comment").ToString,"\d+(?=_)").Value Inside the Else write an another if condition(This will check if first 2 characters are alphabets) system.Text.RegularExpressions.regex.Match(CurrentRow("comment").ToString,"^[A-z]{2}"…

This solution provided by @AndyMenon received 1 likes!

UiPathRobot.js - I have the localhost page running. But there is no reaction from page

SOLVED! The path to the script in the Boiler plate application is obsolete. This line in the index.html file must be replaced with the one pointing to download.uipath.com <script src="https://uipathrobot.azureedge.net/Latest/UiPathRobot.js"></script> (Obsolete!) <script src="https://download.uipath.com/js/1.2.1/UiPathRobot.js"></script> (Valid)

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.