Forum Discussion
MarkShnier__You
5 years agoQrew Legend
See 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
------------------------------
- AndrewFry5 years agoQrew Assistant CaptainThanks Mark!! I read through the link you provided. I should have thought about that.
I have a number of custom buttons already in my different forms for things such as Approvals, Clock in/out, etc., and by using the code in the button, I populate certain fields in the same form.
I guess I wasn't associating the fact that I could do the same with a different table. My understanding and application of the concept stopped at doing things on the same table where the button is located, and it didn't even occur to me to use the same process across different tables.
But it makes sense if I am already transitioning to the other table, to call out the appropriate field and have it pre-populate, which is exactly what I was looking for.
Thanks for pointing me in the right direction!!
------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------ - AndrewFry5 years agoQrew Assistant CaptainHmmm, 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
------------------------------- MarkShnier__You5 years agoQrew LegendThe 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
------------------------------- 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
------------------------------