0

Is there a way to do versioning of fields?

I think about a database, that holds marketing data. I would like to edit w.g. a "slogan" once in a while, but keep history of versions. Do I need to have a separate table with entries for that? Or could I have some kind of versioning of fields?

1 reply

null
    • Mel_Charles
    • 2 yrs ago
    • Reported - view

    Hi Dirk

    You would need to create a child table to hold the previous versions.

    The ay I do it is to have the filed locked before edit the prress a button (that has the script to both unock the fields and copy the selected filds to the child table)

    go ahead with your edit then on on form exit have it relock those fields

    all very do able!

    I do this for GDPR updating of contact info - not not that very different to what you are doing

     

    as an example (button script)

    this checks to see if the status filed has been updated

    it then copies slected info into variables (let etc)

    creates an entry ith child table called GDPRaudit (let i :=(create GDPRaudit)

    copy the saved fields from variables - ie i.(Company (this is the feld name) := xCompany (this is the variable name I gave ))

     

    (extract form the button script)

    Unlock := 1

    if 'GDPR Status' > 0 then 
    let xCurrRec := Id;
    let xCustID := Custid;
    let xCompany := Company;
    let xFullName := FullName;
    let xEmail := Email;
    let xPhone := Phone;
    let xMobile := Mobile;
    let xGDPR := 'GDPR Status';
    let i := (create GDPRaudit);
    i.(CustId := xCustID);
    i.(Company := xCompany);
    i.(FullName := xFullName);
    i.(Email := xEmail);
    i.(Phone := xPhone);
    i.(Mobile := xMobile);
    i.(GDPR := xGDPR);
    end

Content aside

  • 2 yrs agoLast active
  • 1Replies
  • 205Views