Select a specific row in a table and get the corresponding data master row
Hi,
I have a table called vendor_list which is basically a data grid to which I have added an additional column called "Select" and where I have placed a check box. The table is populated using a data master called Vendors.
What I would like to do is to select all the data in Vendors where the "Select" check box is set to true in the Vendor_List table.
Thanks
First, create the event that will filter the Data List according to the selected (true) checkboxes. Create an "On Click" + "Set Value" event for the filter button, with the Data List as the target of the set value action. Then, for the value, click 'calculated' and create this expression:
Then, we'll create a 'revert' button that will reset the Data List filter. Create an "On Click" + "Set Value" event for the revert button, with the Data List as the target of the set value action. For the value, click the 'from current data master' radio button.
Next, we'll create the event that will allow you to change the checkbox values, so that this Data List is truly dynamic. Select the checkbox in the Data List and create an "On Click" + "Data Master Action - Modify" event. Create this value:
(first space is the data list, Field 2 is the checkbox from the Data List)
Lastly, we'll create another button that will populate an Input Field with the results of the filter. On this button, create an "On Click" + "Set Value" event, with the Input Field as the target of set value action. For the value, click 'calculated' and build this expression:
(first space is the Data List, second is the input field from the Data List)
Check out the attached prototype to see the example file.
First, create the event that will filter the Data List according to the selected (true) checkboxes. Create an "On Click" + "Set Value" event for the filter button, with the Data List as the target of the set value action. Then, for the value, click 'calculated' and create this expression:
Then, we'll create a 'revert' button that will reset the Data List filter. Create an "On Click" + "Set Value" event for the revert button, with the Data List as the target of the set value action. For the value, click the 'from current data master' radio button.
Next, we'll create the event that will allow you to change the checkbox values, so that this Data List is truly dynamic. Select the checkbox in the Data List and create an "On Click" + "Data Master Action - Modify" event. Create this value:
(first space is the data list, Field 2 is the checkbox from the Data List)
Lastly, we'll create another button that will populate an Input Field with the results of the filter. On this button, create an "On Click" + "Set Value" event, with the Input Field as the target of set value action. For the value, click 'calculated' and build this expression:
(first space is the Data List, second is the input field from the Data List)
Check out the attached prototype to see the example file.
You just have to build the expression filter(vendor_list, checkbox), that would return all the rows that have the checkbox clicked and then use that expression as the value for a variable for instance. Have a look at this video http://www.justinmind.com/tutorials/a...
You just have to build the expression filter(vendor_list, checkbox), that would return all the rows that have the checkbox clicked and then use that expression as the value for a variable for instance. Have a look at this video http://www.justinmind.com/tutorials/a...
Hi,
I went through the tutorial and then tried to implement selecting the row based on a On Click event on the checkbox. I set the variable Vendors on the click of the checkbox to Row_1. Here is the image:
Then, I went to the following screen and tried to test the variable set in the previous screen by getting the values set in Vendors using the Select function. Here is the image:
However, I did not get any values in the text box which is populated on a On Page Load.
It would be great to see a debug window display these variables as we navigate from screen to screen.
Am I doing something wrong?
Thanks
Hi,
I went through the tutorial and then tried to implement selecting the row based on a On Click event on the checkbox. I set the variable Vendors on the click of the checkbox to Row_1. Here is the image:
Then, I went to the following screen and tried to test the variable set in the previous screen by getting the values set in Vendors using the Select function. Here is the image:
However, I did not get any values in the text box which is populated on a On Page Load.
It would be great to see a debug window display these variables as we navigate from screen to screen.
Am I doing something wrong?
Thanks
First, create the event that will filter the Data List according to the selected (true) checkboxes. Create an "On Click" + "Set Value" event for the filter button, with the Data List as the target of the set value action. Then, for the value, click 'calculated' and create this expression:
Then, we'll create a 'revert' button that will reset the Data List filter. Create an "On Click" + "Set Value" event for the revert button, with the Data List as the target of the set value action. For the value, click the 'from current data master' radio button.
Next, we'll create the event that will allow you to change the checkbox values, so that this Data List is truly dynamic. Select the checkbox in the Data List and create an "On Click" + "Data Master Action - Modify" event. Create this value:
(first space is the data list, Field 2 is the checkbox from the Data List)
Lastly, we'll create another button that will populate an Input Field with the results of the filter. On this button, create an "On Click" + "Set Value" event, with the Input Field as the target of set value action. For the value, click 'calculated' and build this expression:
(first space is the Data List, second is the input field from the Data List)
Check out the attached prototype to see the example file.
First, create the event that will filter the Data List according to the selected (true) checkboxes. Create an "On Click" + "Set Value" event for the filter button, with the Data List as the target of the set value action. Then, for the value, click 'calculated' and create this expression:
Then, we'll create a 'revert' button that will reset the Data List filter. Create an "On Click" + "Set Value" event for the revert button, with the Data List as the target of the set value action. For the value, click the 'from current data master' radio button.
Next, we'll create the event that will allow you to change the checkbox values, so that this Data List is truly dynamic. Select the checkbox in the Data List and create an "On Click" + "Data Master Action - Modify" event. Create this value:
(first space is the data list, Field 2 is the checkbox from the Data List)
Lastly, we'll create another button that will populate an Input Field with the results of the filter. On this button, create an "On Click" + "Set Value" event, with the Input Field as the target of set value action. For the value, click 'calculated' and build this expression:
(first space is the Data List, second is the input field from the Data List)
Check out the attached prototype to see the example file.
Replies have been locked on this page!