I have an automation that creates a new record on Table B when the existing record on Table A is modified. Due to the specific report I need, I could not create a traditional relationship between these two tables so I created the automation instead. When the new record is created on Table B, it will have a field that references the Record ID of the triggering record from Table A. I would like to make a formula URL field on Table B that creates a link to the triggering record on Table A. My assumption is that I need to do this using the record ID, but I'm not sure how.
Question
Creating a URL based on a record ID
This topic has been closed for replies.
+12Build a formula-URL field in your Table B:
URLRoot() & "db/" & [_DBID_TABLE_A_ALIAS_NAME] & "?a=dr&rid=" &
URLRoot() & "db/" & [_DBID_TABLE_A_ALIAS_NAME] & "?a=dr&rid=" &
What if the triggering table (Table A) is actually 4 different tables that all feed into Table B? Is there a way to make the table ID a dynamic value changes based on the origin of the record ID? Or would I have to make a field that populates the table ID based on the original and then feed that field into the formula?
+12You would have to pass in the DBID of the originating table to hardcode the "db/xxxxxx" of the source as well as the Record ID# of the record. You can do this easily enough using a formula field in your Table A (4 variations) and just populate a text-value with that dbid when you create your Table B records.
Then your formula would be:
URLRoot() & "db/" & [Source Table DBID] & "?a=dr&rid=" & [Source Record ID#]
Then your formula would be:
URLRoot() & "db/" & [Source Table DBID] & "?a=dr&rid=" & [Source Record ID#]
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.