Tap Forms Database Pro for Mac, iPhone, iPad and Apple Watch › Forums › Using Tap Forms 5 › Is it possible to generate table views which excludes data?
Tagged: tables
- This topic has 6 replies, 2 voices, and was last updated 8 years, 1 month ago by
Brendan.
-
AuthorPosts
-
September 28, 2017 at 5:13 PM #24954
julienParticipantIs it possible to generate table views which exclude some data based on a condition?
For example generate table with all records except those for which column y has value x.September 28, 2017 at 6:47 PM #24956
BrendanKeymasterHi Julien,
You can create Saved Searches for filtering all of the records in a particular form. You do that by clicking on the funnel button just to the left of the main Search field. Then specify your fields and your conditions to add rules to your search. Click the Save button when you’ve finished creating all your search rules.
See this page in the docs:
September 29, 2017 at 12:32 AM #24959
julienParticipantThat is a good feature thanks.
Is it possible to do a ‘Link to Search’ instead of a ‘Link to Form’?
That way generate a table based on this filtered result instead of the whole set of results?September 29, 2017 at 1:52 AM #24960
julienParticipantalso: is it possible to sort the results of a search?
September 29, 2017 at 1:56 AM #24961
julienParticipantOK I found how to sort the results of a search but cannot duplicate a form unless I create one from scratch
September 29, 2017 at 2:01 AM #24962
julienParticipantwell actually the problem is not that we cannot duplicate forms, it is that the search sort display is dependent on the default layout. therefore it is not possible to have two searches display the results with a different field order because the field order is defined in the default layout
September 29, 2017 at 9:58 AM #24972
BrendanKeymasterActually it is if you use the multi-column list view. Because you can arrange the field order using the Select Fields popover view. You can drag fields up and down there to change the order. It’s a different order depending on whether or not the form itself or any of your searches are selected when you do that. So each search can be displayed differently and sorted differently in the multi-column list view.
-
AuthorPosts
You must be logged in to reply to this topic.