Skip to main content
Question

Assign related record in other table

  • October 26, 2023
  • 0 replies
  • 55 views

Forum|alt.badge.img+8

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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+8
  • Author
  • Quickbase Alumni
  • October 26, 2023

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
------------------------------