I watched the video. However, it seems there are many fields to fill manually in the table.
What I want is simply to use two buttons:Previous / Next to display a new content block on the same page. Each block has a position (number) in the “blocks” table.
I tried using an intermediate page with a list that correctly displays the block +1 (filtered with “position” greater than the current block’s position). But the (second) “Next” button on this intermediate page, which redirects back to the initial page (like an updated loop), returns to the initial page with the initial block, not the third one…
I hope I’m being clear. Should I use a temporary variable instead of an intermediate page?
In the table there are 3 fields: (1) ID of the block, (2) next block in a sequence and (3) previous block in a sequence.
If you are absolutely sure that values in the first field will always be sequential, you can omit fields (2) and (3). Keep in mind 3 things though:
field values should be strictly sequential;
you need to understand that if you for some reason decide to input a new block in the middle (e.g. you have 10 entries, and you want a new one between #5 and #6), you will need to update all IDs for records after the new entry;
it could be a good idea to identify 1st and last blocks (maybe with some t/f property).
You do not need to use any intermediate page. You just need to store the current_id in some property of a Logged-In user, and then update it to +1 / -1 with next/prev buttons. So, on the screen you create a list of blocks, filtered by SEQ is equal to Logged-in User → Current Seq (do not use ID property name as it is already used). Make this list autorefreshing. Before going to this screen, set Logged-in User → Current Seq to 1. On the “Next” button add an update action Logged-in User → Current Seq to Logged-in User → Current Seq+1. So, when you press “Next”, current seq is updated to 2, list autorefreshes and display an entry for which SEQ is equal to 2. And so on and so forth.
On the first screen you have a list of all blocks. You can set ID of the block (update Logged-in User → Selected seq) before you have a link action to the another screen. You have the access to current block in this list.
On the “detail” page you will have a list of blocks filtered by Logged-in User → Selected seq. You then can implemebnt prev/next functionality.
Please watch the video and try to replicate it, to learn the approach.
Your workflow can be implemented using the approach from the video and my explanations in the previous message.
Thank you, Victor, for your information.
I’m trying to carefully go through each step based on your explanation.
For now, I haven’t managed to make it work yet.
As for the video, I’m struggling a bit with the English (it goes too fast for me).
My English is far from perfect.