Solved: Comparison of two different materials and there pr... - Page 2

Jitse_B · 09-13-2021 01:07 AM

Hello Everybody,

I have an question about the possibility to create a table to compare two materials. The idea is to show two materials and there proportional values next to each other, Is this already possible within Appsheet?

Would like to hear your ideas on this problem i am facing.

With kind regards,

Jitse

Aurelien

Hi @Jitse_B

Welcome to the community !

Yes you can, there are various ways to do so.

The simplest:
You may want to create a table with 3 columns,

key_column, Type Text, value “k000” (or whatever you want, it doesn’t matter if you stick to only one comparison)
“material1”, type Ref, source table name: your material table.
“material2”, type Ref, source table name: your material table.

Then use as many virtual columns as you need to compare materials.
Then create a UX View for this table (UX/Views/New View).

For example:
Let’s say you have item1 and item2 with properties size and weight.

Then you can have a virtual column “compareSize”, type Text, with app formula expression:

IF(
  [item1].[size]<>[item2].[size],
  "Difference : " & [item1].[size]-[item2].[size],
  "Same size"
)

Or:
virtual column “size ratio”, type Percent, with app formula expression:
[item1].[size]/[item2].[size]

For reference (please read it):

View solution in original post

Comparison of two different materials and there properties