Jump to content
  • 0

Variable list data types


Glenn
 Share

Question

 

I have a form for creating a new  'appointement' for a client which needs to have a field with a 'multiple select listbox'

This documentation provided me to the way to do it

https://howto.caspio.com/tables-and-views/data-types/list/

However my problem is that it forces me to pre-define the values to be shown in my table, as described in

5. On the right pane, under the Options section, you must provide the Values available for the data type. Up to 1000 values are supported. You can enter the values one by one, paste a list into this area, or import from one of your existing tables by clicking the import icon  import_icon.

But my values can be dynamic: for appointments for client X they should be A, B, C for client Y they should be D, E, F,....

How can this be done in Caspio

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Hello @Glenn,

To add to a previous comment.

If you use a Listbox, you can configure a DataPage to limit lookup values in the Listbox field based on a user or role. So for client X, options can be A, B, C and different for client Y. 

You may check the following article to find out more: Filter Lookup Dropdown or Listbox Based on User or Role

Also, you can Dynamically Add Options to Dropdowns or Listboxes if it is the case.

Hope this helps!

Link to comment
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
Answer this question...

×   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...
 Share

×
×
  • Create New...