Forum Replies Created
-
Posts
-
Hi,
I have made a test like this:Used a subsite under /DFFS/DFFSTemplate to store all script files in a library, and to hold the DFFS_backend web part page.
Then added a site to use as template here: /DFFS/DFFSTemplate/Template
This site is set up with DFFS, and it stores its configuration here “/DFFS/DFFSTemplate/Lists/SPJSDynamicFormsForSharePoint” using this variable in the “DFFS_backend_CEWP.html”:
var dffs_configListBaseUrl = "/DFFS/DFFSTemplate";
In the “DFFS_frontend_CEWP.html” I have these variables:
var dffs_configListBaseUrl = "/DFFS/DFFSTemplate"; var spjs_dffs_backend = "/DFFS/DFFSTemplate/SitePages/DFFSBackend.aspx";
This setup will store the configuration for both the “master” subsite, and the clones created by this template in the same configuration list, and uses this identifier (no subsite path):
/lists/MyList/newform.aspx
Can you verify that this is the same setup you have? – could it be that you have not “centralized” the DFFS_backend?
Hope this helps you sort it out.
Alexander
Hi,
Sorry for the late reply. From the error message it looks like the user does not have access to read the file “jquery-1.11.1.min.js”. You must ensure anonymous users have read access to the library or folder you have this file in.When it comes to enabling anonymous access in general I cannot offer any help, but I’m sure you find other resources.
Alexander
Sorry for the delay. I changed the quotes like this and it seems to be OK:
<a href=\"https://sharepoint/sites/site/Lists/List/View.aspx?View={9398E27A-31BE-4CFA-89B4-837F6F111E36}&FilterField1=Status&FilterValue1={0}\" target=\"_blank\">{0}</a>Alexander
You must give the anonymous users read access to the script location and the configuration list for DFFS.
Alexander
Hi,
This is currently not added to DFFS, but I have had other requests. This is a workaround you can use.Add a function like this to the “Custom JS”
function appendHistory(){ var history = $("#dffs_Textarea1").find("td.ms-formbody div.dffs_tdWrap div").has("a").html(); $("#dffs_Textarea1").find("td.dffs-readonly-inner div.dffs_tdWrap").append("<div style='margin:2px;padding:3px;border:2px silver dashed;background-color:#ffffff;'>"+history+"</div>"); }You must change “Textarea1” to your own FieldInternalName.
Then add a call to this function on the rule that sets the field read only (in the “Run these functions” field).
Let me know how this works out.
Alexander
Hi,
Sorry, but DFFS (and vLookup) cannot read from SQL. You should be able to use a BCS if you add a column “ID” (unique number) to the data source.There is no grid view to edit the vLookup data in, but this is only a view. Can you go to the list the data is pulled form and edit it in datasheet view there?
Alexander
Try
<a href='{0}'>{1}</a>Where column index 0 is the URL and index 1 is the text you want to show on the URL.
Alexander
Hi,
I can make a modification to vLookup to enable “sum” of number columns. I’ll look at it this weekend and see what I can come up with.Alexander
Hi,
I have updates the description for the “Initially hidden fields” in the Misc tab earlier today (v4.256) as I simply forgot to change the description when I changed the functionality in v4.200.If you look at the change log for v4.200 you see that this is effectively hiding the fields “permanently”, and to unhide it, you will have to use a custom function to remove the class “spjshidden”.
In most cases, you can change the trigger for example to [Applicable choice field] is NOT equal to [Applicable] > show the field. This will hide the field if you select “Applicable”.
Hope this helps,
AlexanderHi,
Hopefully, this code example will provide a working solution. Add the below code to the Custom JS, or the CEWP for the DFFS frontend.Please note that you must change the FieldInternalName the function is called with in the bottom line, and you must change the parameters in “spjs.lookup.init” in the “fill” function in the top.
Alexander
var spjs_lookup_ppTrigger = { "fill":function(fin){ var ppID = spjs_lookup_ppTrigger.getSelectedPeoplePickerID(fin); if(ppID !== false){ spjs.lookup.init({ "fieldToConvertToDropdown":["SPJSLookup1"], "optTextFieldInternalName":"Title", "listName":"Tasks", "listBaseUrl":"/DFFS", "sortFieldName":"Title", "filterObj":{ "on":true, "folder":"", "CAML":"<Where><And><IsNotNull><FieldRef Name='Title' /></IsNotNull><Eq><FieldRef Name='AssignedTo' LookupId='TRUE' /><Value Type='User'>"+ppID+"</Value></Eq></And></Where><OrderBy><FieldRef Name='Title' Ascending='TRUE'/></OrderBy>", // Full CAML query. If used, the rest of the filterObj settings are disregarded "fin":"", "isLookup":false, "operator":"Eq", "filterVal":"" }, "dropDownDefaultvalue":"...", "addYouOwnValue":{ "on":false, "linkText":"Write your own value" }, "addToExternalList":{ "on":true, "customFunction":null, "linkText":"Add new item", "saveNewItemText":"Save new item" }, "debug":false }); } }, "data":{ "pp":{} }, "init":function(fin){ setInterval(function(){ var a = spjs_lookup_ppTrigger.ppChanged(fin); if(a){ spjs_lookup_ppTrigger.fill(fin); } },2500); }, "ppChanged":function(fin){ var a = spjs.utility.getFieldValue({ "fin":fin, "key":"loginName" }), b = false; if(spjs_lookup_ppTrigger.data.pp[fin] !== String(a[0])){ spjs_lookup_ppTrigger.data.pp[fin] = String(a[0]); b = true; } return b; }, "getSelectedPeoplePickerID":function(fin){ var a, b, c = false; a = spjs.utility.getFieldValue({ "fin":fin, "key":"loginName" }); if(a.length > 0){ b = spjs.utility.userInfo(a[0]); c = b.ID; } return c; } }; spjs_lookup_ppTrigger.init("PeoplePicker2");Hi,
It seems I have mistakingly assumed that the people picker was filled when the form loaded, and not being set manually in the form.Can you confirm that the picker is set by the user?
If so, how do you plan to “fill” the dropdown? – by a button, or by “change” of the PP?
Alexander
Sorry for the delay – I have had quite a lot of backlog on emails. I have looked at your code snippet above, and it seems that you have not changed the fieldinternalname to match the one you use. In my example, I used “Requester”, but this must be changed to the actual field you want to pull the information from.
Alexander
