Forum Discussion

YehudahGreenber's avatar
YehudahGreenber
Qrew Assistant Captain
8 years ago

HTML import button of tasks uses predecessors numbers not in the database

I followed Steve Smith's instructions ( here http://www.quickbase.com/quickbase-blog/how-to-quickly-create-multiple-child-records-in-quickbase ) and it worked like a charm until i created tasks with predecessors.  When I do that, then the original predecessor number is imported, and within the task i get an error that that number doesn't exist within the database.  Is there a way to fix this?

18 Replies

  • Did you use the wizard to make the button, or are you using the API approach?

    If you are making a button which will also Copy the Parent project record, then you need to specify a text data entry field such as Project Name so that the new Project record = can be created with a name lkke Copy OfProject xyz.

    But I thought you were trying to make a button which would import Tasks from a given template Project.  In that case, the CopyFID is not required.
  • YehudahGreenber's avatar
    YehudahGreenber
    Qrew Assistant Captain
    I used the wizard, so I'm not sure where I'm going wrong.  First, I saved records to a project.  Then, I used the wizard to create a copy button to create that specific project.  I've done this with several projects, and all of them return that error.
  • 1. Are you trying to be able to Copy a whole Project along with its Children?

    2. Can you post the code for the button that the wizard created for you

    3. and also tell me the name  and the field ID# of the field which identifies the project - typically a field called Project Name.
  • YehudahGreenber's avatar
    YehudahGreenber
    Qrew Assistant Captain
    1 Yes I am.  2  "javascript:void(copyMasterDetailButtonHandler('&sourceRID=43&destrid=" & [Record ID#] & "', 'bmyj8t4e4'))"   3  I'm not sure which project I copied as I've been experimenting with many random projects...  I'll try another one now and keep track of it. 
  • YehudahGreenber's avatar
    YehudahGreenber
    Qrew Assistant Captain
    I think I see the problem...  Because of my experiments. every project has a copy entire project button.  I'll clean it up and try again.
  • OK, post back if you are still stuck and I will have a quick look at your app on a GotoMeeting 
  • YehudahGreenber's avatar
    YehudahGreenber
    Qrew Assistant Captain
    Still no luck.  Here's the button:  "javascript:void(copyMasterDetailButtonHandler('&sourceRID=49&destrid=" & [Record ID#] & "', 'bmyj8t4e4'))"

    Field id is 16  for "copy test
  • Contact me via the contact info on my website and I will have a quick look now.
    quickbasecoach.com  They don't like us posting email addresses on this forum so just email me directly at my gmail email address.