Mapping Category ID on Fusion record update removes other forms on record | Community
Skip to main content
N
NickVa7
Level 9
November 11, 2022
Solved

Mapping Category ID on Fusion record update removes other forms on record

  • November 11, 2022
  • 2 replies
  • 1463 views

Hi WF Community,


I have a Fusion question...

 

I have a module that updates program records.  One of the fields I want updated (Program Status) is a on custom form called Standard Program Information.  If that form doesn't exist, it won't add it and update that field.  For this reason, I have mapped the Category ID field and added a the form ID for the Standard Program Information form.  

The issue I'm finding is that when this update takes place, and the form is added, it deletes any other form on the program record, along with the data contained with the fields on those forms.

 

Is there a way around this?

Thanks,

Nick

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Stacey_Robertson

Rather than use the update module, I would use the Misc Action module.  Record Type would be Program, Action is assignCategories then you can choose the objID as the Program ID you want to update, objCode is PRGM and then categoryID is the custom form ID you want to add.  Then you can run your update to fill in the field.

2 replies

S
Stacey_RobertsonAccepted solution
Level 5
November 11, 2022

Rather than use the update module, I would use the Misc Action module.  Record Type would be Program, Action is assignCategories then you can choose the objID as the Program ID you want to update, objCode is PRGM and then categoryID is the custom form ID you want to add.  Then you can run your update to fill in the field.

N
NickVa7Author
Level 9
November 11, 2022

Thanks, Stacey!  Sorry, I didn't see your reply before posting my update.  

    S
    Stacey_Robertson
    Level 5
    November 11, 2022

    Glad you got it to work!

    N
    NickVa7Author
    Level 9
    November 11, 2022

    I learned that this is the issue and solution for anyone else who runs into this:

     

    The Category ID field is shorthand to "first form in the list of custom forms" - meaning if there IS a custom form, it effectively removes the prior one and replace with the one you specify. 

    If you need to just ADD custom forms, use the module "Misc. Actions" - it has an option to "addCategories" - this will not remove existing forms

      Terms & ConditionsAccessibility statement

      Loading footer...