Forum Discussion

RezaKhosrowabad's avatar
RezaKhosrowabad
Qrew Cadet
5 years ago

Several Record IDs in the same URL

Hello,
Please see attached.
in this URL, there are several Record ID numbers.

Are they all the same record ID or belonging to different tables?
thank you,
Reza


------------------------------
Reza Khosrowabadi
------------------------------

3 Replies

  • If you copy and paste the actual code I will have a look.  It's too difficult to read on a screen shot.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • RezaKhosrowabad's avatar
      RezaKhosrowabad
      Qrew Cadet

      Hello Mark,
      Here you go.


      If(

      [Compliance HRT]="Not In Compliance", "javascript:alert('This question is already marked as Not In Compliance')",

      URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=dqjjre3d4kyu3pd3iutv7xf9mi9&rid=" & [Record ID#] & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_ACTION_PLANS] & "?a=nwr&_fid_21=" &[Record ID#]&" &nextURL=" & URLEncode(URLRoot() & "db/" & [_DBID_Reviews] & "?a=dr&rid=" & [Related Review]))
      )

      ------------------------------
      Reza Khosrowabadi
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        I'm not sure that I understand the question.  But the lines I have comments out with // do  not make sense.  That is an API to edit a record, but then no fields are being updated, so it would not be doing anything.


        The first part with he alert look OK, if its working for you.

        The next part where I have commented out does not appear to do anything.

        The part beginning with & "&rdr=" will put up what appears to be an Add Record form to attach a child to Parent.

        The last part will direct he user to a review which appear to be a parent record to where the button is located.

        If(

        [Compliance HRT]="Not In Compliance", "javascript:alert('This question is already marked as Not In Compliance')",

        //URLRoot() & "db/" & Dbid() & //a=API_EditRecord&apptoken=dqjjre3d4kyu3pd3iutv7xf9mi9&rid=" & [Record ID#]

        & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_ACTION_PLANS] & "?a=nwr&_fid_21=" &[Record ID#]

        &" &nextURL=" & URLEncode(URLRoot() & "db/" & [_DBID_Reviews] & "?a=dr&rid=" & [Related Review]))

        )

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------