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?

Please Sign in or register to post replies

Write your reply to:

Draft