cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Write a formula using selected rows of a grid

Participant

Write a formula using selected rows of a grid

Hello,

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 

Tags (3)
4 REPLIES 4

Re: Write a formula using selected rows of a grid

Hi @AN_9685270.

 

We're not clear on your needs.  Please provide more detail around the use case.  What specifically are you trying to do?

 

Regards.

 

--Sharon

Re: Write a formula using selected rows of a grid

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.

 

For example: 

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

Re: Write a formula using selected rows of a grid

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.

  • Create a custom service to use/write formulae based on your input.
  • Mashup : 
    • Allow selection in grid
    • The required input for the custom service can be bound from the selected rows of the service from which grid data is populated.
    • To trigger the custom service , you can make use of SelectedRowChanged event of the service that populates the grid data.

Hope it Helps!!!

Re: Write a formula using selected rows of a grid

Hi @AN_9685270.

 

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.

 

Regards.

 

--Sharon

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!