8 results found
136 votesplanned · AdminAdmin (Product Manager, Caspio) responded
Thank you for this idea. We are looking into adding this feature in future product updates.
An error occurred while saving the comment
An error occurred while saving the commentWalt commented
Joining 2 tables in Views needs a check box for "distinct" which would remove all duplicate records. This would allow the views to be easily used in tabular reports.
"Distinct" is an important keyword in the underlying SQL Select command that should be easily added by Caspio. I have never needed an SQL Select without the "distinct" keyword in my programming experience.
Views with no duplicate records could allow productive views created with other views as the data source. This should allow data to be filtered and messaged in almost any way which may reduce the need for all of the complex options inside of the Datapage builders.
Create a new datapage for logon forms. A user needs to be able to enter their ID and password, then Caspio sends them to a URL based on data1 vote
Caspio views needs a check box for "distinct", which is the key word in SQL Select that eliminates duplicate records created when 2 tables are joined with inner and outer joins. This is essential.
it would be extremely helpful to be able to use authentification fields as criteria in the View builder. A good view builder could make a great data filter. Views built with other views as the source could do almost anything and eliminate some of the confusion created by too many options and complexity in the Datapage builders.