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.

Build a formula-URL field in your Table B:URLRoot() & "db/" & [_DBID_TABLE_A_ALIAS_NAME] & "?a=dr&rid=" &

Quick Base has two different systems for identifying records. when it says &rid=123 then it is referring to a regular base 10 normal numbering system.when it says &r=ku then it is using a Base 32 encoding system. There is likely some historical legacy reasons for this as Quick Base was invented in the late 1990s and perhaps memory was expensive back then, so storing in Base 32 may have been more efficient back then.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

I thought I posed this, but it seems it did not take,if you make a formula numeric fieldQB32Decode("ku")the result is, indeed, 338.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

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?

You 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#]

Creating a URL based on a record ID

LauraThacker
Qrew Captain
6 years ago
Build a formula-URL field in your Table B:

URLRoot() & "db/" & [_DBID_TABLE_A_ALIAS_NAME] & "?a=dr&rid=" &
SarahSarah
Qrew Cadet
6 years ago
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?
LauraThacker
Qrew Captain
6 years ago
You 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#]
- ChristopherJob
  Qrew Trainee
  5 years ago
  Hello Laura.
  
  I've been using the same formula that you have laid out, though "&dfid=11" was added after the Record ID# in my formula. It was working for a few months but then just a week or two ago it quit working. Below is what my formula actually looks like:
  
  URLRoot() & "db/bpiur66d5?a=dr&rid=" & [Record ID#] & "&dfid=11"
  
  Can you see anything as to why it wouldn't work? (I've also removed the "&dfid=11" from the formula with out any luck)
  
  Did Quickbase make any changes as to how record ID #'s are identified?
  
  ------------------------------
  Christopher Job
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    5 years ago
    Have you copied your app? Did the table identifier change?
    
    If you are building a button to display the same record on an alternate form, then it is better to use this syntax
    
    URLRoot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#] & "&dfid=11"
    
    The dbid() will always return the table that you are now sitting on. Hence it is not good practice to hard code the table ID as if you copy the app, it will fail.
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------

Forum Discussion

Creating a URL based on a record ID