Skip to main content
Question

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

  • July 31, 2017
  • 0 replies
  • 48 views

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?
This topic has been closed for replies.

The native method of creating child records will preserve the predecessors properly.

You have not described your use case,  but have you explored the functionality in app management for the wizard which is titled Copy Master Detail?

A typical use for that is that you have a a situation where you have say 6 standard Projects each with its own set of standard tasks.  You would then create 6 buttons to import a set of standard tasks and presented which buttons are presented to the users based on either the user's choice or the "Project Type".

No I have not tried that where is the wizard?

Oh got it I'm looking at it now thank you.

.. and typically, you do a summary count of the # of tasks and then suppress the import std tasks button(s) if the project already has tasks, so that you users don't import the set of tasks in duplicate / triplicate.

So far so good.  With this method, is there a way to "import" the copy button from one table to another?  In other words, can I have multiple buttons on a projects, one which imports table x, one which imports table y, and on for z?

I don't know what you mean by import a button.  The button can be created using the API method, or by using that Wizard to build the button for you, or if you understand what the parameters of the button code are, you can copy that button  and edit it's parameters to save time building multiple button with the wizard..

I think I know how to do what I want...  Thanks for your help.


Well then let me say Mazel Tov on your journey. :)

Yup...  So far. so good.

I'm trying to copy a specific project, and when I hit the "copy" button, I receive the following:  There was an error copying the records. Contact the application administrator with the error details below. 

Error Details:
CopyFID required

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.

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.

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. 

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 

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.