Jump to content
Salesforce and other SMB Solutions are coming soon. ×

How to identify missing 'Store Only As A Reference'

Recommended Posts

I am aware that in some of the images in my container fields I have failed to check the box 'Store Only As A Reference'

Is there a way to identify those particular records?

Thanks in advance

Link to comment
Share on other sites

Yes.  GetAsText (YourContainerField) will return a single line of text, the name of the file, if the image was stored NOT as a refernece.  But for the records where it is stored as a reference you'll get multiple lines of text:


filemac://Macintosh HD/Users/eurosoba/Documents/Pretty Pix/YourFile.png

So if you loop looking for the absence of a hard return in GetAsText (YourContainerField), the positives will be those not stored as a reference.  Or else empty.


Link to comment
Share on other sites

Thanks for this, I can now identify what I need. Out of interest, how would I 'look for the absence of a hard retirn' ?

Thanks again!

Link to comment
Share on other sites

Let ( CtrAsText = GetAsText (YourContainerField) ;

PatternCount ( CtrAsText; "¶")



If you're looping through your records, you can just make that assessment and when it is 0, and the container field isn't empty, you've got an image actually stored in the container field, not a reference.  




Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

Terms of Use