Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Telma Arruda 5 posts 74 karma points
    Sep 11, 2023 @ 11:20
    Telma Arruda
    0

    Move form records to another form

    In my solution, I have two forms with the same structure. I pretend to move all entries from one form (old form) to other (actual form).

    I executed the following queries via SQL to say to those records which have old key (from old form) and change them to new key (actual form).

    --set new form key on old form records
    
    update UFRecords set form = 'NEW FORM KEY' where form = 'OLD FORM KEY'
    
    -- update RecordData field with new keys
    
    update UFRecords set RecordData = cast(replace(cast(RecordData as nvarchar(max)),'034B9219-ADD1-4C6D-A6CD-DD1096802E0','9BB74648-80A9-4FC9-BE98-D808ABA2CB62') as ntext)  where id = 619        
    
    --update record field -> this is done 4 times to 4 form fields
    
    update UFRecordFields set FieldId = 'NEW Field ID', Alias = 'NEW ALIAS'  where record = 619 and FieldId = 'OLD Field ID' 
    

    At moment, appeared news records in list of entries from actual form but the values returned as empty . enter image description here

    If I want to see more details from that record, doesn't show any value like you can see in this picture: enter image description here

    What could it be?

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies