Search Results for 'list form'

[Alexander Bautz]

Hi,
The calculated column is not available in EditForm, so you need to use a query to get the value.

This is the HTML from the “Heading or HTML field”:

<h2>Profile Name: <span class="fullusername" /></h2>

I include it here because the quotes in your example is the wrong type because it is not wrapped in <code> tags

Then add this to the Custom JS textarea in the “CSS and JS” tab:

var qRes = spjs.utility.getItemByID(
	{
		"listName":_spPageContextInfo.pageListId,
		"id":spjs.dffs.data.thisItemID,
		"viewFields":["YourCalculatedColumn"]
	}
);
$("span.fullusername").html(qRes["YourCalculatedColumn"].split(";#")[1]);

Change “YourCalculatedColumn” to the FieldInternalName of your calculated column.

Alexander

[Kobus Swart]

Hi Alex,

Does DFFS support SharePoint 2013 native star rating fields on DFFS forms?

I cannot see them in the list of fields when building a new form tab.

Ultimately I would like the Star Rating field to show up on the form so a user can rate the list item while editing the form. This works just fine on the list view.

K

[Alexander Bautz]

Hi,
Sorry for the delay. I tried to attach a script generated select to a list view, but it didn’t work as the page refreshed when I tried to filter the view – resulting in the select falling back to the default value returned from the query.

If you want to try it out yourself, here is the code I tried to use in the HTML form web part:

<select id="myCustomListFilterDropdown" name="T1"></select><input type="button" value="Go" onclick="javascript:_SFSUBMIT_"/>

<script type="text/javascript" src="/SPJS/DFFS/plugins/jquery.js"></script>
<script type="text/javascript" src="/SPJS/DFFS/plugins/SPJS-utility.js"></script>
<script type="text/javascript">

var oRes = spjs_QueryItems({"listName":"Dummy","listBaseUrl":"/DFFS","query":"<Where><IsNotNull><FieldRef Name='Title' /></IsNotNull></Where>","viewFields":["ID","Title"]});
if(oRes.count < 0){
	alert("Query failed, please check your parameters");
}else{
	var b = [];
	$.each(oRes.items,function(i,item){
		b.push("<option value='"+item.ID+"'>"+item.Title+"</option>");
	});
	$("#myCustomListFilterDropdown").append(b.join(""));
}
</script>

Alexander

[Yucel Cagri]

Hi Alexander,

I am using SPServices’ Add New function within a DFFS Edit Form, to call another DFFS new form. This normally works ok. However, if the first form already has a Source parameter on the URL, the second form that is opened by SPServices gets two Source parameters. This causes second DFFS window to stuck at overlay and end up with This took too long message.

I am trying to understand if this is SPServices building the URL wrong or a problem with DFFS parsing it. Below is how URL looks like, I appreciate if you can point me in the right direction.

Sample URL, which causes This took too long message:

https://somesite.sharepoint.com/site/Lists/Corporate%20Accounts/NewForm.aspx?Source=https://somesite.sharepoint.com/site/Lists/Table%20List/EditForm.aspx?ID=58%26Source=/crm/Lists/Event%20List/DispForm.aspx?ID=10%26sTab=2

(This happens when I go to a display form, edit an item from vLookup and click Add New link in the Edit Form)

Thanks,

Cagri

[Kristoffer Bertsch]

Hi, I have a few lists used for testing. We did some updating to our tests where we have now numbered each question. I would rather not update each column with a number in front of the question but instead have a number show on the form for each column/question. Is this possible?

I appreciate your help!
-Kris

[Yucel Cagri]

Couple of more observations on this issue:

1. As mentioned, it gets resolved when linktoItem is added to the list. I had a very similar issue with Asset Lists, where in Thumbnail view, display form comes with no Contenttypeid out of box. Similarly adding Name (linked to document with edit menu) to Thumbnail view solved the issue, without displaying additional information.

2. However, I am not sure if this is a SharePoint issue. When Display form opens with a blank Contenttypeid, Edit button on the ribbon is just works fine. It actually brings the Edit form with no Contenttypeid parameter on the URL at all. However, Edit button on the DFFS form calls edit URL with a blank Contenttypeid which is causing the problem.

Alexander, I wonder if there is an easy way to strip Contenttypeid parameter completely on Edit button, especially if Display form is called with blank Contenttypeid to match Sharepoint’s behaviour ?

Many thanks,

Cagri

[Alexander Bautz]

Hi,
If I understand your question correctly, this is not possible as these “extra” lookup column properties are only available in DispForm.

Have you looked at the vLookup plugin? – this might be able to solve your problem.

If not, you would need to write some custom code to get hold of the value from the “lookup list”.

Alexander

[Gerard Graham]

Hi there
I have a list with 15 vLookup relationships with various child lists. THe load time for the form is now noticeably slower than most users are prepared to accept. While I can marvel at the complexity and genius behind the form (thanks again Alexander!) I would like to reduce the load time if possible while retaining the relationships to the child records.

Firstly, can you confirm that it is the number of vLookups that will be causing the delay and if that is the case, is is possible to delay the loading of selected look ups and have them load when the current tab is fully loaded? (e.g. load the main tab with its vLookups and then load the others in the background?

The scenario is a Project management record with child lists for costing, outputs, risks, activities, impact, documents and more.

Thanks

Gerry

[Michal Riha]

Hi Alexander,
I have strange error HRESULT: 0x80131904 displayed at form – see attached document.
Everything works perfect if user is site collection admin. If not, this error appears.
User has Full controll to site, has FC to both lists (mother and child), has FC at document library with DFFS javascripts, has FC at DFFS and vLookup configuration lists.
🙁
Thanks for any idea.

Michal

Using DFFS Backend v4.260, [frontend] v4.272, CSS version: 4.02 / |spjs-utility version: 1.206, vLookup for SharePoint [backend] v2.117, frontend] v2.119

Attachments:

1. vLookup_HRESULT_0x80131904.docx

[Alexander Bautz]

Sorry for the delay – I didn’t get a notification form the forum.

You should find the ID column in your field list to include in the tabs, but only when configuring DispForm or EditForm.

Are you sure you don’t see it.

Alexander

[Carl Stewart]

We are using DFFS 4.102 and have a need to use a lookup list on a form which is a filtered set of data.

If my list is “Accounts” with this data:

Account ID = 112, Level = 2
Account ID = 543, Level = 2
Account ID = 123, Level = 1

Is there a DFFS tool that will allow us to use a lookup list that pre-filters the available choices to just “Level 2” items?

The idea is that each user will have different access rights and we want to control which items are available in the lookup list drop down.

We are using a custom user property to set their individual “level” access right.

[HTIC]

Hi Alex,

I’m hoping you can help. I have my charts set up in my CEWP (shown below) and I’m using the ‘spjs_getFilterValue’ function to return custom filter values which is shared between multiple charts using the filterAdditionalCharts’ option, and the ‘spjs_chartSelectionHandler’ function is used to select and return the data in a new window.

This works fine initially when I load the page and click on the chart data – the ‘spjs_chartSelectionHandler’ runs through and uses the URL to return the List data in a new window as expected. However, as soon as I select another value from the filter dropdown and repeat the same action (i.e. click on a chart item) the ‘spjs_chartSelectionHandler’ function seems to act like a loop which returns multiple instances of the same list data.

I’m not sure if it’s something to do with how I’ve written my code or the function itself but I would really appreciate your assistance?

<style type=”text/css”>
font-style:italic;
color:white;
border:1px silver solid;
background-color:#7DB0AF;
line-height:250px;
height:250px!important;
width:350px!important;
text-align:center;
margin:2px;
}
</style>

<div class=”spjs_chartPlaceholder_master”></div>
<script type=”text/javascript”>
// Set this to true to load the Google Visualization API release candidate
var loadRC = false;
// Set this to true to allow for the use of variables in the “Filter setup textarea”
var allowEval = true;
</script>
<script type=”text/javascript” src=”http://restricted.sharepoint/sites/SPJQ/jquery-1.11.3.min.js”></script&gt;
<script type=”text/javascript” src=”https://www.google.com/jsapi”></script&gt;
<script type=”text/javascript” src=”http://restricted.sharepoint/sites/SPJQ/spjs-charts-v4.14_min.js”></script&gt;

<script type=”text/javascript”>
function spjs_getFilterValue(list,field){
var q = “<Where><IsNotNull><FieldRef Name=’ID’ /></IsNotNull></Where><OrderBy><FieldRef Name='”+field+”‘ /></OrderBy>”;
var res = spjs.charts.qItems({“listName”:list,”query”:q,”viewFields”:[field]});
var b = [];
var fObj = {};
b.push({‘f’:’All’,’v’:’*’});
$.each(res.items,function(i,item){
if(fObj[item[field]] === undefined && fObj[item[field]] == null){
fObj[item[field]] = 1;
if(item[field] == “QF”){
b.push({“f”:”QF”,”v”:”QF”,”selected”: “true”});
} else {
b.push({“f”:””+item[field]+””,”v”:””+item[field]});
}
}
});
return b;
}
var myCustomFilterOptions = spjs_getFilterValue(“List_BF”,”DT”);
</script>

<script type=”text/javascript”>

function spjs_chartSelectionHandler(chartID, selection, data) {
var message, item, value, x, y, z, x1, x2;

if (selection.length > 0) {
item = selection[0];
message = “”;
value = “”;
switch (chartID) {
case ‘69743111-c1d0-4562-99e8-f72a85697457’:
if (item.row !== null) {
x = data.getFormattedValue(item.row, 0);
x = x.replace(” “, “%20”);
x = x.replace(“,”, “%2C”);
//console.log(x);
if (item.column !== null) {
z = data.getFormattedValue(item.row, item.column);
//console.log(z);
y = data.getColumnLabel(item.column);
//console.log(y);
}
}
if (x === undefined && y === undefined && z === undefined) {
return;
}
if (confirm(“Open filtered list?”)) {
window.open(‘http://restricted.sharepoint/***************************.aspx?&FilterField1=MOM&FilterValue1=&#8217; + x, ”, ‘width=1000’);
return;
}
break;

//case ‘b2bf592a-3c16-49dc-bae2-76d68b6e3d7a_0’:
case ‘69743111-c1d0-4562-99e8-f72a85697457_0’:
if (item.row !== null) {
x2 = data.getFormattedValue(item.row, 2);
x2 = x2.replace(” “, “%20”);
x2 = x2.replace(“,”, “%2C”);
//console.log(x2);

if (x2 === undefined) {
return;
}
}
if (confirm(“Open filtered list?”)) {
window.open(‘http://restricted.sharepoint/***************************.aspx?&FilterField1=Title&FilterValue1=&#8217; + x2, ”, ‘width=1000’);
return;
}
break;
default:
if (item.row !== null && item.column !== null) {
message = “{row:” + item.row + “,column:” + item.column + “,chart:” + chartID + “}”;
value = data.getValue(item.row, item.column);
if (message === “”) {
message = “nothing”;
}
alert(“You selected ” + message + “, the value is: ” + value);
}
//console.log(“Chart selection not configured.”);
break;
}
}
}
</script>

[avala]

Thanks, Alexander. We’re not using dialogs for our forms, but your suggestion pointed me to the following solution. Essentially, we’re providing a unique Delete button on the edit form only after it was initially submitted to provide the user with the ability to cancel out of the process without leaving “duplicate” items in the list.

Place this in the CSS and JS section of the Edit form:

function deleteMe(){
	var dRes = spjs.utility.deleteItem({
	"listName":_spPageContextInfo.pageListId,
	"id":GetUrlKeyValue("ID")
	});

	if(dRes.success){
		history.back(-4)
	}
}

Created a Header in the tab section with the following code:

<input onclick="deleteMe();return false;" type="button" value=" Delete Report"/>

Created two rules:
1. If the form is Saved, set Initially Submitted Field to Yes (Default No)
2. If Initially Submitted = Yes, Hide Header with Delete button.

• This reply was modified 9 years, 11 months ago by avala.

[AdamP]

Just a simple form to start things off. Apologies for the blurred data and the large image size – seemed best to show it all together rather than chopping it up into sections – zoom in to see the detail. I’ve annotated alongside the form to describe which elements of DFFS I’ve used.

I created this for capturing quarterly reports from about 30 separate contributors. Nothing very fancy here really, but I do have four separate child lists linked up to this parent one via the vLookup plugin. Two for display of read only data, and two where data is being submitted as part of the report – multiple rows as required.

The only other thing I think I’ve used is html formatting on a couple of fields.

Attachments:

1. 

   Reporting-Form.png
   

[Alexander Bautz]

Hi,
Sorry for the delay.

You enter the backend configuration from the link “Enhanced with DFFS” below the form (NewForm, DispForm and EditForm).

No need to add any code to the server side. All is stored in a list in the site you set up DFFS in (you can see this list in All site contents, but this is not to be hand edited).

Hope this helps,
Alexander