0

Duplicate and move From Table1 to Table2 ?

Good evening

Can you help me to duplicate record but in another table to archive old records ? I have a Table-A with several fields and Table-B with the same fields but all empty to receive the records to archive? I want to create a button to duplicate from Table-A to Table-B ?

thanks

8 replies

null
    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    let i := (create 'Table-B');
    let F1 := 'Field Name 1';
    let F2 := 'Field Name 2';
    i.('Field Name 1' := F1);
    i.('Field Name 2' := F2);
    openRecord(i)

    • Direction.1
    • 4 yrs ago
    • Reported - view

    it works well thank you very much,

    on the other hand I encountered a problem to duplicate the sub-table links and the imported images and files

    is it possible to copy them too ??

    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    Are you aware that the Ninox Cloud automatically backs up your databases?

    • Direction.1
    • 4 yrs ago
    • Reported - view

    yes I know but my database has become too slow and too heavy with old records and I want to move them to another database without losing the information

    • Direction.1
    • 4 yrs ago
    • Reported - view

    Please do you have an idea to duplicate the links between tables ? and files attached ?

    • Direction.1
    • 4 yrs ago
    • Reported - view
    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    I do not know. Maybe someone else can help from this forum or you can ask Ninox support directly.

     

    I would be very interested in knowing what you think is causing the slowness (ie. number of columns, records, images, etc.). At what point did you first find the slowness to be an issue? Are you using the Ninox Cloud? Maybe your problem will be resolved if/lwhen Ninox introduces lazy loading.

    • Direction.1
    • 4 yrs ago
    • Reported - view

    I think it’s a problem of loading the data before displaying it because on ipad for example it loads only recent data and modifications but on the web does it again from the start

    we use ninox on all supports iPadOS iOS Mac but the problem persists only on the web application and sometimes on Android

    I have already sent two complaint emails

Content aside

  • 4 yrs agoLast active
  • 8Replies
  • 778Views