How to change table data with select box

Wappler General How To
#1

Hi everyone, long time follower with such a great members and first time posting and need help.
I am trying to have form or data that is going to change the data in table by filtering data from select box from static combo box. for example show only data for last 90days or 180days.

wappler-select-form
wappler-select-form1341Ă—700 104 KB

wappler-database_query
wappler-database_query1933Ă—1080 177 KB

wappler-database_query2
wappler-database_query21764Ă—882 131 KB

Thank you in advance.

#2

wappler-database_query-now
wappler-database_query-now1044Ă—983 66.3 KB

I tested and enter manually the -90 {{NOW.dateAdd(“days”, -90)}} and it works.

But How I am going to pass the Select box value into function. I know this might be basic question for most of you guys. I am in learning process.

Thanks

#3

Use the $_POSTed value as in

image
image1046Ă—175 19.5 KB

The query will be

image
image754Ă—125 3.9 KB

#4

Hi Ben,

I changed the form to post.
I added the POST variable
I changed the table condition

No result is coming out

I am sure I am missing something.

wappler-select-form-post
wappler-select-form-post1916Ă—1015 228 KB

wappler-database_query-post-now
wappler-database_query-post-now1913Ă—1045 178 KB

Thank you,

#5

If this is working then you will want to replace the 90 with the value from your form.

Something similar to this.


{{NOW.dateAdd(“days”, -$_POST.elapsed)}}
#6

Hi,
I tried that. But it didn’t work.

After the page loads. the default select box shows 90 which is the first item in selectbox, and it suppose and then we should be able to change it to 120 or any other and it should change query. But nothing happened.

I am not sure what I am missing here.

Thank you

#7

I believe you want to check this tutorial:

It works the same for select inputs i.e. you need a GET variable and use it in the query builder with the condition you need :slight_smile:
POST variables are only used when you are dealing with submitting forms.

1 Like
#8

Hi Teodor,

THANK YOU SO MUCH. it worked out perfect in 5 min.

Now I have to challenge on my next challenge as far as showing how many items per page.

#9

In order to set a number shown per page, you need to use a Paged Query. You can do it the same way, using a GET variable.