Forum Discussion

DavisMichaelsen's avatar
DavisMichaelsen
Qrew Trainee
7 years ago

Highlighting a file with a specific naming convention

I am trying to highlight a file that shows up in a report with a specific naming convention.  The naming convention is as follows: Store # - Project Type.pdf. So, an example PDF would look somethin...
File attachments
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Not tested but try this.  I'm going to solve for flagging invalid file formats.


// format should be "0001-ROOF.pdf"

var text FileName = ToText([File Attachment]);

var text ProjectNumber = Left($FileName,"-");
var text ProjectType = Part($FileName, 2,"-");
var text FileType = Right($FileName,".");

IF(
$ProjectNumber <> [Project Number]
or
$ProjectType <> [Project Type],
or
$FileType <> "pdf"), true)

// I don't know what field type your Project Number is.
// if its numeric then the formula would be



IF(
ToNumber($ProjectNumber) <> [Project Number]
......