Is it possible to create a relational field between 2 apps that allows file attachment to appear in a related ticket?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

We have 2 apps that I'd like to integrate with each other. The first is an Insertion Order app used by sales admins to enter order info when they sell ads and its main function has to do with accounting. The second is a Creative Services app which is a workflow solution for our enterprise art department, functioning basically as an ad agency.

I want the Sales Admin to be able to upload a Creative Brief attachment to the IO, then have a Creative Services ticket entered with a related lookup for the IO that would then pull pertinent info including the Creative Brief attachment.

So far, I haven't found a way to relate the file attachment field; is this a possibility?

Photo of Jason

Jason

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 4,208 Points 4k badge 2x thumb
I answered a post very similar to this the other day.  You cannot "lookup" a file attachment or move it; so you have to build a formula to "reference" it from its source.

https://quickbase-community.intuit.com/questions/1383822-can-anyone-provide-me-with-a-code-to-progra...
Photo of Jason

Jason

  • 0 Points
Thanks - this was very helpful. However, the table I need to reference is in a separate app. The formula seems to lookup a table that is currently in the same app, but is it possible to callout the app name in the string?
Photo of Jason

Jason

  • 0 Points
Also, will this rely on the lookup relationship field between the 2 tables to pull the record #? I might be misunderstanding how the relationship works in regards to a formula like this.
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 4,208 Points 4k badge 2x thumb
You can hardcode the URL to the other App; but you will still need the Record ID# of the source record where the file is stored.
Photo of Jason

Jason

  • 0 Points
Do you have an example of how I'd hardcode the app then the table name? I understand now how to reference the appropriate record #.
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 4,208 Points 4k badge 2x thumb
"https://  laurahillier.quickbase.com/up/bhfabntwq/a/r" &[Record ID#]& "/e78/v0"


(I have inserted spaces in the URL between the // and the realm name so the link shows correctly the construct)

Bolded items are substitutions you will need to make from 

laurahillier = your quickbase realm name

bhfabntwq = your source table dbid (click on the table where the file attachment lives and copy from the URL bar)

78 = the field id # of the File Attachment field from the table where the document is uploaded