Search the Community
Showing results for tags 'filter'.
I want to be able to search a table according to the criteria of a “From Time” (greater than equal to) and a “To Time” (less than equal to), the problem is that there is no option for Time, only Date AND Time. The result should be ALL records from all dates between the specified time. Eg. Created on (Timestamp) From 06h00 To 08h00 à display records created between 06h00 and 08hoo across all of table history. Currently I am using a submission form with a virtual field to pass the parameter to the search form. I have one Timestamp field and three Date/Time fields I wish to search. Is t
Say I have 3 tables; Users, accounts, assets. A user is completely unique and has a one to many relationship with Accounts. Accounts has a one to many relationship with Assets. I want to create a form for adding new assets. The person needs to select which account the asset belongs to. Given multiple users, each with numerous accounts - simply having a full drop down list of all the possible accounts is not feasible. How do I create a form with a "user" dropdown where the "accounts" dropdown only shows values linked to the selected "user"? Thus filtering the p