Haha no worries!
Instead of typing it, can you try selecting the “sort” function here:
yeah, i know it, i tryed to do like your example, but the result didnot change(
there may be a problem in my data or I am adding information to the table incorrectly.
Ok, it seems you don’t have a column with “Name” in your table.
Can you try adding “Last Name” as an argument instead of “Name”?
Now varriable is working, but the data in the table doesnot refresh at all.
It doesnot refresh when I’m trying to do this step (1.a.) As i understand, it should be refreshed in real time, but the data disappears(
P.s. sorry for my language
Would you mind sharing a link to the editor so we can take a hands on look for you?
It might be easier than asking you for screenshots
Don’t hesitate to DM the link if you don’t want to share your project in the forum.
This is my projekt
Just had a look at your project and created a Google Sheet test page (a duplicate of your Google Sheet page) to try out the formula.
It’s working fine now. Here the formula you can copy in your Google Sheet page to make it work:
Feel free to delete the test page! I just left it there so you can see it’s working and because I didn’t want to mess with your original page
A couple of things you might find helpful:
In the case of this sort formula, you can see:
Does it make more sense now?
But what if i wanna add sort to other columns?
I tried to do the same things (add workflow to other icon and complement the formula), but nothing happens with new sort and also the old one was broken.
Ah ok, got it!
In this case, you’ll need 2 variables:
In your project, I’ve named these variables:
Both are string variables that are empty by default.
Since you have 2 variables you want to change when the user clicks on each sort icon, you’ll need 2 actions in the workflows that trigger when the user clicks on a sort icon:
the first action will change the filterName variable to match the field in your database that you want to filter
the second action will change the sortOrder variable each time the user clicks
In the screenshots, we’ve done this for the sort icon related to the “First Name” field. You would need to repeat the same action on each sort icon. The only thing that would change is the text you put in the first action.
Finally, you would change the formula on the Collection List:
If you’d like to check it out, I’ve set it up in the test page of your project
Oh my God, thx so much. It is exactly what i’m looking for.
I’m trying to understand how to filter in real time? I know that it can be from Collections…(img.)
But what if i wanna do the Filter in real time?
For example - I wanna to filter my data by name or company name.
P.s. it is my “project”
The easiest way to do that is with a dropdown select menu element. We’ve taken it out of the toolkit for now because it had performance issues but it should be fixed and live again in the next few days.
Would it be ok for you if I sent you a tutorial towards the end of this week or early next week?
It sounds perfect) will there be a detailed guide ?
Yep, I think I’ll create a dedicated tutorial/detailed guide like this one so everyone can follow along from start to finish
I tried “Desc”, “desc”, “descending” etc with and without quotes, but not seeing a change. It does work if I select the desc option from the dropdown. Thank you
Hi @foliodc you can try DESC, it should work
That worked thanks! I’m a little confused by the sort direction. Alphabetical works A to Z for ascending, but numbers seem to be backwards. Ex, when I set to “ascending” it starts with the higher number (timestamp in the future) and goes down (timestamp in past). And when “descending” it shows the opposite (older/lower to newer/future/higher). Not so bad bc I can bind to get the right answer, but my site will be backwards if this changes in the future, maybe I’m misunderstanding something. Thanks!
@foliodc I’ll check that, because it also seemed to me that our Asc/Desc was inverted on some data types.
I didn’t remember which ones when building, thank you for reminding me
I’ll check and add the bug fix in the roadmap if needed.
EDIT: indeed it’s inverted on numbers, I added it as a bug report for the tech team