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...
APIs and custom code
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
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
5 years ago

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
    5 years ago
    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
    ------------------------------