Assign related record in other table
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...
Forum Discussion
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.
URLRoot() & "db/" & [_DBID_NEW_HIRE_PILOTS] & "?a=er&dfid=12&rid=" & [Employee ID]
------------------------------
Hannah Engelson
------------------------------
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:
URLRoot() & "db/" & [_DBID_NEW_HIRE_PILOTS] & "?a=er&dfid=12&rid=" & [Record ID#]
------------------------------
Chayce Duncan
------------------------------
Chayce, I saw your message right after I figured it out. Thank you for replying!
------------------------------
Hannah Engelson
------------------------------