I need to create two URL buttons

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

I have a Grandparent-Parent-Child table question. My Grandparent table is ORDERS, Parent is PRODUCTS, and child is INVENTORY ADJUSTMENTS. From the ORDERS table, I am first directed to the PRODUCTS table to create a new product record. From there I click on a URL Button that directs me to INVENTORY ADJUSTMENTS where I enter quantity and pricing. Once I save from INVENTORY ADJUSTMENTS I am redirected back to the PRODUCTS table. This makes sense to me. But now I'd like to add two additional options on the PRODUCTS table in the form of URL Buttons. One "SAVE AND ADD NEW PRODUCT" and the other "SAVE AND RETURN TO ORDER." I currently have a "SAVE AND ADD NEW PRODUCT" button using this formula

"javascript:DoSaveAddAndAnother()"

But it doesn't link the new product record to the original grandparent table. How do I modify this so that it does? This would increase efficiency for entering multiple new products.

I would also like the option to save the product record and return to the Grandparent table, ORDERS. How would I write the formula for that?

Thank you.

Photo of Andrea

Andrea

  • 90 Points 75 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
There is a most useful suffix you can put on a URL formula to control where you go after the Green Save button.

& "&nexturl=URLEncode(... and put your next URL here)

Try that and let us know how it goes.
Photo of Ryan

Ryan

  • 60 Points
Mark, this is GENIUS!!!! I've been looking for a way to do this but wasn't sure it was possible. I've already got ideas on how to implement this into current processes.
Thanks Mark!!
Photo of Ryan

Ryan

  • 60 Points
Is there a way to pull data from the newly entered record and use it in the 'NextURL'? Possibly with javascript?
The formula field should be able to see any data entry made to a field once you tab out if the field. But you would need to test if it sees the data in the very last field the user enters into.