Community > Ideas
26 views
Community Review

Pass parameter from action to an action below it

Pass a parameter created from one action to an action below it. In other words, if I were to have a form where the user submits their name and info and there is an SQL form action to add them to the database which creates a new database record and that record has an identity key (int, primary key) then we could have the next action pull the id from the newly created data row.

For example: you have a table 'Members' and table columns: id, firstname, lastname, email, phone

---------------------------------------------

Action #1: SQL Query
INSERT INTO Members (firstname, lastname, email, phone)
VALUES ([FirstName], [LastName], [Email], [Phone])

Action #2: Show Message

Hello!

Thank you, you are member #[ID]

--------------------------------------------

 

The ID number being the identity (primary key) of the newly created data row.

mic4458 mic4458
published 04/06/2023 16:59
Add Comment
Last Activity 04/07/2023 05:20