Paul Lynch

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 96 total)
  • Author
    Posts
  • in reply to: SP2010 ListView Link to Child Items? #33786
    Paul Lynch
    Participant

    “There is no built in method to link this to the child item.” Just seen this again, so I guess not.

    Perhaps I can do this with JQuery somehow

    in reply to: SP2010 ListView Link to Child Items? #33784
    Paul Lynch
    Participant

    Sorry one more thing, the vLookup does the query which retrieves the child item data. Is there something I can add in the vLookup to create a link to the child, in the child table?

    in reply to: SP2010 ListView Link to Child Items? #33782
    Paul Lynch
    Participant

    Sorry been a long day and totally got wrong url, thank you it works fine.

    Will buy you a beer and wish Finland well in Euros!

    in reply to: SP2010 ListView Link to Child Items? #33778
    Paul Lynch
    Participant

    Hi Alexander,

    I am trying to get this to work a few years later but guess things have changed.

    Instead of linking to “vLookup_ListView.html” in the SPJS/CEWP folder of DFFS, do I now add a CEWP to the form and point it to /SPJS/DFFS/CEWP/DFFS_frontend_CEWP.html?

    Having trouble showing the child items in the Parent List view.

    It is a classic list, I have added the vlookup column, and tabular view is checked.

    Basically just want a link to the child item from the parent item.

    in reply to: Changing SPFieldMultiChoice style on display form #33092
    Paul Lynch
    Participant

    Fantastic thank you worked like a charm

    in reply to: Changing SPFieldMultiChoice style on display form #33088
    Paul Lynch
    Participant

    Hi Alexander,

    This has been working great, but did cause an issues in another rule we did not immediately notice.

    The rule checks the multi-choice field (same internal field name used in the code above)
    IF XXX equals one of the values XXX, it hides/shows a tab.

    When I add this JavaScript, the rules stops working.
    If I remove it, the rule works again.

    I guess once the choices have a <br> inserted instead of ; it breaks the rule somehow.

    Any quick workarounds you could suggest?

    Kind Regards,
    Paul

    Paul Lynch
    Participant

    Thanks Alexander, this works fantastic for a single vLookup.

    My form opens using three URL Query strings (Rules)

    Each one has a different vLookup.
    – vLookup_NEW
    – vLookup_Change
    – vLookup_Remove

    I added this JS three times in sequence and changed to match each vlookup, but does not work (Cancel button does not work when clicked). Guess all three running at once is an issue.

    Sorry perhaps I need to structure it so that each separate function only runs when the rule runs but I am not sure how to code it. I know where I can call a JS function to run within the rule. Can you wrap your code within a function?

    Paul Lynch
    Participant

    Thanks for the swift reply. I didn’t use the ID in my table query, so I added it (see attachment for vlookup setup)

    Trying every combination here (with and without the changes in your last post) but does not seem have an effect. Not sure how best to troubleshoot.

    Attachments:
    Paul Lynch
    Participant

    Hi Alexander,

    Trying to follow this thread and implement, as this is exactly what I need.

    Did not have the same issues as Navya, nothing seems to happen.
    This is a Parent and Child list.
    I am adding this script to the Parent custom JS tab (Newform).
    Replaced the GUID of list (not sure if it should be in curly braces {} I did try both)
    Replaced the vLookupTasks with my internal field name “vLookup_NEW” for the vLookup field name.

    So on adding a new list item (Parent Newform) I open vlookup to add a child, submit this. Then when returning to parent form click cancel, the form closes, but the child item is not deleted in the child list.

    
    
    // Keep track of the item being saved or not
    var isSaved = false;
    window.onbeforeunload = function() {
        if(!isSaved){
            var items = [];
            $.each(spjs.vLookup.dataObj.vLookup_NEW[getFieldValue("_vLookupID")].items,function(id,item){
                if(item.hasOwnProperty("ID")){
                    items.push(id);
                }
            });
            if(items.length > 0){
                spjs.utility.deleteItem({"listName":"0D95398E-7811-4A22-89E0-32EAAF20C15D","id":items});
            }
        }
    };
    
    function dffs_PreSaveAction(){
        isSaved = true;
        return true;
    }

    I’m not sure if the rest of the thread talks about document libraries rather than lists, hence the permission issues. Should this just work (and I have the wrong Syntax) or do I need to add more code and follow the thread more closely?

    in reply to: Changing SPFieldMultiChoice style on display form #32093
    Paul Lynch
    Participant

    Awesome just what I wanted thanks

    • This reply was modified 10 months ago by Paul Lynch.
    in reply to: Sending email #32069
    Paul Lynch
    Participant

    In addition, I’ve never been able to get the “email active tab” to work.

    I get the pop up, but nothing seems to happen. Not sure the best way to test or check.

    Would this feature populate an email with the contents of the vlookup table?

    in reply to: Multiple filters from same datasource (CAML) #32020
    Paul Lynch
    Participant

    Thanks Alexander, will work through this and let you know the outcome

    in reply to: Multiple filters from same datasource (CAML) #31988
    Paul Lynch
    Participant

    Hi Alexander,

    I have figured out the CAML queries with help from an excellent and free client side CAML query builder/checker QuickCAML, which works with SharePoint Online (even with SPO multi factor activated which stops many local clients working).

    The only question I have now is that at present I am using different cascading drop down fields (in parent form) to collect/store choices for different tabs (as each cascading drop down has different filtered choices some REST some are now CAML) – these are shown via rules.

    Ideally I would store the data in the same fields for all tabs, but I am not sure how to differentiate between which cascades run and which do not.

    Do not think this is possible in the cascading drop down tab in the DFFS config (backend).

    Guess I would have to invoke the function manually, when a rule shows a tab, it runs a specific cascading drop down and filter for that field.

    I’ve been trying to get the datasource and invoke function to work,

    var res = spjs.utility.queryItems({"SCENARIOS":"CascInitialFilterSource", "query":"<Where> <Or><Contains><FieldRef Name="Column3" /><Value Type="Text">Option1</Value></Contains><Contains> <FieldRef Name="Column3" /><Value Type="Text">Option3</Value></Contains></Or></Where>"

    It is this line which I am confused about, as I am not sure which entries to change in second part of the datasource..

    viewFields":["Title", "FieldValue", "LookupValue"]});

    Here is an example of my working CAML query, with a simple OR filter on one column, the list is called SCENARIOS.. not sure if this helps

    
    
    <View>
        <Query>
            <Where>
                <Or>
                <Contains> 
                    <FieldRef Name="Column3" />
    <Value Type="Text">Option1</Value>
                </Contains>
                   <Contains> 
                    <FieldRef Name="Column3" />
    <Value Type="Text">Option3</Value>
                </Contains>
                </Or>
            </Where>
        </Query>
        <ViewFields>
            <FieldRef Name="Column3"/>
        </ViewFields>
    </View>
    • This reply was modified 10 months, 2 weeks ago by Paul Lynch.
    • This reply was modified 10 months, 2 weeks ago by Paul Lynch.
    Paul Lynch
    Participant

    We create child items in the parent form using a standard vlookup “add new item button”.
    The child form “pops up” in a window.
    The child “newforms” are pretty basic forms with 4-5 fields, including at least one hidden people picker field which needs to be pre-populated.
    The child forms have no custom javascript (but do have some custom css).
    The child forms have no “save and redirect” settings in the Misc tab set.
    The child forms have a handful of basic rules (which run but do not actually do anything or apply when the child form is initially created)

    I do wonder if something sometimes “times out” especially if when the issue occurs, the user has an older machine, where running the server side scripts on their browser take longer.

    It has happened to me on both forms, and during testing. (say 5-10% of the time) the fields or at least the people picker field, does not populate.

    Paul Lynch
    Participant

    This is from EditForm

    Here is an example of one attached

    Thanks
    Paul

    Attachments:
Viewing 15 posts - 1 through 15 (of 96 total)