Forum Discussion
AndrewFry
Qrew Assistant Captain
Hmmm, it doesn't seem to be working as I had expected.
Here is the code from my Add Note button in the Assignments form:
URLRoot() & "db/" & [_DBID_TABLE_1]
& "?a=API_GenAddRecordForm&_fid_25=" & URLEncode ([Assignment ID #])
& "&_fid_34=" & "Assignment"
& "&z=" & Rurl()
The field 34 in my Notes table, is a related field from the Notes Type table. It is a drop down menu. Not sure if any of that makes a difference.
------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------
Here is the code from my Add Note button in the Assignments form:
URLRoot() & "db/" & [_DBID_TABLE_1]
& "?a=API_GenAddRecordForm&_fid_25=" & URLEncode ([Assignment ID #])
& "&_fid_34=" & "Assignment"
& "&z=" & Rurl()
The field 34 in my Notes table, is a related field from the Notes Type table. It is a drop down menu. Not sure if any of that makes a difference.
------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------
MarkShnier__You
5 years agoQrew Legend
The Key field on your Notes Type table is probably Record ID# and you are probably trying to populate the field called [Related Note Type], which is a numeric field.
So just have a look at the Notes Type table to see what Record ID is for "Assignment" and then put that number into the formula
like
& "&_fid_34=" & "3" // ie if Assignment rid is 3.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
So just have a look at the Notes Type table to see what Record ID is for "Assignment" and then put that number into the formula
like
& "&_fid_34=" & "3" // ie if Assignment rid is 3.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- AndrewFry5 years agoQrew Assistant CaptainMark,
It is like you are sitting right here looking at it!! hahaha
I have my Types in a list within the Type field of the Note Types table. The field ID for it is 3. The field type is: Text - Multi-choice.
When I put the 3 in the formula, due to the field ID being 3, I was confused as to how it would pull in the correct type. But I tested it.
It gave me the 3rd item in the list. So changed it from a 3 to a 1 and it gave me what I needed.
Thanks for the clarification Mark and pointing me in the right direction!!
------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------- MarkShnier__You5 years agoQrew LegendOK, glad its working.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------