0

I have a list where users can fill a column named "External effort (m/d)" (type of column is number). After that column, I have "External resource cost" column, which type is currency, and where users can write a cost of resource.

I would like to do a column validation, where if the column "External effort (m/d)" is filled, then it's required to fill "External resource cost" column. How would that function look for that column validation?

0

One approach is to use the SPServices Library Here
and within the document.ready function, get those field names and perform the validation/manipulation.

  • You can use a Content Editor WebPart and refer the .js libraries and add the code.
  • Also You can use SharePoint Designer to add the code and perform the SPField manipulation.

    • It won't be a problem if i have different content types in list? pic: pho.to/9vojC These two columns are in Planning phase, and if I close planing phase workflow automatically opens next phase. – Matej Kriznjak Dec 17 '15 at 11:38
    • if you use SPServices library, you can access the columns any point of time and whether the columns are within the content types or not. May be you can put a if condition whether the phase field is planning or closed etc. – userAZLogicApps Dec 17 '15 at 11:43
    • 1
      No need for loading extra stuff like jQuery or SPServices. SharePoint has mQuery and the PreSaveAction. Or go with CSR (on 2013) – Danny '365CSI' Engelman Dec 17 '15 at 11:45
    • @Danny, Can you pls elaborate, whats mQuery? – userAZLogicApps Dec 17 '15 at 11:46
    • There is this great website called www.Google.com ; you can type what you want to know and it will search (almost) the whole world for you. Has been around since 1998 or so.... But hey I am a nice guy.. click here – Danny '365CSI' Engelman Dec 17 '15 at 11:54

    Your Answer

    By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

    Not the answer you're looking for? Browse other questions tagged or ask your own question.