[Paul Lynch]

Been looking at options and wondering if “special configuration” option in the vlookup table could call the function to perform this..

{"function":"functionName"}

So if I take my current item (status) field in vlookup, set the special configuration to be:

{"function":"updatestatusfunction"}

Then the in my parent custom JS area I use

function updatestatusfunction() {
    setFieldValue("STATUS","xxxxstatusfromvlookupxxxxxx");
}

How can I populate (SP.listItem will be passed as an argument to the function) xxxxstatusfromvlookupxxxxxx by passing current field value (vlookup child)?

STATUS is the internal field name of both parent and child (with identical values in a single choice column)

• This reply was modified 4 years, 5 months ago by Paul Lynch.
• This reply was modified 4 years, 5 months ago by Paul Lynch.

[Paul Lynch]

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

[Paul Lynch]

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

[Paul Lynch]

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)

[Paul Lynch]

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:

1. 

   error-1.png
   

[Paul Lynch]

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.

[Paul Lynch]

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 4 years, 6 months ago by Paul Lynch.

Attachments:

1. 

   parentchildupdate.png
   

[Paul Lynch]

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?

[Paul Lynch]

Works perfectly thanks Alexander will send some beers your way!

[Paul Lynch]

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.

[Paul Lynch]

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]}]);

[Paul Lynch]

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 4 years, 6 months ago by Paul Lynch.

[Paul Lynch]

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!

[Paul Lynch]

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

[Paul Lynch]

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]}

[Author]

Posts