copy project and its related tasks

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

We had a button to copy a project and its related tasks (project table related to task table), and it was working great for years.  We did add some new fields recently, and some are conditional fields...and now the the tasks do not get copied with the project.  I tried to walk back all of the added fields, but cannot get the button to work.  I do notice that an old copy of my app, where the button works correctly, has a different formula.  Here is the formula that works:

"javascript:void(copyMasterDetailButtonHandler('&copyFid=6&destrid=0&sourcerid=" & [Record ID#] & "'))"

Here is the formula that does not work:

"javascript:void(copyMasterDetailButtonHandler('&relfids=111&recurse=false&copyFid=6&destrid=0&sourcerid=" & [Record ID#] & "', 'bk24d7xwq'))"

Any ideas?

Photo of J1987

J1987

  • 60 Points

Posted 3 years ago

  • 0
  • 1
Have you tried rebuilding the button?
Btw, the button is dependent on the existence of fid 111 being a Report Link field on the relationship between Projects and tasks. Ie, on the Projects Table. If that field got deleted, then the button will fail. I suggest ensuring that the report link field exists and if it is no longer fid 111, then edit the formula with the new field ID or rebuild the button.  Perhaps that Report Link field was deleted or deleted and then recreated with a new field ID number.
Photo of J1987

J1987

  • 60 Points
That was it. We must've recreated the link field.  The ID was 416.  Changing that in the formula did it.  Thank you very much, Mark!
:)