Forum Engagement Daily Reports

[system]

Daily Forum Report | 02 February 2022

Top 3 Topics with Most Views

How to extract using both substring and split method made by @ydash999 with 43 views.

Write range date formatting made by @kl_kl with 41 views.

Robot Names made by @Balan with 41 views.

Top 3 Topics with Most Replies

Write range date formatting made by @kl_kl with 15 replies.

How to get sheets from Excel or check if sheet name exist made by @vlast with 14 replies.

Robot Names made by @Balan with 13 replies.

Top 3 Users Who Posted The Most

@ppr made 22 posts!

@Gokul001 made 19 posts!

@supermanPunch made 18 posts!

Top 3 Most Liked Posts

This post made by @Sudharsan_Ka received 7 likes!

Monthly Forum rewards - January 2022

Congratulation All the winners

This post made by @Palaniyappan received 7 likes!

Monthly Forum rewards - January 2022

Congratulations everyone And thanks for this initiative Awaiting to share and see great ideas Cheers

This post made by @Gokul001 received 6 likes!

Monthly Forum rewards - January 2022

Congratulation to all the reward winners

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 3 likes!

How can I use if condition for perticular browser window?

HIb @Jalan_Pranav For getting an bool Value. you can use “Element Exist Activity” Indicated the appropriate browser → Create an output variable in the properties panel (BoolBrowser) You can use “IF condition” → BoolBrowser Then → “Kill Process” [image] Hope it will help you Regards Gokul

This solution provided by @supermanPunch received 2 likes!

How to add all key value of a dictionary

Hi @ramadhani.sheffi , For a more dynamic approach to Sum up all of the Values of the Dictionary (Provided all values are numbers), we can use the below Expression : myDict = new Dictionary(of String, String) From {{"A","10"},{"B","20"}, {"C", "30"},{"D","40"}} TotalSum = myDict.Values.Sum(Function(x)CDbl(x)) Where TotalSum is of the data Type Double, myDict is of Data Type Dictionary(Of String,String)

This solution provided by @supermanPunch received 2 likes!

String Not Recognized as a Valid Date Time

Hi @Dr_Raza_Abidi_PhD , As per the Data that was Provided, the dates read by the Read Range activity is converted into an OADate representation and Hence we were not able to convert the Date properly since it is a Double value. By Debugging we can get to know the value of the Date at Run Time. [image] For Handling such changes in datetime values, we could use a Try Catch on the First Conversion in Assign and then in the Catch Block we could use the Conversion from OADate as Shown in the Imag…

---

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.