8,849
edits
Changes
no edit summary
* '''@level2.sum(#12345#)@ > 5''' - same as previous example but using the [[Custom Field|custom field]] ID.
* '''"@level1.Anticipated Project End Date@" BETWEEN "@rootcompany.Project Start Date@" AND "@rootcompany.Project End Date@"''' - the date entered into the ''Anticipated Project End Date'' field is between the system-wide Project Start and End Dates (see [[Root Company Variable]]s)
* ''''"@opportunity.peopleid@'"!='"0'"''' - Ensure that a contact has been added to the Level 1 Person standard field.* ''''"@contacts.count(*):rolename='Supervisor'@"="1'"''' - Ensure there is exactly 1 contact at Level 1 with the role of Supervisor.* ''''"@companies.count(*):rolename='Funding Agency'@"<"3'"''' - Ensures there are less than 3 Funding Agencies in the Companies section.* ''''"@contact.supervisor.email@'"!='"@contact.referee.email@'"''' - Ensure that the contact assigned at Level 1 with the role of Supervisor is not also assigned with the role Referee.
* '''"@level1.Proposal.filename@"!=""''' - Ensures you have a Proposal uploaded in the single file upload on the Level 1.
* '''"@level1.Plan Details.numofpages@"<=6''' - Ensures the number of pages for a PDF file upload field is not more than six pages
* '''"@level1.Multiple File Uploads.numoffiles@">0''' - Ensures the number of files uploaded to a Multiple Files upload field is greater than 0
* '''"@level1.type@"!="New Grant"||"@level1.xml.ExternalPeers.peer.peer.nodecount@">2''' - Ensures that the level 1 type is 'New Grant' and number of nodes/items entered in the XML worksheet is greater than 2 items.
* '''"@level1.Amount Awarded.value@ " <= 500000''' - Ensures that the ''Amount Awarded'' field is under $500,000. The ''.value'' is necessary when the ''Amount Awarded'' field is stored in currency format.
* ''' INSTR("@level1.[#(?object=activity::criteria=typename='Referee Form' and statusname='Submitted' and eownerid=@me.userid@)~index~#]@","1")=0''' - Ensures the current user can't submit more than 1 review