Is there a way to insert a new record using a form object's data along with separate key value? Or do I need to manually write the SQL statement or use the key value pairs changeset? [Screenshot 2023-04-19 at 10.12.06 AM]

Hi @dru_nasty :wave: Definitely possible by using Object.assign like this: {{ Object.assign(form1.data, {"new":123}) }} [image] Or using the spread operator : [image] Let me know how this works for you!

Can i insert form object and key value together?

💬 App Building

dru_nasty April 21, 2023, 11:54am 3

Exactly what I needed, thank you!

Mysql insert with different javascript objects in raw sql

Topic		Replies	Views
Create SQL Insert Statement from a form input 💬 Queries and Resources sql	5	6797	August 2, 2023
Exclude specific form fields from data object when inserting new row on database 💬 App Building form	3	807	April 24, 2024
Update row from only form's changed value 💬 App Building sql	7	1212	April 29, 2024
App 'addRow' running then throwing an error 💬 App Building bug , sql , table	11	656	March 22, 2024
Insert records into two distinct tables upon form submission? 💬 App Building form	4	1387	August 2, 2023

Can i insert form object and key value together?

Related topics