How to replace Empty string Box value with 0

[Ishan_Shelke1 (Ishan Shelke)]

I Have column which looks like this

I want my program to automatically take the value as 0 when it find an empty input box

PS - My input box is of number type

I tried but it returns an error as Input string was not in correct format

Any solutions willl be appreciated

[ashwin.ashok ((TheCodingTheory))]

Hi @Ishan_Shelke1 ,

Could you give this a try?

If(IsNothing(CurrentRow("Lock Qty")) OrElse String.IsNullOrEmpty(CurrentRow("Lock Qty").ToString), 0,CInt(CurrentRow("Lock Qty").ToString))

Kind Regards,
Ashwin A.K

[Ishan_Shelke1 (Ishan Shelke)]

Didn’t get you Can you tell me what to put in the condition of if and wat should I put in else ?

[ashwin.ashok ((TheCodingTheory))]

Hi @Ishan_Shelke1 ,

If you are retrieving values from an InputBox, and storing it to an integer, then use this to achieve the operation in a single step →

yourVariable = If(IsNothing(yourVariable) OrElse String.IsNullOrEmpty(yourVariable.ToString), 0,yourVariable)

If you want to use an If Activity, then use this instead →

IsNothing(yourVariable) OrElse String.IsNullOrEmpty(yourVariable.ToString)

Then → 0
Else → yourVariable = yourVariable

Kind Regards,
Ashwin A.K

[ushu (Usha kiranmai)]

@Ishan_Shelke1 Is this column that you were representing is in web application