Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
6 years ago

Meeting Minutes with Open Items continuing to the next Meeting Minute

I have two related tables: Meeting Minutes < Meeting Minute Items The meeting minute captures overall information such as attendees, the date of the meeting, the meeting number, etc. I have ano...
Relationships
IvanWeiss's avatar
IvanWeiss
Qrew Captain
6 years ago
Mark, I think I got most of this but having a hard time with the button...  Here is my formula url, never used the disprec function before so my assumption is that I am using it wrong

var text UrlOne = URLRoot() & "db/" & [_DBID_Meeting_Minutes_Carry_Over_Support_Table] & "?a=API_EditRecord" &
"&rid=1" &
"&apptoken=c5gchf9bhwx6umbd2ii5zdqtb5x8" &
"&_fid_6=" & [Record ID#];

var text UrlTwo = URLRoot() & "db/" & Dbid() & "?a=API_AddRecord" &
"&_fid_16=" & URLEncode([Related Project]);

$UrlOne & URLEncode($UrlTwo) & URLEncode(URLEncode("&disprec=1"))

------------------------------
Ivan Weiss
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
OK, we will get there step by step

var text URLOne = URLRoot() & "db/" & [_DBID_Meeting_Minutes_Carry_Over_Support_Table] & "?a=API_EditRecord"
& "&rid=1"
& "&apptoken=c5gchf9bhwx6umbd2ii5zdqtb5x8"
& "&_fid_6=" & [Record ID#];

var text URLTwo = URLRoot() & "db/" & Dbid() & "?a=API_AddRecord"
& "&apptoken=c5gchf9bhwx6umbd2ii5zdqtb5x8"
& "&_fid_16=" & URLEncode([Related Project])
& "&_fid_99=1" // populate the checkbox field called [Needs Minutes Carried forward?]
& "&disprec=1";

$URLOne & URLEncode($URLTwo)


// note that we need the field [Needs Minutes Carried forward?] checked to be able to trigger an //Automation to carry forward the open Meeting Minute Items
// edit the 99 to be the correct fid


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • IvanWeiss's avatar
    IvanWeiss
    Qrew Captain
    6 years ago
    I received the following result with this code....  Something still didnt work right

    var text UrlOne = URLRoot() & "db/" & [_DBID_Meeting_Minutes_Carry_Over_Support_Table] & "?a=API_EditRecord" &
    "&rid=1" &
    "&apptoken=c5gchf9bhwx6umbd2ii5zdqtb5x8" &
    "&_fid_6=" & [Record ID#];

    var text UrlTwo = URLRoot() & "db/" & Dbid() & "?a=API_AddRecord" &
    "&apptoken=c5gchf9bhwx6umbd2ii5zdqtb5x8" &
    "&_fid_16=" & URLEncode([Related Project]) &
    "&_fid_43=1" &
    "&disprec=1";


    $UrlOne & URLEncode($UrlTwo)

    // note that we need the field [Needs Minutes Carried forward?] checked to be able to trigger an //Automation to carry forward the open Meeting Minute Items




    ------------------------------
    Ivan Weiss
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      sorry that last line should be

      $UrlOne
      & "&rdr=" & URLEncode($UrlTwo)

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • IvanWeiss's avatar
        IvanWeiss
        Qrew Captain
        6 years ago
        Ugh I should have seen that.  Something didn't look right to me too!  That fixed the button and the automation fires.  It is creating a new meeting minute record but it is not carrying over the data so I am assuming something is off in the automation....  I am realizing we are not using the "target meeting minute field anywhere" and maybe that is the issue?


        ------------------------------
        Ivan Weiss
        ------------------------------