Change titles to columns according to search filters

[MaraMara]

I have a datapage in which I show Invoices, credit / debit notes and payments.  
The search field that represents those is a single field with 4 different criterias, each one is a checkbox.

Here is what i would like to achieve:

I would very much appreciate if someone can provide a code that I could try out.

Thanks in advance.

[cheonsa]

Hi @MaraMara,

To achieve this workflow you can create three separate DataPages for different Column Headers. Then, you can also create a Submission Form that will serves as your Search Form. On your Submission Form, you can add a Calculated Value that will determine what DataPage URL should your Submission/Search from will redirect after hitting the button. 

 

You may refer to these articles: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-separate-search-page-and-results-page-into-two-different-webpages/

https://howto.caspio.com/function-reference/

 

Hope this helps.

[MaraMara]

Thank you very much  @LittleMsGinger, Thank you very much.

 

I will try this once I upgrade to a new plan, I can't spare many datapages at the moment, but it looks like what I need.