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.4K All Categories
- 84 General
- 13 Training
- 212 Installation / Setup
- 1.2K Flows
- 111 Rules
- 275 Administration
- 214 Portal
- 498 General Q & A
- 716 Forms
- 350 Reports
- 3 Designer Extensions
- 48 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 8 Javascript Controls
- 188 Pages
- 5 Process Mining
- New Features
- 187 Datastructures
- 70 Repository
- 231 Integrations
- 30 Multi-Tenant
- 27 SDK
- 81 Modules
- 60 Settings
- 27 Active Directory
- 12 Version 7
- 36 Version 8
- 143 Lunch And Learn Questions