Maciek Grischke

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 55 total)
  • Author
  • in reply to: Rules are not correctly applied on load in EditForm #35471
    Maciek Grischke

    The attached JSON for EditForm does not include the “Accident” Rule because as soon as I add it, it breaks Behavioural and Non-Behavioural rules. Medication rule is still working.

    in reply to: Save for later Button #32696
    Maciek Grischke

    Hi Alexander,

    is there a way to move the additional button (Save for Later) up within the form?

    in reply to: Working on it… takes long with many fields (not DFFS) #31211
    Maciek Grischke

    Hi Alexander,

    sorry for a late reply – only just got to it now.

    I don’t seem to have any options for the content type in the affected list settings page.

    Have I not enabled something on my SharePoint site?

    in reply to: Email format check in text field #30719
    Maciek Grischke

    Thanks Alexander, it work’s great, however no alert is displayed for some reason.
    I tried with several spaces and different combinations. All spaces are replaced with semicolon, which is fine, but no alert 🙁

    in reply to: Email format check in text field #30651
    Maciek Grischke

    Thanks Alexander,

    The text field is a Single line of text, but I guess I could convert it into multiline.

    I was using this so far:

    //remove spaces from email addresses
    jQuery(“#dffs_Title input”).on(“keyup”,function(e){
    var str = jQuery(this).val();
    jQuery(this).val(str.replace(‘ ‘, ” ));

    It will not allow users to enter any spaces but when it comes to separating email addresses, users will likely leave two email addresses merged together when they decide to use a space and not semicolon, and without looking.

    I know this one could be very tricky.

    in reply to: Field CSS – field background colour #28947
    Maciek Grischke


    How can I apply different colors to different Priorities? Can I do it in Field CSS?

    in reply to: vLookup, currentUser and rules #27723
    Maciek Grischke

    Hi Alexander,

    here’s what I want to do.

    There are two lists:
    – Employees and
    – Holiday Requests.

    The Employees list contains their AL entitlement, balance in hours.

    When the employee requests a holiday via Holiday Request list, I want the NewForm to display their AL balance pulled from the Employees list.

    So, if Tony opens a NewForm in Holiday Requests list, I would like the form to locate this employee via their name in the Employees list, pull the AL allowance information and display it in the NewForm. Next, if the AL balance is less than their request, i.e., Tony is requesting to take 50 hours of holiday, but his balance is only 45 hours, in this case, I want the rule to kick in and display a warning message and hide Save button etc.

    At the moment the form allows them to submit their holiday request and I have a Flow to check their AL balance and if their balance is not enough, the Flow will reject their request and send them an email. The Flow locates their record in the Employees list via their name. There are two name columns in the Employees list: User field and Text field. In Flow, I use the “Get Items” action with OData filter and OData filter doesn’t work with user fields, hence I also use a text field to store their Display Name.

    Hope this makes sense.

    in reply to: Hide Gear Icon on New Experience #25913
    Maciek Grischke

    Thanks Alexander.

    I tried it, but I am getting this error:

    jquery-3.4.1.min.js:2 POST'53eea4ac-f648-4360-8895-508a2940dd54') 415
    send	@	jquery-3.4.1.min.js:2
    ajax	@	jquery-3.4.1.min.js:2
    toggleVisible	@	SiteContentsSettings.aspx:709
    onclick	@	SiteContentsSettings.aspx:1
    {readyState: 4, getResponseHeader: ƒ, getAllResponseHeaders: ƒ, setRequestHeader: ƒ, overrideMimeType: ƒ, …}
    abort: ƒ (e)
    always: ƒ ()
    catch: ƒ (e)
    done: ƒ ()
    fail: ƒ ()
    getAllResponseHeaders: ƒ ()
    getResponseHeader: ƒ (e)
    overrideMimeType: ƒ (e)
    pipe: ƒ ()
    progress: ƒ ()
    promise: ƒ (e)
    readyState: 4
    responseJSON: {error: {…}}
    responseText: "{"error":{"code":"-1, Microsoft.SharePoint.Client.ClientServiceException","message":{"lang":"en-US","value":"The HTTP header Content-Type is missing or its value is invalid."}}}"
    setRequestHeader: ƒ (e,t)
    state: ƒ ()
    status: 415
    statusCode: ƒ (e)
    statusText: "error"
    then: ƒ (t,n,r)
    __proto__: Object

    I am a site admin / global admin so I assumed I have enough rights?

    Also, what I have used so far via scriptlink is:

    addCSS("#applist {display:none !important}");
    function addCSS(css){
    var head = document.getElementsByTagName("head")[0];
    var s = document.createElement("style");
    s.setAttribute("type", "text/css");
    if (s.styleSheet) {
    s.styleSheet.cssText = css;
    } else {

    which hides everything from the view and if I need to show the list, I paste this in the console:

    addCSS("#applist {display:block !important}");
    in reply to: Generate directions URL from two postcode fields #25705
    Maciek Grischke

    Ok I got it working using this code:

    function calcMileage() {
        var startPostcode = getFieldValue("StartPostcode");
        var endPostcode = getFieldValue("EndPostcode");
        var roundTrip = getFieldValue("RoundTrip");
        var origin1 = startPostcode;
    // var origin2 = 'Greenwich, England';
        var destinationA = endPostcode;
    // var destinationB = new google.maps.LatLng(50.087692, 14.421150);
        var service = new google.maps.DistanceMatrixService();
        origins: [origin1],
        destinations: [destinationA],
        travelMode: 'DRIVING',
    //    transitOptions: TransitOptions,
    //    drivingOptions: DrivingOptions,
        unitSystem: google.maps.UnitSystem.IMPERIAL,
        avoidHighways: false,
        avoidTolls: false,
      }, callback);
    function callback(response, status) {
            var roundTrip = getFieldValue("RoundTrip");
      if (status == 'OK') {
        var origins = response.originAddresses;
        var destinations = response.destinationAddresses;
        for (var i = 0; i < origins.length; i++) {
          var results = response.rows[i].elements;
          for (var j = 0; j < results.length; j++) {
            var element = results[j];
            var distance = element.distance.text;
            var duration = element.duration.text;
            var from = origins[i];
            var to = destinations[j];
            var miles = distance.split(" ");
            var miles2 = miles[0];
            if (roundTrip === true) {
            var miles3 = parseFloat(miles) * 2;
    //        alert(miles3);
            } else {

    but the above requires

    [script async defer src=">

    to be loaded first. I used square brackets for script tags so they don’t get deleted.

    I included this bit in the NewForm “Script Editor” web part.

    Alexander, is this the correct way? It works great, but I want to avoid API to be called every too many times.

    in reply to: Generate directions URL from two postcode fields #25701
    Maciek Grischke

    Hi Alexander,

    I updated my reply a few times and I got it working now with my new API.

    Do you think there’s a way to paste the miles into a field after entering both postcodes? ?

    I’m just investigating JS tutorials online. I’m sure there’s a way.

    in reply to: Generate directions URL from two postcode fields #25694
    Maciek Grischke

    That’s amazing, thanks.

    It’s all good.

    Do you think there’s a way to paste the miles into a field after entering both postcodes? 😀

    in reply to: Calculation in rules #25656
    Maciek Grischke

    How can I disable the manual input and force users to only use a “date picker”?
    I’ve tried with “read-only” option, but it disables the field entirely. There’s no date picker button.

    in reply to: DFFS sum multiple fields in a totals field #25654
    Maciek Grischke

    Thanks for this, it works great in all browsers.

    In relation to those red messages, I think they’re not related to the form itself. I think it relates to some broken scriptlinks or other JS files I previously used on that test site.

    in reply to: Count weekdays & weekends between two dates #25647
    Maciek Grischke

    I’ve managed to do it without Moment.js and here’s how:

    //Count weekdays and weekends
     function onCallDays() {
        var onCallStartDate = getFieldValue("OnCallStart");
        var onCallEndDate = getFieldValue("OnCallEnd");
    // the following 4 lines convert UK date format MM/DD/YYYY (my sharepoint region) to US date format DD/MM/YYYY needed for JS to work in my case
        var startDate2 = onCallStartDate.split("/");
        var endDate2 = onCallEndDate.split("/");
        var startDate3 = startDate2[1] + "/" + startDate2[0] + "/" +startDate2[2];
        var endDate3 = endDate2[1] + "/" + endDate2[0] + "/" +endDate2[2];
    // the next two lines are first and second date
        const date1 = new Date(startDate3);
        const date2 = new Date(endDate3);
    // this line retrieves a day number ie Sunday is 0, Saturday is 6, this line is not required, I used it for console.log
        var dateN = date1.getDay();
    // the next two line count the difference in days between two dates
        const diffTime = Math.abs(date2.getTime() - date1.getTime());
        const daysDiff = Math.ceil(diffTime / (1000 * 60 * 60 * 24))+0;
        var weekDays = 0;
        var weekEnds = 0;
        var dateTn = 0;
    // this is where counting begins
        for (var i=0; i<=daysDiff; i++) {
          var dateT = date1.setDate(date1.getDate() + dateTn);
          var dateR = new Date(dateT);
          var dayN = dateR.getDay();
          if (dayN>0 && dayN<6) {
        if (dayN===0 || dayN==6) {
        dateTn = 1;

    Alexander, it works, but if you think there’s a more efficient way to do this, please correct me.

    The examples I’ve seen online were much bigger, but perhaps they included “holidays”, which I didn’t need.

    in reply to: Calculate time difference in hours or minutes #25636
    Maciek Grischke

    Here’s the screenshot(s):

    This is a “calendar” list.

Viewing 15 posts - 1 through 15 (of 55 total)