Search Results for 'list form'

[Adamya Kant]

I need to remove tabs in NewForm of the list but want to retain it in EditForm and DispForm

Can you please help me how to do this?

[Gerard Graham]

Hi there

My Projects list is not longer displaying the DFFS enhanced Edit form for people who do not have Full Control rights on the list. I looked at the console and there is an error in the script. I’ve attached a screenshot of the message and the dump of the script. The error does not occur on any other list so all the Edit Forms work as expected. Permissions are consistent across the collection, nothing special or particular about this one. Any clues?

• This topic was modified 9 years ago by Alexander Bautz. Reason: Moved to DFFS

Attachments:

1. 

   ConsoleError.png
   

1. DFFS-Console-dump.txt

[Alexander Bautz]

Hi,
Yes this is the reason. When using [currentItem:NameOfField] I pull the value from the field in the form when in EditForm – and a calculated column is not present in EditForm.

In DispForm I use a query to find all the values, and I’m not sure doing this differently in EditForm makes any sense (you have one more query to perform, but this does not take many milliseconds to complete).

Try putting the code snippet below in the Custom JS in DFFS of your EditForm to see if it makes any difference. Let me know how it works out so I can update the vLookup script if it performs as expected.

Alexander

spjs.vLookup.fillInVariables = function(str,id,listGuid){
	var split, finID, fin, viewFields, item, val, vArr, q;
	finID = {};
	viewFields = [];
	vArr = str.match(/\[currentItem:[^\]]*\]/gi);
	if(vArr!==null){
		spjs.$.each(vArr,function(i,v){
			split = v.replace(/\[|\]/g,'').split(':');
			fin = split[1];
			if(fin!==null){
				if(fin==='ID'){
					str = str.split(v).join(id);
				}else{
					if(split.length===3){
						finID[fin]=split[2];
					}
					viewFields.push(fin);
					str = str.split(v).join("~"+fin+"~");
				}
			}
		});
		if(viewFields.length>0){
			item = spjs_getItemByID({"listName":listGuid,"id":id,"viewFields":viewFields,"scope":"RecursiveAll"});
			if(item!==null ){
				spjs.$.each(viewFields,function(i,fin){
					val = (item[fin]!==null)?item[fin]:'';
					vArr = val.split(';#');
					switch(finID[fin]){
						case 'id':
							val = vArr[0];
						break;
						default:
							if(vArr.length>1){
								val = vArr[1];
							}else{
								val = vArr[0];
							}
					}
					str = str.split("~"+fin+"~").join(val);
				});
			}
		}
	}
	// URL
	vArr = str.match(/\[URL:[^\]]*\]/g);
	if(vArr!==null){
		spjs.$.each(vArr,function(i,v){
			split = v.replace(/\[|\]/g,'').split(':');
			q = split[1];
			if(q!==null){
				if(GetUrlKeyValue(q) !== ""){
					str = str.split(v).join(GetUrlKeyValue(q));
				}
			}
		});
	}
	// Variables
	vArr = str.match(/\{var:[^\}]*\}/g);
	if(vArr !== null){
		$.each(vArr,function(i,v){
			try{
				val = eval(v.split(":")[1].replace(/\}|\\/g,""));
				if(val === undefined){
					alert("[vLookup - undefined variable]\n\n"+v.split(":")[1].replace(/\}|\\/g,""));
				}else{
					str = str.split(v).join(val);
				}
			}catch(err){
				alert(err);
			}
		});		
	}
	return str;
};

[Gerard Graham]

Hi Alexander

First is the output from the Edit form followed by the output from the Display form for the same item.

Thanks

Gerry

Edit
Field: vLookupDivisions

blob:
{“noteToSelf”:””,”listName”:”ContDB-Divisions”,”listBaseUrl”:”/celcis”,”query”:{“fin1″:”Org”,”type1″:”Text”,”value1″:”,”,”fin2″:””,”type2″:”Text”,”value2″:””,”fullCAML”:””,”AndOr”:””,”operator1″:”Eq”,”operator2″:”Eq”,”orderBy”:”ID”,”rowLimit”:””},”childTableHeight”:””,”viewFields”:[{“fin”:”Title”,”settings”:””,”disp”:{“default”:””},”colWidth”:””,”colWidthOperator”:”px”},{“fin”:”City”,”settings”:””,”disp”:{“default”:”City”},”colWidth”:””,”colWidthOperator”:”px”},{“fin”:”Contacts”,”settings”:””,”disp”:{“default”:”Contacts”},”colWidth”:””,”colWidthOperator”:”px”}],”action”:”concat”,”action_groupBy”:””,”action_groupByHeaderStyle”:””,”action_groupByExpanded”:false,”action_groupByPrefix”:{“default”:””},”showTotals”:false,”openInDlg”:true,”disable”:false,”refreshAllOnCallback”:false,”viewItemLinkIn”:{“disp”:true,”edit”:true,”view”:true},”editItemLinkIn”:{“disp”:true,”edit”:true,”view”:true},”hideLabelInForm”:true,”label”:{},”moreItemsLabel”:{“default”:””},”noItemsLabel”:{“default”:””},”addNew”:true,”newItemInDlg”:true,”addNewDlgOpt”:{“width”:””,”height”:””,”x”:””,”y”:””,”allowMaximize”:false,”showMaximized”:false,”showClose”:false,”autoSize”:false},”addNewLabel”:{“default”:”New Division”},”addNewIn”:{“disp”:true,”edit”:true,”view”:true},”addNewFolder”:false,”addNewFolderLabel”:{“default”:””},”addNewFolderIn”:{“disp”:false,”edit”:false},”addNewDocLabel”:{},”inUrl”:[{“from”:”Title”,”to”:”Org”,”hide”:false}],”folderMetadata”:[],”uploadToFolder”:true,”uploadToFolderLabel”:””,”openFolder”:true,”openFolderLabel”:””}
Field: vLookupDivisions

query:
<View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Org’ /><Value Type=’Text’>,</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ /></OrderBy></Query></View>
Field: vLookupDivisions

Number of items matching the query: 0

Display
Field: vLookupDivisions

blob:
{“noteToSelf”:””,”listName”:”ContDB-Divisions”,”listBaseUrl”:”/celcis”,”query”:{“fin1″:”Org”,”type1″:”Text”,”value1″:”A Life Explored”,”fin2″:””,”type2″:”Text”,”value2″:””,”fullCAML”:””,”AndOr”:””,”operator1″:”Eq”,”operator2″:”Eq”,”orderBy”:”ID”,”rowLimit”:””},”childTableHeight”:””,”viewFields”:[{“fin”:”Title”,”settings”:””,”disp”:{“default”:””},”colWidth”:””,”colWidthOperator”:”px”},{“fin”:”City”,”settings”:””,”disp”:{“default”:”City”},”colWidth”:””,”colWidthOperator”:”px”},{“fin”:”Contacts”,”settings”:””,”disp”:{“default”:”Contacts”},”colWidth”:””,”colWidthOperator”:”px”}],”action”:”concat”,”action_groupBy”:””,”action_groupByHeaderStyle”:””,”action_groupByExpanded”:false,”action_groupByPrefix”:{“default”:””},”showTotals”:false,”openInDlg”:true,”disable”:false,”refreshAllOnCallback”:false,”viewItemLinkIn”:{“disp”:true,”edit”:true,”view”:true},”editItemLinkIn”:{“disp”:true,”edit”:true,”view”:true},”hideLabelInForm”:true,”label”:{},”moreItemsLabel”:{“default”:””},”noItemsLabel”:{“default”:””},”addNew”:true,”newItemInDlg”:true,”addNewDlgOpt”:{“width”:””,”height”:””,”x”:””,”y”:””,”allowMaximize”:false,”showMaximized”:false,”showClose”:false,”autoSize”:false},”addNewLabel”:{“default”:”New Division”},”addNewIn”:{“disp”:true,”edit”:true,”view”:true},”addNewFolder”:false,”addNewFolderLabel”:{“default”:””},”addNewFolderIn”:{“disp”:false,”edit”:false},”addNewDocLabel”:{},”inUrl”:[{“from”:”Title”,”to”:”Org”,”hide”:false}],”folderMetadata”:[],”uploadToFolder”:true,”uploadToFolderLabel”:””,”openFolder”:true,”openFolderLabel”:””}
Field: vLookupDivisions

query:
<View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Org’ /><Value Type=’Text’>A Life Explored</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ /></OrderBy></Query></View>
Field: vLookupDivisions

Number of items matching the query: 1

[Alexander Bautz]

I have a hunch it could be the “List base URL”, but if you append “&vLookupDebug=1” to the URL you can “see” the query and the output:

Example:

/Lists/DFFS_TestList/DispForm.aspx?ID=123&vLookupDebug=1

Post the output here.

Alexander

[Kessy Similien]

I’m trying to set up dffs in a discussion list. I’ve set it up in the new, disp, and edit forms.

I’m experience a strange behaviour where DFFS will activate on the display form only for discussion replies, but not on discussion posts. The overlay still shows up but then the normal form just renders with no link to the back end. I don’t have any rules set up or anything that would prevent it from working so I’m kind of lost.

[Gerard Graham]

Hi there

I’ve implemented vLookup across a number of lists but just realised that for those in the root of my site collection, all vLookups are not working while in the edit form. They all work in the display forms, returning results as expected, but no results at all in the Edit forms. Lists in sub sites are working as expected with the vLookups working in both Edit and Display forms.

Any idea where the problem lies? I’m on DFFS 4.365 and vLookup 2.266

Regards

Gerry

[Lana]

Hi,
I have created several Web Part Pages. Each page uses the same lists with different views.
If you open the edit form for a list item, input information and save, SharePoint automatically redirects you back to the default view of the list that was just edited, away from the web part page. At least my SharePoint 2010 version does. I am unsure how else to describe this, so I have screenshots below.
I need the redirect to not redirect. To just save the item and close the modal dialog box.
Is this possible?
Thanks!
Lana

Attachments:

1. DoNotRedirectonEditSave.docx

[Alexander Bautz]

Hi,
I’m not sure I understand exactly what you mean. Where are the users write their input? – is it in an EditForm opened from the list view? I would think the default SharePoint behavior would be to redirect back to where you were?

Please note that any “&Source=/Url/To/A/Page” in the URL will causer the page to redirect to this “Source” after save.

Alexander

[Harley Malamut]

Hi Alexander,

I’ll try to download the latest release early next week, install it and see if the fixes the issue.

Question for you – how did you connect to the SQL table? Did you create an external content type, connect it to the SQL table, and then define all of the “external content type operations” – read list, read item, create, update and delete? After that, did you create the external list and then set up the 2 forms using your product?

Thanks…..

Harley

[Alexander Bautz]

Hi,
I was finally able to set up a SQL server on Azure, with a db based on a demo from Microsoft. Unfortunately I have no problems configuring DFFS with multiple tabs. I have tested in both NewForm and DispForm. I’m however using SP 2013 on Office 365 as I don’t have access to a SP 2010 server.

You can try updating to the latest version of DFFS as I handle the “missing fields” differently there, but I’m not sure this will fix it.

I’m not all that familiar with external content types and external lists, but could you possibly have modified the form to not include all fields?

Alexander

[Harley Malamut]

I created an external list that accesses a SQL table. I then updated the Display Form to use DFFS. Created 2 tabs and set 3 of the columns to be visible on the first tab and 2 of the columns to be visible on the 2nd tab.

When I use the form all of the columns show on both tabs and the columns are also duplicated on both tabs with one set showing a message – “This field is not in the current content type: narration”.

I am attaching a Word doc with screen shots to show you what this looks like.

Thanks…..

Harley Malamut

Attachments:

1. Issue-with-tabs-not-working-with-an-external-list.docx

[Alexander Bautz]

I’m sorry I cannot be of more help here. I simply haven’t had the time to set up an external list to test with. I might need to use Azure as I don’t have any local servers.

I’ll see what I can do, but in the meantime, please post any new information you might find, and maybe someone else can help?

Best regards,
Alexander

[Harley Malamut]

Hi Alexander,

That seems to be in line with what I found while researching this issue.

I guess my fall back plan is to use InfoPath for forms that need to display text and varchar SQL columns as multi-line.

I’ll try to post a new entry for that other issue with the tabs when the list is based on a SQL table sometime next week.

Thanks for looking into this for me!

Harley

[Jeff Law]

Hi
On one of my forms, I have several tabs defined, and the initial tab that gets displayed is determined by the status of one of the fields which is checked via a rule. This rule also sets which fields are read only.

What I would like to be able to do is to be able to override what fields are set to read only if the user selects another tab, or one of the field value changes.

I was thinking of creating a custom JS function to call, but I am struggling a bit to work out the easiest way of doing this. Especially as I am guessing you already have some function to do this built into DFFS. I found a hint of this browsing through the forums looking for the answer when I found this snippet

function formReady(){
 if(getFieldValue(“MultiPhase”)==”Yes”){
 spjs.dffs.unhideFieldsByRule([“Phase”]);
 spjs.dffs.flag_Mandatory([“Phase”]);
 }
 else{
 spjs.dffs.hideFieldsByRule([“Phase”]);
 spjs.dffs.clear_Mandatory([“Phase”]);
 }
 }

There looks like a range of useful functions comes close to the one I want.

Is there a list of all the functions in dffs? I must confess to not being a fulltime developer, so might be missing the obvious here.

Regards
Jeff