[Steve]

I don’t understand exactly what you mean. Do you want to lock ALL items in the list at 09:00, or only those that have a due date on that same day?

Only those that have a due date on that same day.

And if the item has a due date “today” – locking it at 09:00 should keep it locked permanently?

Yes, keep it locked permanently after “today” – 09:00.

Steo

[Steve]

Well, all columns have been set as “Number”. I set them as “one line of text” and it works out.

• This reply was modified 4 years, 10 months ago by Steve.

[Steve]

The last thing, I cannot save the “item”, because of the value, for example: “0.7“, but in Czech, we have the value with a decimal point (comma) “0,7“. Can you help me?
Otherwise, it works perfectly.

Steo

Attachments:

1. 

   Input_number.png
   

[Steve]

Thank you Alex for pointing out the errors.
Now, it works perfectly.
Steo

[Steve]

Hi Alex,
I tried that and it worked perfectly. Then I made “tot” read-only and customized the JS function and it also worked followed by your instructions. But I need to sum 5 columns summed in “tot” column. So I have created 5 columns. “sumAll” is a column where it adds up.

Here is my code:

jQuery("#dffs__x0043_hK1000 input, #dffs__x0043_hK450 input,#dffs_RozStan50 input, #dffs__RozGrah60 input, #dffs_Vian350 input").on("keyup",function(){
    var str = jQuery(this).val().replace( /[^0-9.]/g, "" );
    jQuery(this).val(str);
    setFinalCost();
});

function setFinalCost(){
	var a, b, c, d, e, f, aa, bb, cc, dd, ee, ff;
	a = Number($("#dffs__x0043_hK1000 input").val());
	b = Number($("#dffs__x0043_hK450 input").val());
	c = Number($("#dffs_RozStan50 input").val());
	d = Number($("#dffs_RozGrah60 input").val());
	e = Number($("#dffs_Vian350 input").val());
	f = Number($("#dffs_sumAll input").val());
	aa = !isNaN(a) ? a : 0;
	bb = !isNaN(b) ? b : 0;
	cc = !isNaN(c) ? c : 0;
	dd = !isNaN(d) ? c : 0;
	ee = !isNaN(e) ? c : 0;
	ff = !isNaN(f) ? c : 0;
	
	if(isNaN(a)){
		alert("Number format error in \""+spjs.dffs.fieldData._x0043_hK1000.disp+"\"");
	}
	if(isNaN(b)){
		alert("Number format error in \""+spjs.dffs.fieldData._x0043_hK450.disp+"\"");
	}
	if(isNaN(c)){
		alert("Number format error in \""+spjs.dffs.fieldData.RozStan50.disp+"\"");
	}
	if(isNaN(d)){
		alert("Number format error in \""+spjs.dffs.fieldData.RozGrah60.disp+"\"");
	}
	if(isNaN(e)){
		alert("Number format error in \""+spjs.dffs.fieldData.Vian350.disp+"\"");
	}
	if(isNaN(f)){
		alert("Number format error in \""+spjs.dffs.fieldData.sumAll.disp+"\"");
	}
	setFieldValue("Tot",aa+bb+cc+dd+ee+ff);
	setTimeout(function(){
		$("input.fieldValueUpdated").removeClass("fieldValueUpdated");
	},1000);
}

Thank you in advance.
Steo

[Steve]

Thank you so much Alex, it helped me a lot.
Thank you
Steve

[Steve]

spjs.ac.textField({
 "applyTo": "n2k6",
 "helpText": "Sem zadejte požadovanou roli",
 "loadText": "Čekejte prosím",
 "listGuid": "{8c19e719-01f7-4248-9fc8-188bb360f736}",
 "listBaseUrl": "/apps/xxxx/Stepan",
 "showField": "Hledej",
 "searchFields": "Hledej", (Is this doing something wrong)?
 "filterCAML": "",
 "useREST": false,
 "preloadData":false,
 "filterREST": "",
 "optionDetailFields": [],
 "optionDetailPrefix": [],
 "enforceUniqueValues": true,
 "rowLimit": 10,
 "listOptionsOnFocus": false,
 "minLengthBeforeSearch": 3,
 "reValidateOnLoad": false,
 "allowAddNew": false,
 "isLookupInSelf": false,
 "addNewAdditionalFields": [],
 "multiselect": false,
 "multiselectSeparator": "; ",
 "orderBy": [],
 "clearSetFieldsOnInvalidSelection": false,
 "setFields": [],
 "debug": false
});

I tried this and it’s been kind of working, but…I still cannot set it up. It looks like searching, but it cannot find anything. I followed your manual, but I probably forgot for something or missed.

I just have a list of people (list A) (people are written in a single line of text column). Then I have a form (list B) with “single line of text” where I want to see the data autocompleted from the list A.

Another help for me?
Sorry, Alex for the delay.

Steve

• This reply was modified 5 years, 7 months ago by Steve.

Attachments:

1. 

   Loading.jpg
   

2. 

   listwithPetr.jpg
   

3. 

   errors_debug.png
   

[Steve]

Thank you so much, I’ve spent all day trying to do it in Javascript.

Steve.

[Steve]

If I understand the vLookup function, it won’t help me at all. Initiation of a form offers the author specific columns like -Type of product, the number of the product, the validity of price since, expiration dates etc.… If I always wanted to have the same data taking from another list (vLookup) then it would be a perfect way how to do it. But…

There are too many specific data filling in the columns in the form, that means I need only some columns to be copied, but They always change. It’s hard for me to describe the situation, but the Copy button is the best way how to solve my problem out.

• This reply was modified 5 years, 9 months ago by Steve.

[Steve]

Alex, It’s working so, there is no problem with those errors. I changed nothing, I was just looking at the wrong list on the same page. My mistake. When I clicked on the web “xxxxx” on SharePoint, the list has shown up where I use the javascript. But I had to click on the list at navigation panel.

Now, all of it is working. Thank you very much Alex.

[Steve]

Thanks Alex, the first form doesn’t save. I do not need the second form to be saved automatically. I fill the columns in the NewForm, then I hit “Save and Copy”, another NewForm is initiated but its predecessor (first form) did not save at all.

And you were right, I wan to make changes in the “copied” form.

Steve

[Steve]

Alexander, it works! The break in that line was a mistake and that’s why it did not work out. Now, it’s working, but…

If I create a new form, then I fill in columns, then I hit “Save and Copy” – the new for is initiated but it hasn’t saved.

[Steve]

I’m sorry Alexander but still I cannot see a button at the bottom of the form and the same error pops up whenever I put commas, for example: “Cena”, “StavSchvalovani”,.. Even if I remove them.
The error says: The operation cannot be completed due to error 80020101. The Code looks like:

// If creating a copy
if(GetUrlKeyValue("CreateCopy") === "1"){
    var str = sessionStorage.getItem("SaveAndCreateNewData"), data;
    if(str !== null){
        data = JSON.parse(str);
        jQuery.each(data,function(fin,val){
            setFieldValue(fin,val);
        });
    }
}

// Add button
jQuery("input[id$='_diidIOSaveItem']").before("<input type='button'
class='ms-ButtonHeightWidth' style='margin-right:4px;' value='Save and Copy' onclick='saveAndCopy()' />");

var createCopyWhenSaving = false;
function saveAndCopy(){
    createCopyWhenSaving = true;
    spjs.dffs.triggerSave();
}

function dffs_PreSaveAction(){
    if(createCopyWhenSaving){
        var arr = [
            "%5Fx0031%5FatributPolozky",
            "NazevPolozky",
            "DruhPolozky",
            "SubdruhPolozky",
            "BaleniAhmotnost",
        ];
        var data = {};
        jQuery.each(arr,function(i,fin){
            data[fin] = getFieldValue(fin);
        });
        sessionStorage.setItem("SaveAndCreateNewData",JSON.stringify(data));
        // Redirect
        spjs.dffs.redirect(location.pathname + "?CreateCopy=1",false);
    }
    return true;
}

[Steve]

Hi Alex,

I’ve done everything. I don’t see a button at the bottom of the form. An error pops up – as you can see in the picture.

In accordance with your last paragraph, dffs_PreSaveAction is not included in my form.
One sidelight, I have a button “Load data” that is made in javascript above the form in webpart in content editor. It’s not made in DFFS. Could that be a problem?

Thank you for your time Alex you spend with this article.

Steve

• This reply was modified 5 years, 9 months ago by Steve.

Attachments:

1. 

   Error.jpg
   

[Steve]

Thank you very much for the code. I’m not great in javascript and coding such as. Please, could you tell me where I should put my “IDs (URLs)” of columns etc? At this moment, it does not work. But I probably have some mistakes in the code. Could you check it? Thank you once again.

// If creating a copy
if(GetUrlKeyValue("CreateCopy") === "1"){
    var str = sessionStorage.getItem("SaveAndCreateNewData"), data;
    if(str !== null){
        data = JSON.parse(str);
        jQuery.each(data,function(fin,val){
            setFieldValue(fin,val);
        });
    }
}

// Add button
jQuery("input[id$='_diidIOSaveItem']").before("<input type='button'
class='ms-ButtonHeightWidth' style='margin-right:4px;' value='Save and Copy' onclick='saveAndCopy()' />");

var createCopyWhenSaving = false;
function saveAndCopy(){
    createCopyWhenSaving = true;
    spjs.dffs.triggerSave();
}

function dffs_PreSaveAction(){
    if(createCopyWhenSaving){
        var arr = [
            "Cena"
            "CenoveHladiny"
            "Cena"
            "StavSchvalovani"
            "CenaZaPrepravku"
        ];
        var data = {};
        jQuery.each(arr,function(i,fin){
            data[fin] = getFieldValue(fin);
        });
        sessionStorage.setItem("SaveAndCreateNewData",JSON.stringify(data));
        // Redirect
        spjs.dffs.redirect(location.pathname + "?CreateCopy=1",false);
    }
    return true;
}

[Author]

Posts