Importing Participant Options into Events in NXT

Emily Weiss · March 25

Does anyone have a workaround for adding Participant Options to events in webview in bulk?

If I'm understanding correctly, Participant Options is a webview only field that doesn't map to Participant Attributes in database view. This means that it can't be imported, right? I'm hoping there is some way I can avoid adding all my participant options manually.

Alex Wong · March 26

the only "bulk" option for Participant Options would be through SKY API

If you never used Power Automate and SKY API before, there's a learning curve, but for what you want to do, it's not too difficult and would open a huge door. If you want to get started, you can check this link out first.

Jack Briggs · March 26

If I've needed the participant options saved, then I export direct from the participants on the event and then import into RE7 using our usual processes. (I've also made some strong arguments around 'do we need to retain this information beyond the event, because you can do everything straight from NXT… ?' :D)

Elaine Tucker · March 26

Jack's recommendation should work. My thoughts are this may be part of the major change in using webview transition - forcing us to embrace the webview.

Jeannie Goings · March 27

@Jack Briggs I can't even see that the participant options are exportable via query. I added this participant option to an event that I added to train new staff. I gave it this terrible name so that I would recognize it when it was exported via query. @Emily Weiss you are asking specifically about the participant options; these options are not visible in dbv when recorded in wv, correct?

Emily Weiss · March 27

Hi @Jeannie Goings yes that's correct! i have added participant options but they aren't visible in dbv

I'm asking because I have an event RSVP tracker that is currently being kept in a spreadsheet, but I need to transfer it to NXT and resume tracking responses there. It will be cumbersome to add all the participant options by hand since a ton of info already exists in the spreadsheet :(

Jeannie Goings · March 27

Emily, @Alex Wong is correct. Post event participant option is available through SKY API.

Jack Briggs · March 30

@Jeannie Goings Apologies for being unclear - I go into the event directly from NXT Event Overview, then select 'work with participants', adding whatever columns I require, and export the spreadsheet from there. Basically, you don't use Query at all for my 'method'.

Importing Participant Options into Events in NXT

Answers

Categories