LinkedIn
Twitter
I need to figure out how to trigger an action when a form is cancelled.
Situation:
- An action button from a detail view launches a form view.
- Before it goes to the view it blanks out the Bin ID field so the QR reader pops up automatically.
- But if I cancel the form it should go back to the original Bin ID.
AFAIK, LINKTOROW() is the correct function for this but it does not allow you to pre-fill fields.
Therefor I am using a grouped action
Ignore the "Log Put In Stock" function
1. Sets the values of columns in the row
2. LINKTOROW() to my form. (the form is a special view that only shows certain columns. Input is not stable enough for my purposes, still beta)
When I hit cancel in the form it returns to the detail view but the Bin_ID is blank.
Can I create a third action that puts it back in (from my log history) if the form is canceled?
Is there another solution besides INPUT()?
Solved
1 ACCEPTED SOLUTION
1. I ended up creating a "buffer" table, that has columns matching just like the "real" table
(another way to do this would be to create a new temporary row in the existing table or have hidden columns in the table like @Joseph_Seddik suggested , depends on use case ig)
2. An action from the real table detail view triggers a LINKTOFORM() that creates a new entry in the buffer table with a view for the appropriate fields.
3. The form advances automatically as the user enters info.
4. On cancel nothing happens, just goes back to the original detail page.
On save, it triggers a reference action to a group action on "real" row.
5. The grouped action
- copies the fields from the "buffer" into the "real" row
- logs that the action tool place in a log
- deletes the buffer row
- sends you back to the original detail page
