Select form based on field value

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

Is it possible to select a different form based on a field selection 

Photo of Shontay


  • 490 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 2
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
Try something like this using a formula URL field::

  "foo", "",
  "bar", "",
  "baz", ""

You will have to fill in SUBDOMAIN, DBID and ACTION placeholders.
Photo of Shane


  • 100 Points 100 badge 2x thumb
This was an excellent answer, I am trying to use this same type of formula for one of my applications. The difference is I have 2 forms on one table, one is for a Week 2 checklist, one is for a Week 4 checklist. After someone has created a checklist, I need to have a button that will allow them to view or edit the checklist on the correct form. Here is my current formula:

Case([Checklist type formula],
  "Week -2 Checklist", "",
  "Week -4 Checklist", ""

Which is enabling a blank form to be opened in the correct form type. Is there a way to encode the record ID of the record into this formula so that it can edit that record in the correct form?