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
Solved! Go to Solution.
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,
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):
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,
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):
Hello Aurelien,
Thank you for helping me out. With your information i found the way to display the information.
This looks as follows:
If there are any tips, i would love to hear them!
With kind regards,
Jitse
Hello @Aurelien,
Trying to upload the formula in the last message, but that failed. This is due to the fact that i am a beginning user. Maybe there are tips on the formula is used. So in this message it is included.
@Jitse_B
Can you copy-paste this expression and wrap it using the editor here ?
CONCATENATE(CONCATENATE(LOOKUP([Search Material_1], "Mechanical properties", "Product", "Tensile strength (Gen) [MPA]"), " ", "[MPa]"), " - ",CONCATENATE(LOOKUP([Search Material_2], "Mechanical properties", "Product", "Tensile strength (Gen) [MPA]"), " ", "[MPa]"))
Thanks for copy-pasting.
Tips : you may want to indent your expression, in order to gain some readability and comprehension.
This expression is too complex with the embedded concatenate.
CONCATENATE(
CONCATENATE(
LOOKUP([Search Material_1],
"Mechanical properties",
"Product",
"Tensile strength (Gen) [MPA]"),
" ",
"[MPa]"
),
" - ",
CONCATENATE(
LOOKUP([Search Material_2],
"Mechanical properties",
"Product",
"Tensile strength (Gen) [MPA]"),
" ",
"[MPa]")
)
You may prefer this instead:
CONCATENATE(
LOOKUP([Search Material_1],
"Mechanical properties",
"Product",
"Tensile strength (Gen) [MPA]"),
" ",
"[MPa]",
" - ",
LOOKUP([Search Material_2],
"Mechanical properties",
"Product",
"Tensile strength (Gen) [MPA]"),
" ",
"[MPa]"
)
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |