Jump to content
  • 0

Custom Dropdown Choices



I need a dropdown menu that is basically a lookup field from another table that has a predefined relationship.

However, I need to limit the choices based on other factors.  Specifically, this should be done with record-level security but I'm not using built in record level security because it is too restrictive (I have a user-type that can see all records and the record-level security doesn't support this).  I don't want to make my whole app twice (once for people with normal record-level security and again for people who get to see everything).

So, I've managed to limit all the records that folks get access to on my own, but I'm having trouble with cascading dropdowns on my submission forms.

I'm hoping to make some javascript that loops through the table in question and pulls out all the records the user is allowed to see, but I don't know how to access the other table.  

I am guessing I'm going to have to make an API call here, but I was wondering if there were another way to access records with joins/known relationships from within he datapage builder.

Any ideas are most welcome :)

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Hi @Casey,

You can call fields and data from another tables(s) or view(s) in a Details section of a report datapage through calculated fields: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/, please go to "Subqueries in Calculated Fields" section on that page.

I hope this can help.


Link to comment
Share on other sites

  • 0

Thanks for your replies.  The specific thing I was trying to do was to filter dropdowns by not only the cascading information but also whether or not a checkbox field was checked.  I was able to do this by using a view instead of a table as my dropdown source.  Thanks again.

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.

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.

  • Create New...