HI everyone, I was wondering if itยดs possible to use an action to โadd a new to row to another table using values from this rowโ, and somehow opening a form to edit that โnew rowโ in the child table, all in one action.
Solved! Go to Solution.
In principal same trick will solve.
Youโd need three actions:
Create the row.
Navigate to that new row.
A grouped action to perform (1) and (2).
Iโve been struggling to find a way to do this for a couple of days and would also really appreciate a detailed answer. It seems like a scenario that will crop up frequently.
Kindly provide with an expressions example so as to perform the 3 steps mentioned above
In principal same trick will solve.
In my case โLINKTOROW(maxrow(โyourtargettablenameโ,โ_RowNumber"), โformviewnameofthetargettableโ)" is openning a white screen
Please post a screenshot of Expression Assistant showing the complete expression.
The expression looks good.
Please post a screenshot of the configuration for the formvieworders view.
You can also just create 1 action:
APP Go to another view in this app.
For a record of: โThe original tableโ
LINKTOFORM(โTarget formโ,
โOriginal row1โ, โTarget row1โ,
โOriginal row2โ, โTarget row2โ,
โOriginal row3โ, โTarget row3โ)
But this way you end up in i form with what ever new data youโd like, and would have to save it before changes take place.
Hey Kristofer, Yes! Thatโs the way to do it, many thanks.
Note to developers: maybe this link should be included as the โApp linkโ in the Behaviour section of the
form description to give a hint. The current suggestion seems not as helpful.
Regards, Tim.
Found this thread as I have the same requirement.
I agree that this would be easier to be an available action in the behavior page.
โOpen a form to add a new row to another tableโ
Submited this as a feature request
User | Count |
---|---|
42 | |
28 | |
25 | |
22 | |
13 |