Discussions

Expand all | Collapse all

Copy the Project - Error for User (but not admin)

QuickBaseCoach Dev./Training10-17-2018 17:52

  • 1.  Copy the Project - Error for User (but not admin)

    Posted 10-17-2018 16:45
    Hi, When I use "copy the project" as an admin, all the records gets copied. But, it throws up the below error message, when an user try it. Any idea as to why it is happening. And, I could not find the table (bn3txf9mx) it is referring to. How do I find that information?

    "There was an error copying the records. Contact the application administrator with the error details below. 
    Error Details:
    You do not have permission to add records to the table: bn3txf9mx"


  • 2.  RE: Copy the Project - Error for User (but not admin)

    Posted 10-17-2018 16:50
    Is it possible that one of the tables or fields in the app is referencing a table or field in another QuickBase app that the user doesn't have permissions for? I have seen that cause errors before. 


  • 3.  RE: Copy the Project - Error for User (but not admin)

    Posted 10-17-2018 16:55
    I have hid 3 more tables in the app from Users as they are not applicable to our project. In addition, I also took away the permission to "add" any record to these tables. After your reply above, I went back to just give them access to "add", but still kept it hid from their view, it is now throwing up a different error message "Error Details: Oops. You don't have permission to access that page


  • 4.  RE: Copy the Project - Error for User (but not admin)

    Posted 10-17-2018 17:36
    Thanks Jason, it is the relationship that it had with the other tables created that issue, once I broke that it works fine.

    Now my other part of the question is, when copying the project, it is copying all the tasks and subtasks of the project. I just wanted the functionality to copy only the project details, the tasks and milestones will be separately added to this new project by the PM. Do you know how to modify the command to copy only the project details with task and everything empty?


  • 5.  RE: Copy the Project - Error for User (but not admin)

    Posted 10-17-2018 17:48
    Not sure on this one. I think maybe a QuickBase action or automation could be used. 


  • 6.  RE: Copy the Project - Error for User (but not admin)

    Posted 10-17-2018 17:52
    Please post the code for your Copy button


  • 7.  RE: Copy the Project - Error for User (but not admin)

    Posted 10-17-2018 17:52
    javascript:void(copyMasterDetailButtonHandler('&copyFid=16&destrid=0&sourcerid=" & [Record ID#] & "', 'bn3txf9h2'))"


  • 8.  RE: Copy the Project - Error for User (but not admin)

    Posted 10-17-2018 17:55
    I suggest that you go though that wizard help to make the button over again, and this time when it asks if you want children copied from all relationships, select only some of the relationships. 


  • 9.  RE: Copy the Project - Error for User (but not admin)

    Posted 10-17-2018 17:56
    Is the end goal just to copy the field values for the Project a user is viewing and not to also copy all the child records? If so there is also the Copy this Project functionality that appears under the More dropdown that only copies the record that the user is currently viewing and does not copy any of the child records. 


  • 10.  RE: Copy the Project - Error for User (but not admin)

    Posted 10-17-2018 17:59
    I see only "copy the table" not "copy the project" option


  • 11.  RE: Copy the Project - Error for User (but not admin)

    Posted 10-17-2018 18:00
    Mark - the code came with the template I downloaded, I don't know where the wizard is.


  • 12.  RE: Copy the Project - Error for User (but not admin)

    Posted 10-17-2018 18:04
    Ahh ok, the Copy this Project option appears when you are viewing the record in form mode. When you are on a report you see the Copy Table dialog instead.

    Alternatively the wizard for creating a copy master and detail button can be found in the App settings under App Management. There is an option for Copy Master & Detail records that will take you to the wizard. 


  • 13.  RE: Copy the Project - Error for User (but not admin)

    Posted 10-17-2018 18:05
    The wizard is under Settings for the application, then App management and then 
    Copy master & detail records


  • 14.  RE: Copy the Project - Error for User (but not admin)

    Posted 10-17-2018 18:10
    re: I see only "copy the table" not "copy the project" option

    If you just want to copy a Parent record and not the children, then view any record and use the "More .." button.


  • 15.  RE: Copy the Project - Error for User (but not admin)

    Posted 10-17-2018 18:33
    I don't see a 'more' button when I am in a record. it just gives me save and close


  • 16.  RE: Copy the Project - Error for User (but not admin)

    Posted 10-17-2018 20:36
    :)  
    then view any record and use the "More .." button.

    You need to be in View mode,  not edit.

    btw, if that More button does serve you needs, that can easily be made into a more obvious URL formula button for users to push when Viewing a record.

    Note also that you can control which fields will copy forward, when using that More button method.  That is a field property checkbox setting,.


  • 17.  RE: Copy the Project - Error for User (but not admin)

    Posted 10-17-2018 21:31
    'view' and option 'more' works perfect for my need. Thank you everyone.