Is Zoho Creator hard to do problems a little outside the box?

Is Zoho Creator hard to do problems a little outside the box?

I haven't programmed in a good long while and on my second week of the free trial, so maybe this is me and being a noob to this system... but I'm finding the documentation a little light (did all the videos, ebooks, and tutorials) and so have to do a lot of experimenting to see how it works.

Right now I got a team roster based on one form, and in another form I multiselect teammembers for a single game match.  I'm trying something as simple as getting the inverse of my selection (gettting a list of all those I didn't select in multiselect) and finding it hard to do.  Maybe I'm just being stupid.  Also stuff like basic loops are missing although the feature was being worked on years ago going by old posts.

But is my impression that ZC works extremely well for the field it's designed for (business stuff) but once out of that zone or designer expectations it gets unwieldy really fast for stuff that deports out of the norm because it seems like an incomplete language and (too) concise documentation.

Maybe I'll sleep on it and get an a-ha moment!  But the past day I was trying to make stats based on game data form and just hitting my head on various aspects.  Some aspects are very nice but I'm thinking making those easy also imposed limits in design.