Alexander Bautz

Forum Replies Created

Viewing 15 posts - 4,201 through 4,215 (of 4,536 total)
  • Author
    Posts
  • in reply to: Rule processing and reversing #7982
    Alexander Bautz
    Keymaster

    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

    in reply to: Custom Filter & Selected Option Values #7981
    Alexander Bautz
    Keymaster

    Hi,
    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,
    Alexander

    in reply to: Can the form show column numbering? #7979
    Alexander Bautz
    Keymaster

    Hi,
    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

    in reply to: Chart Interactivity #7978
    Alexander Bautz
    Keymaster

    Hi,
    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-48514

    Here 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

    Alexander Bautz
    Keymaster

    Hi,
    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

    in reply to: DFFS Rules [ Activate after "Set field value" ] #7975
    Alexander Bautz
    Keymaster

    Sorry 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

    in reply to: 5,000 Item limit #7960
    Alexander Bautz
    Keymaster

    I’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

    in reply to: vLookup load time #7925
    Alexander Bautz
    Keymaster

    Hi 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

    in reply to: Where to paste the license for DFFS V3 #7922
    Alexander Bautz
    Keymaster

    Yes, 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

    in reply to: Style role #7914
    Alexander Bautz
    Keymaster

    I’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

    in reply to: Style role #7911
    Alexander Bautz
    Keymaster

    Depending 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

    in reply to: Limit SPFieldText length #7906
    Alexander Bautz
    Keymaster

    Hi,
    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-7858

    Hope this helps,
    Alexander

    in reply to: SPJS Solution Deployment / JSLink #7905
    Alexander Bautz
    Keymaster

    It took a while, but you can now test the JSLink version here: https://spjsblog.com/2015/07/11/dffs-jslink-version-for-sp2013/

    Alexander

    in reply to: Where to paste the license for DFFS V3 #7904
    Alexander Bautz
    Keymaster

    Sorry for the delay – yes, update the CEWP code you use in these forms.

    Alexander

    in reply to: Style role #7903
    Alexander Bautz
    Keymaster

    Hi,
    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

Viewing 15 posts - 4,201 through 4,215 (of 4,536 total)