Insert Calculated column in a table

Unknown

Insert Calculated column in a table

Unknown

I am trying to insert a calculated value into a column.

For example : If the value already present is 5, then I wanted to insert a next row with value 6.
I used TextMerge.plain and entered this way, value + 1.
But it didnt work.

Can you please suggest a better way ?

Unknown

Hello,
you want to create a converter flow that uses an Add step to add a constant of 1 to your input. You can do this by creating a flow, and choosing
behavior type Converter Flow".
Thank you."

Unknown

Yes I tried that, But the Converter is not converting the string to integer. I get the Output as Zero.

Unknown

I am Running a query, which gives NULL value for the first time and then using a form I am inserting the values to the table and Connected the submit button to the query again, The query has to execute again and give me the inserted data, but still its giving me the NULL value.(but when I run the query in the SQL Server Management studio, it gives me the correct result).
Query: SELECT id, max(Attempts_Made) AS Attempts_Made FROM delivery_plans_history where id=test123 GROUP BY id ORDER BY Attempts_Made;