Pre-populate Dropdown Field on Button click
I have a Notes table that is related to multiple other tables. Each of those tables' forms have an "Add Note" button which takes me to the Note's form. In the Notes form, there is a Type dropdow...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendSee this response here to a similar question
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=c339b7c1-65fc-4250-8d33-338770cd8e37&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer#bmc339b7c1-65fc-4250-8d33-338770cd8e37
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=c339b7c1-65fc-4250-8d33-338770cd8e37&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer#bmc339b7c1-65fc-4250-8d33-338770cd8e37
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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__YouThe 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
------------------------------- Mark,
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__YouOK, glad its working.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
