Stari

[TomP1]

Can I make a datapage to compare two items from a table?

I have a table with a reference number of products,  the remaining columns are physical measurements of products.

I would like to make a datapage in which you could select product 1, then product 2 and get a comparison of the product dimensions.

I am also kind of a noob, assistance would be helpful.

 

[telly]

Hi @TomP1,

We had a similar workflow what I did was, 

1. Create a tabular report 
2. On the search form add criteria
    - First if for the product 1
    - Second for the product 2
3. Add virtual field and set to checkbox
4. Make a rule where if checkbox is not check hide criteria 2

Basically it will show the two records, then you may create another DataPage and add formula to get the difference between the dimensions of the product.



 

[telly]

 Hi @TomP1,

I just want to add helpful links that you may check:

- 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/datapages/forms/conditional-forms/
- https://howto.caspio.com/datapages/reports/search-and-filter-comparison-types/

[futurist]

hi @TomP1,

you could have a Report DataPage with a search form that allows you to select multiple options, and in there you can select the products you want to compare, and have them show up in the Report DataPage with their respective dimensions and other info.

On Configure Search Fields, set your Product field to a Listbox, change the source to Lookup table or view, then choose your data source to where you want to pull your products from. On the Advanced tab, enable "Allow multiselection"

 

 

 

The DataPage would look something like this:

the Search form:

4

 

the Results Page:

 

Hope this helps!