JackWoods
4 years agoQrew Trainee
Customize "New Task" Button on a Project to Populate fields on task from Project
Hey Quickbase Family,
I'm trying to customize my "New Task" button on my project table so that the new tasks being created on that project can inherit a value from the project. The field is called "Personal Projects" and "Personal Tasks" and we want to make sure that if Project Project = Yes than the subsequent Tasks being added will also be Personal Tasks = Yes (And visa versa No > No).I've created a dynamic form rule to follow this logic but want my buttons to follow the same logic.
Below is my code in the button right now that I'm getting an error on. It talks of inheriting the name of the project first and the second part is my writing of the personal project information. "Personal Tasks" is field 102 in the system. I seem to get an error at the "&z="& (in red) telling me "There are extra characters beyond the end of my formula"
URLRoot() & "db/" & [_DBID_TASKS] & "?act=API_GenAddRecordForm&_fid_48=" & URLEncode ([Project ID]) & "?act=API_GenAddRecordForm&_fid_102=" & URLEncode ([Personal Project]) "&z="& Rurl()
Please help me resolve the issue so I can have Personal Projects only have Personal Tasks :)
------------------------------
Jack Woods
------------------------------
I'm trying to customize my "New Task" button on my project table so that the new tasks being created on that project can inherit a value from the project. The field is called "Personal Projects" and "Personal Tasks" and we want to make sure that if Project Project = Yes than the subsequent Tasks being added will also be Personal Tasks = Yes (And visa versa No > No).I've created a dynamic form rule to follow this logic but want my buttons to follow the same logic.
Below is my code in the button right now that I'm getting an error on. It talks of inheriting the name of the project first and the second part is my writing of the personal project information. "Personal Tasks" is field 102 in the system. I seem to get an error at the "&z="& (in red) telling me "There are extra characters beyond the end of my formula"
URLRoot() & "db/" & [_DBID_TASKS] & "?act=API_GenAddRecordForm&_fid_48=" & URLEncode ([Project ID]) & "?act=API_GenAddRecordForm&_fid_102=" & URLEncode ([Personal Project]) "&z="& Rurl()
Please help me resolve the issue so I can have Personal Projects only have Personal Tasks :)
------------------------------
Jack Woods
------------------------------