I need to save the logs with the detailed usage of the application, how can I do this? And how can I create an advanced search form on a table? Thanks
We save logs by adding them to a glide big table.
Depending on the importance of the log.
Either we have a table for logs
Or we have a duplicate glide big table of the original glide table which saves every column value everytime a user updates a row… (in order to save all data being changed… and also allow for undo or backing up to the old data)
Advanced Search is quite simple… there are loads of posts in this community explaining them.
An easy way is to create a table with 1 row and user specific columns for the search filters. Then query the original table with the inputs of the user to bring back a set of results matching the search.
Thank you very much for your answer, about the logs, I want to save the searches made by each user and their activity, the tables are only for consultation, they are not modified by the user
So if you create a custom search this is very possible.
Depending on several factors there are multiple ways to save this. It is hard for me to answer without knowing what the app use case is. What are examples of search terms… what data you want to save with the seach & what you mean by their activity? (is it when they view the detail screen of a search result)
I have a table with a list of applications, which have columns with the characteristics of each app (usability, accessibility, performance, security, compatibility and licensing). Then, I want the user to be able to search for applications for example: applications that have a free license, or that use login with email, or that are offline… And I want the searches to be registered, to know which are the most searched characteristics.
Yes there are several ways to do this.
You can set up a table for search (1 row) user specific columns with choice components pointing to them. Then a button to make the search (you need a trigger to mark a new search and save its data)
If you want to save the user data making the search you can either save the data in temp glide table (1 new row for every search) if you can afford to useup some rows to make your study.
Otherwise you can save it all into 1 text field or JSON object in the user profile row.
You could go as far as incrementing a number in a categories table to mark a category being searched but that won’t mark the user searching it.
Get in touch if you need me to demo any of this.
Ok, I have created a new table with 1 row and search options (as columns) and I have created the form (layout) with these fields, but now I don’t know how to configure the ‘search’ button to show the result table with the data filtered by the search form. Thanks