Pull information out of a report link.

  • 1
  • 3
  • Question
  • Updated 2 years ago
  • Answered
Hello,

I was wondering if there is a way, through script, 3rd party or within Quickbase, to pull information out of an embedded report link and put into one consolidated field on the record.  
   
To give some background I am looking to get a list of email addresses from an embedded report and have them pull into a field. This would be used when creating an email using a formula URL mailto button.  I know there is a native feature to create an email from a report link using the blue mail button on the bottom but I would need that button to pull in a template for the body, subject line and cc fields.

I now have these two buttons I just need to combine them somehow.  Anyway ideas or help would be greatly appreciated.
Photo of Jacob

Jacob

  • 738 Points 500 badge 2x thumb
  • Stuck

Posted 2 years ago

  • 1
  • 3
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
If there are a limited number of child records and there is a relationships such as 1 Clients has many contacts, then you can use a technique called reverse relationships to float up non numeric data such as text or email addresses from children to the Parent record.  It is a practical solution for say up to half a dozen child records.

Is there a relationship?  What is the maximum # of children that it would need to handle?
Photo of Jacob

Jacob

  • 738 Points 500 badge 2x thumb
There is a relationship so there is a chance that I could use reverse relationship method unfortunately some of the clients may have up to 20+ contacts. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
I think that you may run into performance issues or possible future QuickBase limitations with making 20 reverse relationships.
Photo of Jacob

Jacob

  • 738 Points 500 badge 2x thumb
Ok, we use the reverse relationship method in other parts of our environment but I agree that 20 may be difficult to maintain.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,572 Points 20k badge 2x thumb
Photo of Jacob

Jacob

  • 738 Points 500 badge 2x thumb
Great, I am assuming that this uses the image-onload technique?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,572 Points 20k badge 2x thumb
Maybe. If you want to initiate on a button click you can defer loading script till that the button click enent. If you use IOL you detect the button click with a listener in the script module.js.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,572 Points 20k badge 2x thumb
I should also mention that if you just want to send plain text email you can do that from script using QBI_SendMail and don't need to use mailto protocol.
Photo of Harrison Hersch2

Harrison Hersch2

  • 400 Points 250 badge 2x thumb
Note that this can also be achieved with Zapier and QuickBase webhooks. See my uservoice entry here: https://quickbase.uservoice.com/forum...