Hey, I was wondering does someone know a way to get the “.filterset” code to not just check 1 column but all of the column in mycollection, for the .textvalue so that when a user want to look for a specific word all they have to do is use the searchbox…
Then the searchbox will check all of the columns and find the words that contains the input .textvalue
Sorry but the code is searching the keyword in both columns. I’m trying to do something like if the code can’t find the keyword in column 1 then it will search in column 2 for the keyword. Does this make sense?
You can use query to check whether the keyword exists in a column, if it doesn’t you can check another column and so on…
After that, you can use the setFilter.
Check out the following article:
Hi,
Since this is a bit complex, you can use code to update your fields, instead of connecting it.
I assume each applicationStatus, Revisor, fullName, email have text boxes.
Try doing something like that at the line that gets the result:
if (result.items.length > 0) {
//items found, do something here
const firstItem = result.items[0];
$w('#applicationStatusText').text = firstItem.applicationStatus;
$w('#RevisorText').text = firstItem.Revisor;
//More text updates here...
}