Automatically copy data from 1 row to another row

  • James Heagney
    Asked on May 31, 2022 at 6:55 PM

    Hello Support, I am writing to ask two questions regarding Jotform Tables.
    1. Is it possible to have an action that simply copies a row of data to a new row? Kind of like a cut and paste in a worksheet?
    2.

    Does Jotform Tables secured by user? In other words, when I have multiple users in the system adding rows, is there a way for each user to see only the rows assigned to them. Is there a security model that governs this?


    This is a re-post of a comment on What Are Jotform Tables Action Buttons?

    Page URL: https://www.jotform.com/help/what-are-jotform-tables-action-buttons/
  • Afzal JotForm Support
    Replied on May 31, 2022 at 11:41 PM

    Hi James,

    Thanks for reaching out to Jotform Support. Yes, it is possible to automatically copy data from 1 row to another row however it's like copy-paste not cut and paste. Doing that is easy. Let me show you how:

    • On the Jotform Tables page, click on the + Add button next to the last column on the right.
    • On the Pop-up window from the Formula tab, select Advanced formula.
    • Create a new formula as shown in the screencast below:

    1654054460 6296de3ccbff6 nEW Screenshot 10

    As for your other question about Jotform Tables privacy, I've moved that to a new thread. You can check that out here.

    Should you have any other concerns, kindly let us know.