Search Results for 'list form'

[Amal Vellappillil]

Hi Alex,

I am running into a problem of stopPendingEmails function is not erroring when called from a list in site collection root. This doesnt seem to be happening with subsites.

Here is the Error:
POST https://_vti_bin/lists.asmx net::ERR_NAME_NOT_RESOLVED

Here is the request details that is being sent when calling stopPendingEmails function:

fetch("https://_vti_bin/lists.asmx", {
  "headers": {
    "accept": "application/xml, text/xml, */*; q=0.01",
    "content-type": "text/xml; charset=UTF-8",
    "sec-ch-ua": "\" Not A;Brand\";v=\"99\", \"Chromium\";v=\"99\", \"Microsoft Edge\";v=\"99\"",
    "sec-ch-ua-mobile": "?0",
    "sec-ch-ua-platform": "\"Windows\"",
    "soapaction": "http://schemas.microsoft.com/sharepoint/soap/GetListItems"
  },
  "referrer": "https://intranet.ltp.org/",
  "referrerPolicy": "strict-origin-when-cross-origin",
  "body": "<?xml version='1.0' encoding='utf-8'?><soap:Envelope xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'><soap:Body><GetListItems xmlns=\"http://schemas.microsoft.com/sharepoint/soap/\"><listName>DFFS_EMail</listName><query><Query xmlns=\"\"><Where><And><Or><BeginsWith><FieldRef Name='Title' /><Value Type='Text'>/lists/all staff meetings:1629824017430|</Value></BeginsWith><BeginsWith><FieldRef Name='Title' /><Value Type='Text'>/lists/all staff meetings:4|</Value></BeginsWith></Or><Neq><FieldRef Name='Done' /><Value Type='Boolean'>1</Value></Neq></And></Where></Query></query><viewFields><ViewFields xmlns=\"\"><FieldRef Name=\"ID\"/><FieldRef Name=\"Title\"/><FieldRef Name=\"Stop\"/></ViewFields></viewFields><rowLimit>100000</rowLimit><queryOptions><QueryOptions xmlns=\"\"><IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns></QueryOptions></queryOptions></GetListItems></soap:Body></soap:Envelope>",
  "method": "POST",
  "mode": "cors",
  "credentials": "omit"
});

I did try the request manually (took the code inside stopPendingEmails function and added the webAbsoluteUrl from _spPageContextInfo and passed it along as listBaseUrl property. Code:

spjs.utility.updateItem({
                    "listName": "DFFS_EMail", "listBaseUrl": _spPageContextInfo.webAbsoluteUrl, 
                    "id": 524,
                    "data": {
                        "Stop": "1"
                    }
                })

This request worked and did update the list item (pending email record).

Can you please take a look and advise?

Thank you,
Amal Vellappillil

[Alexander Bautz]

The Uncaught typeError: jQuery is not a function is most likely related to another third party solution loading jQuery after DFFS has loaded.

To fix it you should update your DFFS installer / loader from v1 to v2. Follow the instructions in the user manual to change it.

See instructions in the installation manual: https://spjsblog.com/dffs/dffs-installation-manual/#InstallDFFS

When you change the DFFS installer to v2 you must uninstall and reinstall DFFS in the form you have trouble with.

PS: You don’t need to back up the config when changing the installer because it is stored in a separate list and is not related to the installer.

Alexander

[Alexander Bautz]

I’m not sure how Phil fixed it, but if you are using the DFFS installer / loader version 1 you most likely have better results if you change to use version 2.

See instructions in the installation manual: https://spjsblog.com/dffs/dffs-installation-manual/#InstallDFFS

When you change the DFFS installer to v2 you must uninstall and reinstall DFFS in the form you have trouble with.

PS: You don’t need to back up the config when changing the installer because it is stored in a separate list and is not related to the installer.

Alexander

[Alexander Bautz]

Add this to your child NewForm Custom JS to set an onChange function on the lookup field that gets the value from the parent list and writes it to the child list.

jQuery("#dffs_YOUR_LOOKUP_FIELD_NAME select").on("change", function(){
    var id = jQuery(this).val();
    var item = spjs.utility.getItemByID({
        "listName": "YOUR_PARENT_LIST_TITLE",
        "id": id,
        "viewFields":["ID", "PARENT_LIST_FIELD"]
    });
    if(item !== null){
        setFieldValue("CHILD_LIST_FIELD", item.PARENT_LIST_FIELD);
    }
});

Change uppercases names to match your setup.

Alexander

[Jeff Lynch]

Let me see if I can clarify, everything seems close but we have some complications.

Parent List – we are using FullName as the Lookup in the child list – a simple SP Lookup field. In the parent list we also have Salary vs Hourly field – choice field with Hourly and Salary as the choices.

In the child list they first select the employee from the lookup, then what I want is to auto populate a field in the child form for salary/hourly with the value.

My first attempt was a cascading lookup on the child salary/hourly field based on the parent, but then when I try and use that value with a rule it doesn’t work because when you debug it is actually returning the ID of the parent item, not the value of salary or hourly.

so if I can have a value that is set when you select an employee in the child list that I can use for rules to display hide various fields thats what I need. make sense?

[Alexander Bautz]

Sorry for the late reply – I had an error in the email plugin in my site and didn’t receive notifications.

Yes, setting a lookup value is different – you must use the ID and not the title. If you change the code like this (assuming the lookup column should target the currently edited item):

var ok = spjs.dffs.check_Mandatory(["Title"]), data = {}, newItem;
if (ok) {
    data.Title = getFieldValue("Title");
    data.LookupColumn = getFieldValue("ID");
    newItem = spjs.utility.addItem({ "listName": "MyGUID", "data": data });
    if (newItem.success) {
        // Item added
    } else {
        alert(newItem.errorText);
    }
}

Please note that this won’t work if you are triggering this code in NewForm as you don’t yet have the ID.

Alexander

[Jeff Lynch]

I have a change request form, when the manager selects the staff member we want to know if they are hourly or salary, which is a choice field in the parent list. How can I automatically populate a choice field in the request list with the value from the choice field in the parent list when a staff member is selected?

I think a cascading lookup would work but it requires an extra selection on the choice field in the request list which would be nice if that was auto populated, then I could do what I need, is there a way to do that?

[SteveE]

Hey TJ,

First make sure you follow the full installation manual: https://spjsblog.com/dffs/dffs-installation-manual/. This includes the installer page.

Once that is done, yes, you create a custom list. Create the columns you want in that list. Then you go to that installer page and find the list and install dffs on the list.

Then you access the configuration by clicking the link at the bottom of the form. Usually you start with NewForm (clicking the New button) and start configuring that.

There’s a ton of options and they are explained in the user manual. https://spjsblog.com/dffs/dffs-user-manual/ It can be as simple or complex as you need. Have fun!

[Tj]

Hey Alexander & Community,

I’m new here. I have DFFS site collection installed on my site.
I’m looking to create a similar forms to these:
1. https://uigarage.net/1form-user-sign-up-form-web-forms-ui-design/
2. https://dribbble.com/shots/6660668-Form-UI-Design

The ask is that I make the forms as templates so the info can be retrieved in SharePoint and people can start/stop/return to their work.
Do I start with a SharePoint Custom List or another app?
I’m on SharePoint Server 2016.

Thanks.

[SteveE]

The spell check that comes with SharePoint isn’t ideal. Why not just use the one that is in the browser? Well it doesn’t read the input fields in SharePoint.

There’s a simple script you can add to custom JS that will enable the browser spell check in the input fields. It will underline the misspelled word and give you options if you right click, just like it’s supposed to.

Here’s the simple script:

function dffs_ready(){
jQuery(document.getElementById(‘onetIDListForm’).setAttribute(“spellcheck”,”true”));
}

I wrapped it in dffs_ready because it doesn’t always load in time otherwise. Enjoy!

[SteveE]

Hey Rick – there isn’t a guide, but I’ve successfully used dffs on SharePoint Online for the past year and half. Start with installing the Modern CEWP in the top links. You may have to enable custom scripting in the admin center. I think he has that information on here also, but if you search online you’ll find it (I didn’t use powershell). Then I just set up the installer like you normally do. You may have to turn on web part pages in settings if you don’t see it. You can use the modern experience on the lists if you want, but most of the time I use classic so I can customize the view to my liking.

I know Alexander is working on something more specific for modern SharePoint, but I’ve been able to use it mostly as it worked before.

[Alexander Bautz]

I’m sorry, but I don’t think this is something I can help you with. It is possible to do using code, but would take many hours to create. Also, the auto-submits after 30 minutes could be a problem if there are validation errors in the input.

I suggest you look into creating a custom form in a web part page using HTML / JavaScript and posting it using REST instead of using a survey.

If you do a Google search like this you might find some resources.

Alexander

[Alexander Bautz]

Hi,
Does this happen for all users?

It might be an issue with uses with similar name (same first or last name), or a problem with same users is multiple domains in your AD.

Look at the user information list in your site collection by browsing here and see if your have multiple entries for this user:
https://your_site_collection.domain.com/_catalogs/users/simple.aspx

Alexander

[Jeverly]

Hello,

I currently have 2 lists both with DFFS installed. I have several fields on the parent list setup to autofill fields (of the same names) on the child list. All fields but one autofill on the child list without issue. The only field that throws an error is a people Picker field. The user enters a name in the people picker field on the parent list (Parent field name: Assignee) and clicks on the Add Tasks button which opens the new form in the child list. The child list new form opens and the people picker field (Assignee) in the child list populates with the value listed in the parent form but it is accompanied with the error “Multiple entries matched, please click to resolve.” The user has to clear the field and re-enter the name in order to successfully submit the form. I have attached screen shots of both the parent list field & the child form. I have also attached a screen shot of the vlookup settings. Both Assignee fields are People Picker fields. Any help with this error is greatly appreciated :).

Attachments:

1. 

   Parent-List-Form.png
   

2. 

   Child-List-Form.png
   

3. 

   VLookup.png
   

[Alexander Bautz]

Loading large forms with many fields will be slow – especially when using many vLookups and cascading dropdowns / autocompletes or other custom js that runs additional queries.

You can speed up the loading by splitting the form into tabs and having some vLookups in separate tabs – the vLookups are lazy-loaded they will not render until they are visible.

The beforeproperties object is used in different internal functions in DFFS, but is not used when saving the item – this is entirely done with the standard SharePoint save functionality.

The fact that the beforeproperties object is missing some values is most likely due to the number of fields in the list and built in restrictions in how many fields of type lookup (lookup, people picker and managed metadata) a single query can retrieve. If you type in this in the console:

spjs.dffs.beforeProperties

and do a quick scan of the fields and values – what fields or values are you missing? – are the fields missing values of the lookup type?

Also open the developer tools and have a look at the console when loading the form – any error messages?

Alexander