Forum Replies Created
-
AuthorPosts
-
Alexander BautzKeymaster
Hi,
What kind of field is Field1 and Field2? – if they are boolean (Yes/No) you must use true for checked and false for unchecked.Hover over the help icon for details for each selected trigger.
Alexander
Alexander BautzKeymasterHi,
Sorry for the late reply. I’m not 100% sure I understand what you mean, but you can add code like this to get the option in a variable:You must use the developer tools (hit F12 > DOM Explorer) to inspect the dropdown to find its ID – mine has the ID “f3cf96da-cfb5-43b8-b6c4-1024b8231639_CustomFilterSelect_FieldInternalName”:
var selectedVal = $("#f3cf96da-cfb5-43b8-b6c4-1024b8231639_CustomFilterSelect_FieldInternalName").find("option:selected").val(); alert(selectedVal);
You can also set it up “live” like this:
$("#f3cf96da-cfb5-43b8-b6c4-1024b8231639_CustomFilterSelect_FieldInternalName").bind("change",function(){ alert("selected value: "+$(this).find("option:selected").val()); });
Hope this helps,
AlexanderAlexander BautzKeymasterHi,
Sorry for the delay. Here is a pure CSS example – found in this page: https://css-tricks.com/numbering-in-style/Add this to the Custom CSS in the backend:
.ms-formtable{ counter-reset: spjs-css-counter; } .ms-formtable h3:before { content: counter(spjs-css-counter); counter-increment: spjs-css-counter; font: bold 25px/1 Sans-Serif; }
This will number the columns from the top, so if you have some hidden columns you could use something like this in the Custom JS section to add the number to only the visible columns in JavaScript:
function customFieldNumber(){ spjs.$(".customFieldNumber").remove(); setTimeout(function(){ spjs.$("td.ms-formlabel:visible").each(function(i,td){ spjs.$(td).find("h3").prepend("<span class='customFieldNumber'>"+(i+1)+"</span>"); }); },1); } // On tab change spjs.$("li.tabBase").click(function(){ customFieldNumber(); }); // On page load customFieldNumber();
Style the new number in the Custom CSS like this:
.customFieldNumber{ font-size:25px; color:green; }
Alexander
Alexander BautzKeymasterHi,
Unfortunately the documentation is not as good as it should be, but I have mentioned a “selectionHandler” here: https://spjsblog.com/2013/03/11/spjs-charts-for-sharepoint-export-to-excel-and-sp2013-support/#comment-48514Here is the code example:
function spjs_chartSelectionHandler(chartID,selection,data){ var message, item, value; message = ""; value = ""; item = selection[0]; if(item.row !== null && item.column !== null){ message = "{row:" + item.row + ",column:" + item.column + "}"; value = data.getValue(item.row, item.column); if(message === "") { message = "nothing"; } alert("You selected " + message +", the value is: "+value); } }
This code must be added to the MASTER CEWP – above the “spjs-charts-v4.js” script – for example below the license code.
Let me know how this works out.
Alexander
July 25, 2015 at 08:26 in reply to: Programmatically set field to “Required” based on multiple inputs #7976Alexander BautzKeymasterHi,
I’m glad you figured it out – I have a hard time following up all emails and forum posts so there will unfortunately be some time delay on my answers.Alexander
Alexander BautzKeymasterSorry for the delay – I have been away for a few days.
I have not been able make the set field value consistently trigger attached rules, but in later versions you can set up the rule which sets the field value to manually call the “next” rule.
Look at the “Run these functions / trigger these rules” field in the rule setup.
Unfortunately this is not available for the older versions.
Alexander
Alexander BautzKeymasterI’m fairly confident it should handle the 5000 items limit – Have you tested it?
If it does not work, I might have another version that have not been published.
Alexander
Alexander BautzKeymasterHi Gerry,
I have finally been able to look at this problem. I believe it has now been sorted in the latest vLookup plugin (frontend v2.208 and backend v2.203) – can you please test to see if the problem i solved?Alexander
Alexander BautzKeymasterYes, but when using v3.x you must use the “old” variable name – like described in page 6 here: https://files.spjsworks.com/files/DynamicFormsForSharePoint/v4/InstallationManual/How%20to%20set%20up%20DFFS%20v4%20-%20v1.3.6.pdf
If you have a v3.x license, you can use this by using the old variable name like
“spjs_license” instead of “spjs_dffs_license”.Alexander
Alexander BautzKeymasterI’m glad you got it working. If I remember correctly, you must set the option “IsStacked” to true to have the bar width to the full width.
Alexander
Alexander BautzKeymasterDepending on the data-source you may be able to use the method in this page: https://spjsblog.com/2013/10/02/spjs-charts-for-sharepoint-v4/
Scroll down to “Configuring your first chart” and look at the screenshots.
Could this be used?
Alexander
Alexander BautzKeymasterHi,
Sorry for the delay. My current solution does not support DFFS, but here is a link to a solution created by Andrew: https://spjsblog.com/forums/topic/dffs-form-examples/#post-7858Hope this helps,
AlexanderAlexander BautzKeymasterIt took a while, but you can now test the JSLink version here: https://spjsblog.com/2015/07/11/dffs-jslink-version-for-sp2013/
Alexander
Alexander BautzKeymasterSorry for the delay – yes, update the CEWP code you use in these forms.
Alexander
Alexander BautzKeymasterHi,
The style role is currently not supported (was not available when I created the current release), and if you want to have different colors on the bars, I’m afraid you need to split the data in separate series. Can this be achieved by using some calculated columns so you can add the data columns as multiple rows in the configuration and get different series?The calculated column “CustomValue1Column” could look like this:
=if([The original column name]="value1","1","0")
And the calculated column “CustomValue2Column” could look like this:
=if([The original column name]="value2","1","0")
Then you add the new columns “CustomValue1Column” and “CustomValue2Column” as separate series (using “sum”).
Could this work?
Alexander
-
AuthorPosts