The $ObjectType global gives you access to refer to elements of your Salesforce org's schema. It does not provide access to cross-relationship data, or any data at all in actual records; it only yields information about the objects and fields in the org.
If your object has a field Relationship__c, you'd refer to its fields in a validation rule via the ...
((field_name = 0) || (field_name = 1)), 'Test 1', IF( ((field_name < 0) || (field_name = 2) || (field_name = 3)), 'Test 2', '') )
Instead of using ,'' for your false return on the first if statement, you want to use your next if statement. That way it reads more like
if first option is false, if second option is false, then ''
Please have a look to following salesforce help link
you can build formula with several IFs like following
IF($User.City = "Napa", 0.0750,
IF($User.City = "Paso Robles", 0.0725,
IF($User.City = "Sutter Creek", 0.0725,
IF($User.City = "Los Olivos", 0.0750,
IF($User.City = "Livermore", 0.0875, null
I found the solution. Below is the soql to get the Files and Notes related to Account/any other object.
SELECT contentdocumentid, Linkedentity.name,SystemModstamp, ContentDocument.title FROM ContentDocumentLink where Linkedentityid IN (SELECT Id FROM account)
To get the download links of your files or Notes, you need to take the contentdocumentid from ...