Sql to display in my project form

Hi @ijtzib,

Thanks for the post.

Could you give us more details on where exactly in your form you want to display the average?

Do you wish to pre-fill a column in a row?

We’ll wait for your response.

HI Kim,

I am calculating a avg with specific formula and would like to display my results for every row in the assessment tab of my project form. How to I go about doing that?

See sql here… https://snipboard.io/5GVntE.jpg

See image of where I would like the results to be displayed a column within the assessment tab.. https://snipboard.io/jXzW0G.jpg

Hi Kim,

For this case, should I create a new field in my table to store the results for the avg? Please advice. Thanks.

Ian

Hi Ian,

You can use functions in Data Table rows using a view. Unfortunately views are not updatable. For data entry you would need to add a kind of dummy field. I haven’t tried this myself, but it should work with a dynamic hyperlink.

Dynamic hyperlinks are explained here:
https://wpdataaccess.com/docs/data-explorer-settings/dynamic-hyperlinks/

Instead of adding a hyperlink you need to perform your calculation using a javascript function which is called from your dynamic hyperlink. You just need to hand over the correct arguments.

Can you give it try?

Best regards,
Peter

Hi Peter,

I realized that I can do this in data table as custom query and by the way I have already run it and it work good there.

Thank you for the assistance Peter.

Regards,

Ian

Hi Ian,

That’s great! Glad you got it working. ??

Feel free to create a new thread if you have new questions.