Jump to content

Recommended Posts

Hello, I am trying to make a fairly simple database app. It actually started as a simple Google sheet. There is just one trick to it - there is one field for which I need to allow multiple values, but I want each of those values to be validated from a pre-approved list of values. It seems this is not possible in a Google sheet, so I figured I would try Caspio to do it. I'm happy to have the list of values be it's own table and even to have the selection of those values be on a separate form from the creation/editing of the primary record. But I can't really figure out how to do this. Does anyone know of a tutorial that explains this?

Thanks 

Share this post


Link to post
Share on other sites

Thanks for replying MayMusic.

Yes we can do multiselect of a Listbox.  Our issue is with Cascading Listboxes.  We need to first use a listbox (or drop-down) to select one variable then based on that present a list of options and have the user multiiselect from that list i.e in a Cascading Listbox and then be able to at a later date amend their selection in an Update form.

Be v grateful for any ideas or work around as we are finding its a big limitation with the Caspio Platform.

George

Share this post


Link to post
Share on other sites

We have not as yet been able to fix.  The new facilities just launched with ver 9.6 are almost there for us.  Sadly however we need the ability to be able to select from a table/view.  That feature is not on this release.  We also need to be able to use it in a cascading manner.  So whilst the platform is clearly advancing we don't have a solution - yet. 

Do wish you all the best in your hunt.  If you find a solution please do let me know :-)

George

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...