Paul Lynch

Forum Replies Created

Viewing 15 posts - 31 through 45 (of 100 total)
  • Author
    Posts
  • in reply to: vLookup – Update Child when Parent is Updated #30823
    Paul Lynch
    Participant

    Thanks this all works brilliantly.

    Just one more question!

    Is it possible to have this work in reverse?

    So updating status in a vlookup child item, will update the vlookup parent item?

    Trying to maintain an identical status same in both child/parent

    in reply to: {timestamp} not working in IE #30819
    Paul Lynch
    Participant

    Sorry did not read the previous answer properly, no worries thanks for checking!

    in reply to: {timestamp} not working in IE #30809
    Paul Lynch
    Participant

    Thanks Alexander,

    only just had time to try this out but I get “undefined” which replaces the date field of DFFS form.

    Sorry I just wanted to clarify I it is not a text string I am converting it is date field. I want to show 20 June 2020, instead of 20/06/2020

    Fieldname – DateColumn1 (Internal fieldname – DateColumn1)
    Column type – Date/Time field

    Tried it on a couple of dates using internal field names of two dates on my form.

    I’m no programmer but in first line of the js create and set a variable dispFormDate as the value from the date field from DateColumn1 (DateColumn1 is the existing date field, not a text string created by a timedate stamp)

    in reply to: vLookup – Update Child when Parent is Updated #30767
    Paul Lynch
    Participant

    NewForm

    Second tab has the vlookup. The person clicks uploads a record to child library, fills in metadata and then the vlookup table renders. That’s all good.

    They then click third tab, which has a Js button, which should submit form and run the function but nothing happens (hence I checked console).

    Actually want to run two functions, send an email AND update the status of the child form, but left out email function until I get this to work.

    Attachments:
    in reply to: {timestamp} not working in IE #30765
    Paul Lynch
    Participant

    Sorry might have confused things with the script and I also left out some code.

    Just a standard date/time field in SP – which I would like to show in a “friendly” way.. e.g.15 June 2020 rather than 15/06/20 which is how it shows in the SP form by default.

    in reply to: vLookup – Update Child when Parent is Updated #30749
    Paul Lynch
    Participant

    Trying to implement this fix and struggling.

    Parent List
    Parent List Name (List) – TRLRPTS
    vLookup fieldname – vLookup_Children
    Internal fieldname – Status

    Child List
    Child List Name (Document Library) – TrialReports
    Child list GUID – {ADA5EC4A-7D6D-4AFC-9AFA-21F47C2E1480}
    Internal fieldname – status

    Both above fields are single choice columns..

    Here is my code:

    
    
    function callMeFromChangeRule(){
        var arrOfIDs = [];
        jQuery.each(spjs.vLookup.dataObj.vLookup_Children[spjs.dffs.data.thisItemID].items,function(id,vLookupListItem){
        	arrOfIDs.push(id);
        });
        spjs.utility.updateItem({
            "listName":"{ADA5EC4A-7D6D-4AFC-9AFA-21F47C2E1480}",
            "id":arrOfIDs,
            "data":{
                "status":getFieldValue("Status"),
            }
        });
    }

    I’ve attached the console error..

    • This reply was modified 2 years, 7 months ago by Paul Lynch.
    in reply to: {timestamp} not working in IE #30747
    Paul Lynch
    Participant

    Thanks this worked great and Js can populate the time/date stamps on event.

    Final question on time and date formatting!

    What is the best way to show a “friendly” time/date format in the form? I have the date/column fields set to “friendly” but I think that only shows this in the list itself.

    At moment I am using this script;

    $("span.NAMEOFSPAN").html(qRes["SP_DATE_COLUMN_IN_LIST"].split(";#")[1]);

    Then showing it in HTML field

    <h4><strong>Date Issue Occurred:  </strong><span class="NAMEOFSPAN" /></h4>

    I then have to use rules to hide the SP_DATE_COLUMN_IN_LIST in the form, and replace with the HTML date field.

    Wondering if there is a more efficient way?

    in reply to: Enhanced Rich Text, or Rich text fields #30736
    Paul Lynch
    Participant

    Works perfectly thanks Alexander will send some beers your way!

    in reply to: Enhanced Rich Text, or Rich text fields #30733
    Paul Lynch
    Participant

    Sorry for some reason I forgot the ribbon is at the top of the page! But a scroll bar would be nice, if we could fix the size of the box, as there might be fields under neath the multi line text field.

    in reply to: {timestamp} not working in IE #30564
    Paul Lynch
    Participant

    Sorry one more question on this.

    The first two options seem to be setting a fixed time/date

    Is it possible to use the {timestamp} keyword in the custom js like this?

    setFieldValue("DateColumn1", [{timestamp[MM/dd/yyyy]},{timestamp[HH]},{timestamp[mm]}]);
    in reply to: People Picker Issue newest version #30558
    Paul Lynch
    Participant

    Version information
    DFFS Loader: v2
    DFFS frontend: 4.4.5.0 – June 1, 2020
    DFFS frontend CSS: 4.60 /
    Autocomplete: 1.6.48 – May 10, 2020
    Cascading dropdowns: 3.7.40 – June 1, 2020
    jQuery: 1.12.4
    Lookup: 1.1.20 – March 10, 2020
    Resource management: 2.4.5 – August 29, 2019
    SPJS-Utility: 1.347 – June 1, 2020
    vLookup: 2.2.155 – June 1, 2020

    although I think I did replace this file SPJS-utility_v1.348.zip from a recommendation in another post about rules

    • This reply was modified 2 years, 7 months ago by Paul Lynch.
    in reply to: People Picker Issue newest version #30551
    Paul Lynch
    Participant

    I’m on the latest production version

    But I still cannot see people picker and also multi-choice fields when I set them to read only in Chrome and IE, but it is working in Firefox!

    in reply to: {timestamp} not working in IE #30549
    Paul Lynch
    Participant

    Thanks Alexander, this works great and populates the SP date and time field.

    in reply to: {timestamp} not working in IE #30538
    Paul Lynch
    Participant

    I’ve tried so many but given up, left it on this one for now which populates the correct date (no idea which timezone) but puts time as midnight 00:00

    {timestamp[MM/dd/yyyy HH:mm:ss]}
    in reply to: {timestamp} not working in IE #30533
    Paul Lynch
    Participant

    Just to let you know that this is now populating the date, just not the time!

    {timestamp[MM/dd/yyyy HH:mm]}

    will keep trying different time permutations!

Viewing 15 posts - 31 through 45 (of 100 total)