{"uniqueId":"6368b619cc44c","metaTitle":"Manage Data Storage and Database Operations with Powform","metaDescription":"Discover how Powform simplifies data storage and database operations. Securely collect, manage, and organize your form data with full control.","pageTitle":"Database Operations","jsonFeedLink":"https:\/\/support.powform.com\/wp-json\/support\/api\/v1\/article\/?postType=features&subcategory=data-storage&name=database-operations","breadcrumbs":[{"text":"Features","path":"\/features\/"},{"text":"Data Storage","path":""},{"text":"Database Operations","path":"\/features\/data-storage\/database-operations"}],"excerpt":"Expect a lot of data to be collected after sending your published web app\u2019s link to your clients.\r\n\r\nPowform brings functionality that allows you to easily find any information you need in the Database feature. You\u2019ll also be able to organise submissions for better visualisation.\r\n\r\nKeep reading to know more!","content":"<p><span style=\"font-weight: 400;\">Expecting a lot of data to be collected after sending your published web app\u2019s link to your clients?<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Powform brings searching and sorting functionality that allows you to easily find any information you need in the Database feature. You\u2019ll also be able to organise submissions for better visualisation.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Keep reading to know more!<\/span><\/p>\n<h2><b>Columns<\/b><\/h2>\n<p><img class=\"size-full wp-image-795 aligncenter\" src=\"https:\/\/support.powform.com\/app\/uploads\/2022\/11\/columns.gif\" alt=\"\" width=\"684\" height=\"472\" \/><\/p>\n<p><span style=\"font-weight: 400;\">By clicking \u201cColumns\u201d, you can select which columns you want to hide or show.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">A prompt will appear and you can search for the type of information you can see. Or you can select what to hide or show from a list:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Checkbox selection: this checkbox allows you to select each submission individually;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">ID: hidden by default, it\u2019s a code for each submission. This is useful if you need to identify one specific submission;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Components: you can select each one of your web app\u2019s components, such as Text, Email, Number, etc.;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Actions: include actions such as Edit, Send SMS, and Download File(s).<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">It\u2019s also possible to just hide or show all of the information.<\/span><\/p>\n<p><img class=\"size-full wp-image-797 aligncenter\" src=\"https:\/\/support.powform.com\/app\/uploads\/2022\/11\/hide.gif\" alt=\"\" width=\"361\" height=\"275\" \/><\/p>\n<p><span style=\"font-weight: 400;\">By clicking the 3 dots near each component, hide each component individually or click \u201cShow columns\u201d to bring up the same prompt as before.<\/span><\/p>\n<h2><b>Sort by ASC or DESC<\/b><\/h2>\n<p><img class=\"size-full wp-image-801 aligncenter\" src=\"https:\/\/support.powform.com\/app\/uploads\/2022\/11\/sort.gif\" alt=\"\" width=\"459\" height=\"230\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Click the arrow near each component or the three dots right next to each component and select:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Sort by ASC (Ascending) or Arrow Up: bring newer submissions to the top of the list;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Sort by DSC (Descending) or Arrow Down: bring older submissions to the top of the list.<\/span><\/li>\n<\/ul>\n<h2><b>Filter<\/b><\/h2>\n<p><img class=\"size-full wp-image-796 aligncenter\" src=\"https:\/\/support.powform.com\/app\/uploads\/2022\/11\/filter.gif\" alt=\"\" width=\"519\" height=\"422\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Here you can filter submissions by certain words, number, date, time, and more.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Just as shown above, you select the Column that contains the information you need, and the Operator, which will be one of the following rules:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Contains;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Equals;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Starts with;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ends with;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Is empty;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Is not empty.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Finally, you type in Value which will be associated with the Operator.<\/span><\/p>\n<p><img class=\"size-full wp-image-798 aligncenter\" src=\"https:\/\/support.powform.com\/app\/uploads\/2022\/11\/operator.png\" alt=\"\" width=\"313\" height=\"232\" \/><\/p>\n<p><span style=\"font-weight: 400;\">It\u2019s important to know the Operators change for the Number Component. Their meaning are:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">=: equal than;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">!=: not equal than;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">&gt;: bigger than;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">&gt;=: bigger or equal than;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">&lt;: smaller than;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">&lt;: smaller or equal than;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">is empty: if no number was provided by your respondents;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">is not empty: if any number was provided by your respondents;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">is any of: is equal to a specific value you type.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">If needed, create more filters by clicking Add Filter, which can be used to filter even further your submissions.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Select \u201cAnd\u201d to make multiple filters be applied at the same time, or \u201cOr\u201d and any filter will take effect.<\/span><\/p>\n<p><img class=\"size-full wp-image-794 aligncenter\" src=\"https:\/\/support.powform.com\/app\/uploads\/2022\/11\/and-or.gif\" alt=\"\" width=\"512\" height=\"193\" \/><\/p>\n<h2><b>Pins<\/b><\/h2>\n<p><img class=\"size-full wp-image-799 aligncenter\" src=\"https:\/\/support.powform.com\/app\/uploads\/2022\/11\/pin-unpin.gif\" alt=\"\" width=\"514\" height=\"421\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Just like shown above, click the 3 dots and pin a component to the left or to the right. Undo this sorting by clicking the \u201cUnpin\u201d button.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">This option is useful to highlight one or more relevant columns.<\/span><\/p>\n<h3><b>Search<\/b><\/h3>\n<p><img class=\"size-full wp-image-800 aligncenter\" src=\"https:\/\/support.powform.com\/app\/uploads\/2022\/11\/search.gif\" alt=\"\" width=\"677\" height=\"243\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Finally, you can look for very specific information by typing it in the Search bar.<\/span><\/p>\n<p><b>Go to Database and try sorting submissions by yourself!<\/b><\/p>\n<p>&nbsp;<\/p>\n","images":[],"category":{"id":"174","title":"Data Storage","description":"","metaTitle":null,"metaDescription":null,"term":"data-storage","count":3,"path":"","updated":1752909654,"status":"publish","order":"6"},"tags":[],"industries":[],"hitCounter":2527,"path":"\/features\/data-storage\/database-operations","canonicalUrl":"\/features\/data-storage\/database-operations","name":"database-operations","relatedArticles":[]}