Button to run a query

Topic: Button to run a query (Read 1957 times) previous topic - next topic

Button to run a query

August 21, 2019, 09:59:35 AM

Hi,
how can i use this button to run a query?

i need clone all data from this id to other table many times i need..

Re: Button to run a query

Reply #1 – August 21, 2019, 10:52:45 AM

@lp_felix‍ was that button added through Page Design, Page Filter Component?

Re: Button to run a query

Reply #2 – August 21, 2019, 11:24:21 AM

yes

Re: Button to run a query

Reply #3 – August 21, 2019, 11:39:43 AM

@lp_felix‍ find attachment below for refference.

1. Select the page you want that button to redirect the user to.
2. Select the data you want to pass to the page being redirected to. e.g $data['id'], USER_ID, etc.

Re: Button to run a query

Reply #4 – August 21, 2019, 12:44:28 PM

If you need to insert a new record based on the values of the current page, You can add Subpage and Bind Values of the subpage to the new Add Page.
I shared a video on how you can achieve this.

Clone View Page to a new page

Re: Button to run a query

Reply #5 – August 21, 2019, 01:19:22 PM

Excellent, thank you
You should make more videos like that, it's more easy to understand.

Thanks for your help

Re: Button to run a query

Reply #6 – October 26, 2019, 02:41:05 AM

I've tried to make this work in Product page (example) to create a new Product and works fine. But if I try to use it in Product page to create (for instance) a new order based on that product (ie filling the product details in order page) it's not working. Returns Undefined index: notices in some of the bound fields. But others work fine. And all those fields are basically the same type INT(11)

Re: Button to run a query

Reply #7 – December 27, 2020, 06:54:15 PM

Quote from: willvin – August 21, 2019, 11:39:43 AM

@lp_felix‍ find attachment below for refference.

1. Select the page you want that button to redirect the user to.
2. Select the data you want to pass to the page being redirected to. e.g $data['id'], USER_ID, etc.

@willvin Has Record_ID been removed as a possible setting?

Re: Button to run a query

Reply #8 – December 28, 2020, 01:30:11 AM

@Erwin‍ please what do you mean by Record_ID?

Re: Button to run a query

Reply #9 – December 28, 2020, 09:35:43 AM

@willvin In your screenshot the second component property. It’s not on my PHPrad.

Re: Button to run a query

Reply #10 – December 28, 2020, 10:36:13 AM

@Erwin‍ No, it has not been removed. Depending on the page you place the button you get a set of available configurations for it. if you want the RecordID configuration, please place the button on a view page, thanks.

Re: Button to run a query

Reply #11 – December 28, 2020, 10:40:59 AM

@willvin Ahaa, yes found it! I placed it on a View page, but only when it LINKS to a view page, then it shows :thumbs_up: