text(formula) to load php page

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Hi .. i have text(formula) field.. here i want to load a php page on onClick function. and need to pass record id to that page also..how can i write the formula for that ?
Photo of Shihad

Shihad

  • 496 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Dinesh

Dinesh

  • 464 Points 250 badge 2x thumb
Instead of having a Formula text field to make it as a hyperlink to another external linked page, you can create a Formula URL field with the "Display as a button" unchecked.




Output with F12 Inspect Element set to the hyperlink displayed:



Regards,
Dinesh V
Photo of Shihad

Shihad

  • 496 Points 250 badge 2x thumb
Thanks Dinesh. Let me try this
Photo of Geoffrey

Geoffrey

  • 1,730 Points 1k badge 2x thumb
Hi Dinesh.  I am hijacking this thread;  I have a similar issue where I want to load an external PHP page and pass a field value into the URL as well.  The solution above is not working for me.  Also, is there any way to add this into an already existing "edit record' button?
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
To pass information to one of your code pages you can use a formula similar to this:

href=\"javascript:window.location.href = 'https://yourdomain.quickbase.com/db/yourdbid?a=dbpage&pageID=5&parent="&[Record ID#]&"'\"

Then you can receive and do what you'd like in your php page.
Photo of Shihad

Shihad

  • 496 Points 250 badge 2x thumb
Thanks