Assign related record in other table

Question

I'm trying to build a mentor tracking app for our employee group. I have a table of new hires and a table of mentors. Currently, I go in to edit the existing record and "assign" the mentor to the new hire using the related text lookup. I'm wondering if there is a way to add a link or button in the table that would bring up a form or something that could do this all from the dashboard without having to go in to edit the record. Thank you!

------------------------------
Hannah Engelson
------------------------------

hannahengelson · Answer

I was able to find a formula URL field that would pull up a specific new form in edit mode, but when I select the URL it comes back with the error that Mentee Record doesn't exist.&nbsp;

URLRoot() &amp; "db/" &amp; [_DBID_NEW_HIRE_PILOTS] &amp; "?a=er&amp;dfid=12&amp;rid=" &amp; [Employee ID]------------------------------Hannah Engelson------------------------------

chayceduncan · Answer

Is Employee ID a field that you enter for each employee? Your url is saying rid=[Employee ID] but rid typically corresponds to the built in Quickbase Record ID#. Try swapping out [Employee ID] with [Record ID#] like so:&nbsp;

URLRoot() &amp; "db/" &amp; [_DBID_NEW_HIRE_PILOTS] &amp; "?a=er&amp;dfid=12&amp;rid=" &amp; [Record ID#]------------------------------Chayce Duncan------------------------------

hannahengelson · Answer

Chayce, I saw your message right after I figured it out. Thank you for replying!------------------------------Hannah Engelson------------------------------

Forum Discussion

Assign related record in other table