Search Results for 'list form'

[Alexander Bautz]

If you have a FLOW that changes the item after a user has opened editform and before he saves the item he will get a save conflict.

To avoid this you can add a field to your list – for example a boolean field named FLOW_DONE – that you set to true when the FLOW has finished.

Now you can set up a rule in your EditForm that checks this field – and if it is not true, give an alert and tells the user that the item is not yet ready for edit.

Alexander

[Jonathan Stamper]

I have a vLookup that populates a specific field on the child list. The child list form would then use that field value as a filter for an autocomplete field in the child form.

The issue I’m running into is the autocomplete occurs before the vLookup field is populated (even when I set the ac in a document ready state with jQuery). My custom js sits in an external js file and was curious about if it’s an issue with precedence (custom js vs external) and how I get the vLookup to populate the field first so I then do the ac?

[Amal Vellappillil]

Hi Alex,

Wondering if its possible to have autocomplete values linked to its display form or a modal window? I am trying to see if I can mimic the out of the box lookup field type functionality. I cant use that field type because the source list exists in a different subsite.

Any help would be appreciated.

Thank you,
Amal Vellappillil

[Jonathan Stamper]

That is perfect and it works! I was about to have to recreate my own upload page which I didn’t want to do so many many thanks!

2 more questions:

1. Does spjs.dffs.updateListItem have a renaming conventions for folders?
2. I realized that creating a folder on new item will also continue creating folders when pressing refresh or F5 on the new item form. Aside from creating an event listener on the F5 keyboard press, is there one that exists for pressing the refresh button on a browser?

Again thank you so much for all the help!!

• This reply was modified 3 years, 10 months ago by Jonathan Stamper.

[Alexander Bautz]

You can add a button on DispForm with code like this to redirect to EditForm. Add this in a HTML section:

<input type="button" value="Open EditForm" onclick="goToEditForm();return false;">

Now put this in your Custom JS:

function goToEditForm(){
    location.href = "/Sites/YourSite/Lists/YourList/EditForm.aspx?ID=" + spjs.dffs.data.thisItemID + "&sTab=5";
}

Change 5 to whatever index your tab has in EditForm.

Alexander

[Jonathan Stamper]

I have a vLookup table of Observations and within each observation is an inline button called “Send Email.” Clicking that button opens the custom alert with a div ID of “userEmails” inside “msg.”

What I’m trying to do with the DIV is create a custom People Picker field that auto populates from 2 other people picker fields on the main form and also allows the user to add more users to send the email to. When they select send email it will take that list of people send them an email, set a child email flag to yes, and refresh the vLookup table so as to hide the send email button on the table.

Is something like this possible to do or am I way over my head? I have logic to create a custom people picker but not sure how/if you can execute within the html of the custom alert.

[Filipe Ribeiro]

Hi,

I’m using an Entity identifier (NIF) to search for Entities in external list that have the correspondent value typed by the user in a text field, if it finds a match, get the value “Name” of that Entity into a text field on the form

[Alexander Bautz]

There is unfortunately no such settings. The only approach I can think of is to add two vLookup fields in the list – one for use in the form and one for use in the list view.

Use the exact same config, but different viewfields.

Alexander

[MikeS]

Alexander,

I have a request to display differing Child fields in the Form vs the List. Child fields A, B, C and D in the Form while Child fields E and F in the List view. How could I go about that?

Thanks,
MikeS

[MikeS]

This works great in the forms. Thanks.
However, the List view still shows the time stamp (00:00:00).

MikeS

[MikeS]

Alexander,

I am unable to eliminate the time stamp (00:00:00) on an OOTB associated field that is two removed from the Parent list. The vLookup to the Child pulls in a Child record that has an associated date field from a Child lookup to a third list (via OOTB SharePoint lookup). It is this date field that will not format properly in the parent (i.e., date only) with {dateFormat”:MM/dd/yyyy”} in the vLookup ViewFields Special Configuration entry.

Thanks for your help,
MikeS

• This topic was modified 3 years, 10 months ago by MikeS.

[Alexander Bautz]

Add this code to your Custom JS:

var textTemplateDataObj = {};
var templateTextTargetField = "Needs";
(function(){
    var res = spjs.utility.queryItems({
        "listName": "TextTemplates",
        "query": "<Where><IsNotNull><FieldRef Name='Text' /></IsNotNull></Where>",
        "viewFields": ["ID","Title", "Customer_Needs"]
    });
    var b = [];
    b.push("<div style='margin-bottom:10px;'>Select template: ");
    b.push("<select onchange='appendTemplateText(this)'>");
    b.push("<option value=''>...</option>");
    jQuery.each(res.items, function(i, item){
        b.push("<option value='"+item.ID+"'>"+item.Title+"</option>");
        textTemplateDataObj[item.ID] = item.Customer_Needs;
    });
    b.push("</select>");
    b.push("</div>");
    jQuery("#dffs_" + templateTextTargetField).find(".ms-formbody").prepend(b.join(""));
})();

function appendTemplateText(s){
    var tId = jQuery(s).val();
    if(tId !== ""){
        console.log(tId);
        var currText = getFieldValue(templateTextTargetField);
        var newText = textTemplateDataObj[tId];
        var padding = currText !== "" ? "\n\n": "";
        setFieldValue(templateTextTargetField, currText + padding + newText);
        jQuery(s).val("");
    }
}

You must edit the code and change “TextTemplates” to the name of your template list, “Needs” to match the internal name of your multiline textfield in the current form and “Customer_Needs” to match the multiline text field in the templates list.

Let me know how this works out.

Alexander

[Alexander Bautz]

Hi,
You can link to a specific tab by adding the sTab query string parameter to the URL like this:

/Lists/DFFS_TestList/EditForm.aspx?ID=52&sTab=5

If you want to show a specific tab when entering EditForm from this link you can add another query string parameter like this:

/Lists/DFFS_TestList/EditForm.aspx?ID=52&sTab=5&ShowChangeDatetab=1

Now create a rule in your EditForm that triggers on “Selected tab index / Tab unique ID” = “ShowChangeDatetab=1” and show / hide your selected tabs.

Alexander

[Jonathan Stamper]

Yes!!! Debugging made me realize how that function works so I’m using “parentListGuid” for the New Form check and vLookup. I just need to rework my conditionals to fix it.

Thank you for all the help! I really appreciate it.

• This reply was modified 3 years, 10 months ago by Jonathan Stamper.

[Alexander Bautz]

I don’t have an attribute like vLookupEdit and vLookupView for NewForm, but you can use one of other vLookup parameters like “parentListGuid” or “parentForm”.

Just a tip: if you open the form in a dialog you can right click and select “View frame source” (in Chrome) to open a new tab where you can see the URL of the dialog and identify all parameters.

Alexander