-
Thank you. Your post helped me. :)
-
Hilary - I'm so sorry I forgot to feed back - this worked a charm thank you so much :)
-
It won't let me attach or post a picture, it is 'exisiting filters:
network = Network and service = service
-
Hi I can't find an options tab on here or anywhere to upload a file. Can you see this screenshot? So sorry I am a newbie.
-
I am working with 2 views 1) search and update with Row ID column 2) Insert new record.
Submit option:Submit to Database using custom code and rules. (Primary Key: Row_Id , Identity column)
Submit button is updating previous search record instead of inserting new record into database when I search & do something in 1st view and navigate ...
-
Looks like you may also need to match on country, right? Because the payment terms seem to differ according to country and sales org. However, for matching on just sales org, your XPath looks right.... Are you always getting Net 30? Or whatever the first item in the list is?
-
You have been a great help, thank you so much. :)
I brought in the Default-Values SP list I created as a secondary connection, and am attempting to modify the Set Currency rule XPath you left as an example, but it is only bringing in the same value for Payment Terms (Payment1 in the form) for all Sales Orgs. Is it clear to you what I ...
-
Yup - as long as you have a way to relate the sales org. If your list stores the text value, you just have to have the additional filter to get that text from the secondary data source leveraging the ID that is currently stored in the main data source. The XPath looks hairy, but it is just matter of adding a filter and selecting the filter values ...
-
It works. :)
Well, for SalesOrg anyway. Again, there are no linear relationships in the CMD_Pulldown SP list. It is only a repository of columns and column values stored vertically (think Quick Edit for adding new values to a column). No list items here make any sense.
That being said, I kind of understand the XPath ...
-
I was just wondering if there were values in there that correspond to the fields you want to set. I've taken some guesses. Here's a copy of your form, save it locally, right click and preview and we'll see if I've made any correct guesses. I can't test my changes in preview because I don't have access to your site, of ...