Skip to main content

· One min read

We all know that Languare INtegrated Query (LINQ) is a technology that integrates query capabilities directly into programming languages. We also know that C# supports LINQ. LINQ enables you to write queries against strongly typed collections of objects by using language keywords and familiar operators.

IntelliBuddies process definition supports C# as part of the Expression dialog and thus enabling the designers to utilize LINQ and solve complex query problems with simple statements.

This blog talks about some of the typical scenarios where LINQ would make your jobs easy and there by making your process simple and easily manageable.

DataTable is one of the mostly utilized Data object when it comes to process flow. Here, you will see how effectively you could solve the most appearing problems on DataTable using LINQ.

Filtering DataTable Rows

Updating a specific row inside a DataTable

Deleting a row from DataTable

· 2 min read

Using Send Keys

Desktop automation activities sometimes fail to perform their tasks due to the unavailability of a UI element at runtime. When you encounter such scenarios, you can work around and perform automation using Send Keys activity. This blog explains multiple scenarios where Send Keys could be an alternative solution.

1. Selecting menu options

Typically, we select menu options using the Mouse Click activity. In case of unavailability of the element, Mouse Click fails to operate. In these scenarios, you can use the Send Keys activity with the '[DownArrow]...[Enter]' key to select the menu option. 'Send Keys' does not depend on the UI element to be available, ensuring that the actual mouse click activity is replaced with key-based menu operations.

2. Selecting the Radio Button

Typically, we use Select Radio Button to automate operations on Radio Button UI elements. However, when the activity fails due to the unavailability of the UI element, we could try to achieve the automation using Mouse Click activity. If this fails, then we can try with the Send Keys activity with the '[Space]' key to select the radio button.

3. Selecting the Checkbox

Typically, we use Set Checkbox State to automate Checkbox UI elements. If it fails, we can try to achieve the automation of Checkbox using Mouse Click activity. If this also fails, then an alternate way to automate is using Send Keys activity with the '[Space]' key to toggle the Checkbox state.

4. Populating Textbox

Typically, we use the Populate Text Field activity to fill in text inside a field. If it fails, another way to work is using Send Keys activity with the text data which writes inside the textbox.

Mouse Click and Mouse Move activity with X & Y Adjustments

When the Mouse Click or Mouse Move activities are unable to find a particular element(A), we can indicate the nearby element(B) and make the X & Y adjustment in the activity to reach that element(A).

Find the unavailable element location manually by adjusting the X, Y, or both values. Provide the extracted value to X Adjustment and Y Adjustment property of Mouse Click or Mouse Move activities

· 2 min read

Starting 01st of June, 2022, Gmail has completely removed unsecured access to their Mailboxes. Hence, you will not be able to access your Gmail using your Gmail user credentials from third-party applications. Instead, they recommend users enable two-step verification for their account and register the third-party application that you would let access to your Gmail with your consent. On successful registration of the third-party application, Gmail will provide you with App Password to be used to access your Mailbox from third-party applications.

Use the app passcode in following Email activities to input secured password for password field:

Generating App Password

Generating App Password is a two step process as stated below:

Turn on 2-Step Verification

To turn ON two-step verification for your Gmail account, follow the steps given below:

  • Open and login to Google Account.

  • Click on Google Account in the right top corner. Click on Manage Your Google Account.

  • In the left navigation pane, click on Security

  • Scroll down to the Signing into Google section and select the 2-Step Verification

  • Click on GET STARTED button.

  • Enter the password and G-Code sent to your mobile by clicking on the Text in verification page. - On successful validation, open the 2-Step Verification page.

  • Click on TURN ON

Generate 16-digit App Password

  • Go back or Navigate to the Security tab

  • Scroll down to the Signing into Google section and select the App passwords

  • In the App Passwords page, click on the Select app dropdown and choose Other (Custom name)

  • Enter an App name as IntelliBuddies and click on GENERATE

  • A 16-digit App Password will be generated and shown on the page.

  • Copy the 16-digit passcode and use this in Activity to provide a secure password.