How do I embed a picture from a file attachment lookup field in my Exact Form?

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

If the key field for your master table that contains the actual file attachment field is the built-in Record ID# field then you can put the following on your Exact Form:

~="<img src='/up/dbidofmastertable/a/r" + fid["11"] + "/e17'>"~

you'll need to replace "dbidofmastertable" with the dbid of the table that contains the pictures. To learn how to discover dbids please read:

http://quickbase.intuit.com/developer/node/2106

You'll also need to replace the 11 with the field identifier (fid) of the reference field that points to the master table containing the file attachment field. To learn how to discover fids please read:

http://quickbase.intuit.com/developer/node/2027

You'll also need to replace the 17 with the field identifier (fid) of the file attachment field in the master table.

If the key field of the master table containing the file attachment field is not the built-in Record ID# field then you'll need to create a lookup field that looks up the value of the built-in Record ID# field. Then you'll need to use the fid of that lookup field to replace the eleven in the example above.

Tags:

34052 reads

Comments

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <p> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <param> <strike> <caption> <img> <h1> <h2> <h3> <h4>
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>, <xml>. The supported tag styles are: <foo>, [foo].
Images can be added to this post.

Plain Text

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>

More information about formatting options

Word verification: * Type the characters you see in this picture.

(verify using audio)

Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

Knowledge Base