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!!!
I didn't fully understand your use case, but I did come up with something that might help get you started. I have a text box where they type out the formula. They can select a row in the grid and add that row's formulaID value to the formula text box. The calculate button will take the formula and parse it for those formulaIDs and replace them with the value related to the formulaID and then it will eval the formula string and return that value. There were many assumptions that were made, so I would recommend to use this as a starting point for your use case. The entities file is attached to this post.
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.
If the previous response answered your question, please mark it as the Accepted Solution for the benefit of others in the community. If you still have questions, please let us know.
Please advise if one of the previous responses answered your question by marking the appropriate one as the Accepted Solution. If you're still having issues, please provide more details around your use case.