I Want to write a formula or an expression using selected rows of a grid, if you have any idea how to do it i would be grateful.
I will attach what I want to do in the mashup
Thanks in advance
We're not clear on your needs. Please provide more detail around the use case. What specifically are you trying to do?
thank you @slangley for your reply,
what i want is to write an expression or a forumula( like in excel ).
So my idea is, i want to write the id of (selected row from the grid) in a text field and do some calculations.
if i have in my grid :
Id :A ,thing1,( with some properties: like propValue
Id: B ,thing2,
Id: C, thing3
and I want to make a forumula between those things
formula = A +C/B
(so the meaning behing is
formula = Things["thing1"].propValue +Things["thing3"].propValue /Things["thing2"].propValue
then this formula is applied on a propValue of our new (thing which is equivalent to an energy meter)
I Wish i was clear and thank you in advance
Hi @AN_9685270 ,
If you have predefined list of formulas and just want to take input from a grid; Then you can follow below procedure.
Hope it Helps!!!
We still don't have an understanding of your use case. If you can walk through a couple of user scenarios of what is being clicked and what should happen, we might be able to recommend a solution.