Custom Dropdown Choices

[Casey]

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 :)

[douvega]

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.

Regards.

[Franchiser]

@Casey

You don't need to use API or javascript, cascading element can do the trick.  Try to elaborate the part in where you stumble in cascading and  I might provide help.

-Franchiser-

 

 

 

[Casey]

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.