Single on-click event to store multiple/all rows of a datagrid into a data master as new rows?

Arnab Dutta shared this question 5 years ago
Answered

I have a few calculated data items listed on a data grid on one screen. I want to insert these into a datamaster as new rows on clicking a submit button. How can this be achieved?

Comments (6)

photo
1

Hi John, Thanks for your reply. However these doesn't address my problem.


I want to move data (multiple rows) from a datagrid into a datamaster as multiple records through a single action. For eg:


Datagrid:


First_Name Last_Name Age Gender


Aron Ramsey 23 M


Joe Hart 25 M


On clicking Submit once, 2 new records should get inserted into a Datamaster. How to map the datagrid fields to the datamaster fields in the New action for this to occur?

photo
1

Let me dig deeper if it is possible then I will let you know how to do it.

photo
1

I basically created two data masters. I called them 'test' and 'new'. In 'test' datamaster, I have three records


firstname lastname age gender


carla doe 41 f


kobe bryant 22 m


lebron jame 23 m


while in 'new' I have one record


firstname lastname age gender


george washington 55 m


The way the prototoype works is only the rows of the checkboxes in 'test' data grid will be added to the 'new' data master. Take a look at the screen shots below. I can also send you the prototoype if you like. Just send a request to jim.support@justinmind.com.


9d0f0afb8001ef9569c4f1ae129becb8

photo
1

Thanks.This is one of the nice workarounds to what I am trying to achieve. Haven't yet figured out a way to do this with a single event execution.

photo
1

I have a similar problem as the original poster. I have a page with a data grid of products. The page also has a checkout button, that when pressed needs to add each row in the data grid to a data master. Only the first row in the data grid is being added with the New data master action. Is there a way to have it loop through and add every row? The proposed solution above does not solve this problem.