How to get max value from one table and use it to insert into another table?

Wappler General How To
#1

I have 2 tables, I want to get the max value from the table 1 field and then use that value as part of the insert to table 2.

How do I set this up in the API Steps?

#2

Add a database query step and use the aggregate functions to find the max value of a column. Add an alias for it:

Screenshot 2021-09-08 at 17.10.33
Screenshot 2021-09-08 at 17.10.331121×654 29.3 KB

Then add the insert step and select the alias from the query step:

Screenshot 2021-09-08 at 17.15.48
Screenshot 2021-09-08 at 17.15.48982×898 50 KB

#3

Thanks @Teodor, realised where I was going wrong from your screen shots as I was using a single result query to get the max.

1 Like