Creating a calculated field in RENXT

Kevin Schaeffer
Kevin Schaeffer
Ninth Anniversary Kudos 1 Name Dropper Participant
in SKY Developer General Discussions

Let me preface this by saying I am very new to the developer community, but I'm thinking this is something that should be possible. My organization is looking to create an “engagement score” based on other data in RENXT, and ideally we would like this to be calculated and added to a field within the system so that there is not an export>excel formula>import process needed. Has anyone tried to do something similar or have any ideas? We have access to Power Apps and Sharepoint but haven't really done any app building yet.

Comments

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 bbcon 2025 Attendee Badge

    @Kevin Schaeffer
    All you need is Power Automate license for this.

    First create a Constituent custom field to store this “engagement score”. Then you can have a flow that runs nightly (or weekly, or whatever you think is best schedule) to gather the information needed from the constituents via API, do the calculation in flow, and then create the custom field of engagement score for each constituent.

    The only potential difficulty is to ensure the info you needed for doing the calcuation is availble on SKY API.

Categories