Forum Discussion

Re: Pre-populate Dropdown Field on Button click

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
------------------------------

2 Replies

  • AndrewFry's avatar
    AndrewFry
    Qrew Assistant Captain
    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
    ------------------------------