I figured it out! I believe I am now worthy of being called an Adalo Expert!
I ditched the idea of using Adalo’s API to get the messages, was way too complicated to try to pull and filter the values.
So here’s how I did it.
2 collections: Conversations and Messages
I added a number parameter to the “Conversations” collection called “Offset Count”
and added a number parameter “Message #” to the message collection.
When a new message is sent, the new message created action adds the current conversation > message # as “Current conversation > Message # > Maximum + 1” and an additional action to update the current conversation to have the Maximum + 1 for the offset count.
Then, I added 3 input fields to the Messages screen.
Default value for input 1: Current conversation > Offset Count
Default value for input 2: Custom formula > (Input 1) -7
Default value for input 3: Custom formula > (Input 2) -7
Then I added the Messages list with and filtered Current Conversation > Messages to only get the messages of the current conversation.
Another filter that says “Message #” is between Input 2 (lower number) and Input 1 (maximum message # +1)
Added a button on the top of the list that says “Previous Messages”. When clicked, change the value of Input 2 to the value of Input 3 to subtract 7 from the current lower number offset. When clicked, the Input 2 drops by 7 and so does Input 3.
Hide all 3 input fields with a rectangle over them.