Insert Calculated column in a table
Comments
-
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 ?
-
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." -
Yes I tried that, But the Converter is not converting the string to integer. I get the Output as Zero.
-
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;
Howdy, Stranger!
Categories
- 4.5K All Categories
- 87 General
- 13 Training
- 213 Installation / Setup
- 1.2K Flows
- 112 Rules
- 277 Administration
- 215 Portal
- 503 General Q & A
- 722 Forms
- 356 Reports
- 3 Designer Extensions
- 47 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 8 Javascript Controls
- 190 Pages
- 5 Process Mining
- New Features
- 187 Datastructures
- 72 Repository
- 238 Integrations
- 30 Multi-Tenant
- 27 SDK
- 81 Modules
- 60 Settings
- 26 Active Directory
- 12 Version 7
- 37 Version 8
- 143 Lunch And Learn Questions