AbhishekSrivastava - Tuesday, March 1, 2016 11:56 PM:
Hi friends,
I create a list name "Test" and create an item type name "Testing". Now i Want if i select Label like (1,2,3) then i get the values like (Test1, Test2, test3) respectively. So is that possible to retreive value like that.
Kindly share the soluttion,
Thanks
Abhishek Srivastava
tstickel - Wednesday, March 2, 2016 11:10 AM:
The easiest way to do this is for the Value1 field on the Testing form to be defined as Field Type = Text and to have its Data Source set to the same data source as the Label field. This implies that Value1 is not a property of the Testing itemtype.
You probably would want the Value1 field to be disabled on the Testing form so that the user can not directly update it. Below is a screen clip of a Form where Problem Closed has Field Type = Dropdown (linked to a property that uses the Out-of-the-Box Innovator True/False List). I added the Text2 field to the form definition and pointed it to the same data source as Problem Closed. When Problem Closed is set to True or False, then Text2 is automatically updated to show 1 or 0.
AbhishekSrivastava - Thursday, March 10, 2016 1:18 AM:
Hi tstickel,
I explain you the scenario, Actually i make an item type "test" and make a three field :
1. Customer Name (dropdown)
2. NDA From (Date Property)
3. NDA To (Date Property)
4. NDA Status (dropdown)
So i also have Customer Item Type which have all fields as above mentioned.
Now i want if i select Customer name in Test Item Type or type 2-3 words then auto-search and select then rest of the fields auto fill before saving an Item, Value fetch from Customer Item Type.
So can you please suggest me .
Thank You
Abhishek Srivastava
AbhishekSrivastava - Thursday, March 17, 2016 5:31 AM:
tstickle,
I want to know like when i use filter list:
Vendor type (List)
Vendor Name(Filter List)
NDA Status (Filter List)
When i filter by vendor type then Value comes in NDA Status as per Vendor name selected on form that is ok but not saved on search grid but when i double click the row then show in a form .
Need Help.....
Abhishek Srivastava
AbhishekSrivastava - Thursday, March 17, 2016 5:44 AM:
tstickel - Thursday, March 10, 2016 9:39 AM:
Abhishek
Before I can make a suggestion I need to know some more about your scenario.
Suppose you create a new Test item. You select a Customer name for the Test item and the values for the three NDA properties are populated in the Test item from the Customer item.
Then sometime later you update the values for one or more of the Customer item NDA properties. Do you want the Test item to be automatically updated to reflect the new NDA values? Or should Test item retain the original NDA values?
Are the Test item NDA values read-only or will the users be able to update them on the Test item form?
AbhishekSrivastava - Thursday, March 10, 2016 11:28 PM:
tstickel
I want the Test item to be automatically update to reflect the new NDA values.
Test Item NDA values Read Only.
Thank You
Abhishek Srivastava
tstickel - Saturday, March 12, 2016 10:06 AM:
One solution is to modify the definition of Test itemtype to use Foreign properties. Foreign properties will allow Customer data to
be dynamically combined with Test data. The Customer data will not be duplicated to the Test table in SQL Server. Instead
Innovator will automatically retrieve the related Customer data each time a Test data record is retrieved.
This would be done as follows:
1. Change the definition of the Customer Name property to have Data Type = Item. Then click in the Data Source column and press
the F2 key. Innovator will display an Item Type search window, search for your Customer itemtype and select it.
This tells Innovator that you want to dynamically relate Customer data with each Test item.
2. For each Test itemtype NDA property do the following. Change it to have Data Type = Foreign. Then click in the Data Source
column and Innovator will automatically display a Foreign Property Selection Tree. Expand the tree node for Customer and select
the desired NDA property (e.g. if you are defining the Test "NDA From" property then select the Customer "NDA From" property on
the selection tree.
This tells Innovator which Customer properties you want associated with Test items.
3. Modify (or create) your Test form. If Customer Name is already defined on the Form, then I would remove it and then re-add it
to the Form (at least ensure that Customer Name has field type = Item on the Form definition). Add the 3 NDA properties to the
Form.
Now this is ready to test. Create some Customer records if you have not already done to. Then create a new Test record.
Click in the Customer Name field on the Form and press the F2 key (or just click on the 3-dot icon). Innovator will present
a search dialog where you can search for and select a Customer record. After you complete the selection, Innovator will
automatically display the related Customer data on the Test form.
This link between Test and Customer data is dynamic in that if sometime later you modify the NDA values on a Customer record
then when you view a Test record it will reflect the latest values.
AbhishekSrivastava - Monday, March 14, 2016 1:16 AM:
Hi tstickel,
I know above procedure as you suggested, but actually i dont want a search window , Actually requirement is a dropdown box and when i select the value then relevant value comes under the respective fields in a form.
but i want to fetch from customer item type, So procedure is same to fetch value from customer but only pattern is different like i want dropdown in place of window search and value populate when i select value from dropdown.
So kindly help me on that....
Hope you understand & thanks for helping... :)
Abhishek Srivastava
tstickel - Tuesday, March 15, 2016 11:10 AM:
Abhishek
If your requirement is that the Customer must be select via a drop down then one approach would be:
1. For the Test itemtype definition, change the definition of the Customer Name property to have Data Type = Item.
2. For the Test form definition, add an HTML field to the form to define a pull-down widget. In the code below I have assumed that the name of the Customer Name property on the Test Itemtype is customer_name and you have also used customer_name as the Form field name.:
<select name="customer_name" size="1" style="font-weight: bold" id="customer_name"></select>
<script type="text/javascript">
function onchangecustomer_name(event) {
event = window.event || event;
var target = event.srcElement || event.target;
var tmpSelectedVal = target.options[target.selectedIndex].value;
if (window.handleItemChange) {
handleItemChange('customer_name', tmpSelectedVal);}
}
document.getElementById("customer_name").addEventListener("change",onchangecustomer_name, false);
</script>
3. Write a javascript method that will invoked via an onFormPopulated event. This method would need to read all of the Customer items, retrieving the id and customer name for each item. The method would then load the HTML select control with customer name as the label and id as the value. You can find many examples of javascript code to dynamically load a <select> via Google.
4. When a user selects a Customer name from the drop-down, then the handItemChange code from #1 above will update the Test item Customer Name property with the associated id.
5. Once you have this working it may turn out that the NDA values on the Test form will automatically be updated, assuming that the NDA values are defined in the Test itemtype as Foreign with the Customer itemtype as the datasource. I have not tried this so I am not sure. If they are not automatically updated then you would have write some javascript to retrieve the NDA values from the Customer item and display them on the Test form.
AbhishekSrivastava - Wednesday, March 16, 2016 7:26 AM:
Tistickel,
ok , can you please share a sample method from one field like when i select customer then any one NDA value comes from Customer item type.
Thanks
Abhishek Srivastava
