I mostly figured out the method to populate a select list from the database, except for one issue.
My test consists of a test page based on the Country table that Mark uses in the tutorials. My test page has only 2 select boxes
The Page Entry looks like
The 1st select options…
The 2nd select options
Once the user picks a Continent in the first select box then the 2nd select should only show the Countries in the Continent of the first select.
As you can see, I am not getting a filtered list of Countries for the selected Continent. Considering that the User could pick any Continent, means that setting a filter for Countries in the ‘On Page Enter’ would not work.
How can I get this to work?
I now tried something else. I moved the jigsaws for selCountry from ‘On Page Enter’ to ‘On Change Event’ of selContinent. There seems only one problem. The where clause jigsaw will not attach. Am I doing this correctly?
Yeah, you are on the right way.
But, you use wrong block to compose a where clause string. The block on your screenshot is an expression block that’s why you can not connect it to the where clause input.
Hi Vlad
Scrolling is needed, I should be able to scroll all the way to Zambia and Zimbabwe, which are African countries.
In your monosnap you manage to scroll without a scrollbar. I went back to my select box, but it will not scroll. In your monosnap your pointer changed to a circle, mine stays as a hand.
I am not sure what to make of that.
But I presume that your answer means there is no scroll bar, what can I do??? Users are used to scroll bars which why backendless uses it for the ‘Add Block’ drop down in the Logic design screen.
No, I meant that there is should be a scroll if there is not enough place to display all the items in the list.
On my screen there is no physical scrollbar because this is specific of MacOS, for instance on the same screen you share I do not have scrollbar either, but it can be scrolled
Vlad
I see, I am on windows 10. There is not enough space for all the countries, so there should be a scroll? Not sure if you mean there should be an actual scroll bar or some other scroll mechanism, but either way, there seems to be a problem. Are you able to replicate this test on Windows 10?
Bruce X
Hi Vlad
You are going over and above (which is good).
The answer will probably benefit all your user base not just me, I look forward to our findings.
BruceX
The list displays all the 10 items items actually, 10 - because you request only 10 records (by default) from the server, try to increase the value to 100 in your Codeless logic
No, maximum pageSize is 100.
In order to get more you need to build logic for loading all of them in a loop and in each iteration load up to 100 objects.
Hi @Marina.Kan, it’s probably because of the age of the posts but both of these Monosnap recordings seem like they’re no longer available. Any chance you can reshare or point me toward another video that covers this?
I’m having trouble extending these examples to populate a select field using the distinct values from a relation field in a table.
