Question about adding multiple child records using Focus Task table

Question

In using the method described here: &nbsp;http://www.quickbase.com/quickbase-blog/how-to-quickly-create-multiple-child-records-in-quickbase&nbsp;The instructions state that the Focus Task table is created and uses a look up field for the Related Project, figure 5 in the instructions. &nbsp;The instructions then go on to ask that you create one and only one record in the Focus Task table and that record has a Related Projects field of 1 which was manually entered. &nbsp;Is the expectation that in order to use the functionality, a user would need to manually update the one record in the Focus Task table with the project id of the project where the button lives? &nbsp;Is there an automated way to tie the created task to the current project using this method?Thanks!

quickbasecoachd · Answer

yes, you could make a URL formula button &nbsp;on a project record to update that Focus task record &nbsp;and then land the user on that Admin record.

joep_ · Answer

Ok, thanks! &nbsp;I was able to get it working. &nbsp;I see it in the instructions now too, but didn't follow them at first:In this formula, first you are setting a variable called �SetFocus.� This is a URL that will go to our single Focus record and change the �Focus � Related Project� field to the �Record ID� of the current Project you are on. Make sure to change the �&amp;_fid_6� to whatever the actual field ID for �Focus � Related Project� is in your table.

Forum Discussion

Question about adding multiple child records using Focus Task table

Related Content

Using Grid Edit to Edit Multiple Records at Once

Edit Multiple Records at Once with Grid Edit

Modify multiple rows within the same group using Single Record ?

Form Rule Question

Jinja Question: Adding business days to today