I’m attempting to create a child record using vLookup to a list where I’m using the Cascading Drop down plug in (3.3). The new form displays correctly but I can’t prefill the field I want which happens to be the first of the two dropdown fields. I can set a simple text field to the desired value but not the field referenced in the cascading drop down. Is there some way of achieving this?
Hi Alexander,
I’m trying to use this on a web part page, not on a New or Edit form page as a webpart dropdown filter that is connected to a List Web Part on the same page.
Can you please advise if this can be done by replacing the Single-line Text Field to for example a HTML Form Web Part?
If not, which solution could I use that can do this?
I’m currently using a manual HTML Form Web part to display a drop down of names, like this post: http://www.sharepointbinder.com/1/post/2012/02/filters.html but I would like to do this dynamically.
Thanks,
Brett
-
This topic was modified 10 years, 1 month ago by
Brett.
https://contoso.com/PWA/scripts/DFFS/DFFS_backend.aspx?targetList={0e30b85c-b447-4a0f-a229-9e284a36fd48}&targetListBaseUrl=/PWA/Training – BSI2 – WE&formId=/pwa/training – bsi2 – we/lists/riskregister/newform.aspx&formType=1&Source=/PWA/Training%20-%20BSI2%20-%20WE/Lists/riskregister/NewForm.aspx
site url is: /PWA/Training – BSI2 – WE
Michal
Hi Alexander,
thanks for reply.
It seems, that configuration you described is quite similar. But do not work for me. Maybe I missed something.
All the scripts are located here: /PWA/scripts (PWA=site collection / scripts=document library)
Under PWA is created subsite “template”: /PWA/template
DFFS configuration is stored here: /PWA/Lists/SPJSDynamicFormsForSharePoint
“DFFS_backend_CEWP.html”:
var dffs_configListBaseUrl = "/PWA";
In the “DFFS_frontend_CEWP.html” I have these variables:
var dffs_configListBaseUrl = "/PWA";
var spjs_dffs_backend = "/PWA/scripts/DFFS/DFFS_backend.aspx";
(scripts=document library, DFFS=folder)
This setup store configuration for “template” subsite as:
/lists/riskregister/newform.aspx
But for other sites – at the same url level (/PWA/NewSite):
/PWA/NewSite/lists/riskregister/newform.aspx
I use different names than you, but location and configuration (as I hope) is basically the same.
What is wrong?
Thanks
Michal
-
This reply was modified 10 years, 1 month ago by
Michal Riha.
-
This reply was modified 10 years, 1 month ago by
Michal Riha.
-
This reply was modified 10 years, 1 month ago by
Michal Riha.
I’m glad you sorted it out. Unfortunately you cannot use DFFS with related lists. Have you considered using vLookup?
By the way, DCH most likely had the correct answer, but if you have the ID attribute in the URL you must prefix the “contents” with & like this:
.../DispForm.aspx?ID=2&contents=1
Alexander
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
I have a form with 2 different lookups in it that I want to use the SPJS-Lookup functionality for.
One for Company Names which is contained in a Company List, and one for Project Names which is contained in a Project list.
It is probably my ignorance, but I cant see how I can define 2 fields in the spjs.lookup.init command.
Is this possible?
Regards
Jeff
I have this line in DFFS_frontend_CEWP.html and DFFS_backend_CEWP.html:
var dffs_configListBaseUrl = “/PWA“;
(PWA is site collection)
create subweb https://friendlyurl/PWA/template
and configure DFFS for list name riskregister
Than configuration record is created in
https://friendlyurl/PWA/Lists/SPJSDynamicFormsForSharePoint
with title: /lists/riskregister/newform.aspx
I expected that when save this subsite as template and create new site from this template (as a subsite of /PWA – same level as template):
https://friendlyurl/PWA/NewSite
it will connect to the same configuration entry as template (and actually all new subsites under /PWA will use the same configuration entry)
but a new conf. entry is created:
/pwa/NewSite/lists/riskregister/newform.aspx
How to setup it? Is it possible to ensure that for all subsites under /PWA I will have one configuration entry in SPJSDynamicFormsForSharePoint list?
Thanks
Michal
Here is the value in my PatternFormat field. And the URL below is what is in the ‘https://URLGeneratedByPatternFormat’ above (including the single quotes).
<a href='https://sharepoint/sites/site/Lists/List/View.aspx?View={9398E27A-31BE-4CFA-89B4-837F6F111E36}&FilterField1=Status&FilterValue1={0}' target='_blank'>{0}</a>
-
This reply was modified 10 years, 1 month ago by
DCH.
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
Alexander,
I’ve read and reread the Google instructions, and tried to format my value in many different ways, but I can’t get the PatternFormat to work for a Table Chart.
My setup page saves ok, but then I get “Syntax Error: Invalid Character” in a popup when the page reloads, and then “Error loading chart. Enter setup to recover the last good configuration.” once I click through the dialog.
I am trying to use the value in one column to build a hyperlink to a filtered list view that supports the count of those items. Can you help me with the correct syntax?
Thanks!
Requester is the name of my people picker on the service ticket. so it should read the requester and then look in the equipment list and match AssignedTo in that list..
when you say pull the information from are you meaning that what ever is in requester will populate the dropdown?
i thought the below code would populate the dropwodn with the title
“fieldToConvertToDropdown”:[“Equipment”],
“optTextFieldInternalName”:”Title”,
“listName”:”Equipment”,
“listBaseUrl”:”/Intranet/IT/”,
“sortFieldName”:”Title”,
And the CAML would read my current form and get the ID from the requester Field and the look in Equimpnet for that name in the AssignedTo column
Is it possible to add a button in the edit form that will commit changes in the form to the SharePoint list, but post back to the edit form? I’ve tried putting in a header with
<input type=”button” value="Submit” name="btnSave" onclick="javascript: {ddwrt:GenFireServerEvent(‘__commit’)}” />
and several similar variations, but it seems that because the code is inside DFFS instead of on the native page, it doesn’t get transformed into the proper postback event on page rendering. Is there a quick and easy way to do this?
I don’t have any other code solutions working on that list, only custom css, and that is not on the NewForm.aspx page only a list view. I will try and start on a fresh list and see if that works. Oh, the list I am trying to use this on is a Calendar list. Since I know those can behave differently, do you think that would cause any issues?
I have a CEWP underneath the form that references this txt file. The form worked once initially and created a list configuration item and list. Now it no longer works and pops up with the message I mentioned earlier. Also the “Enhance with DFFS” option that renders below the form isn’t working either. It did work one time and hasn’t since then. I don’t know if its a fluke? I can try blowing away the CEWP and List and again, if you think that might work?