Forum Discussion

AlexBennett3's avatar
AlexBennett3
Qrew Trainee
4 years ago

Setting a Default button to add default values across multiple fields.

Hey Everyone, I have another question that I can't seem to figure out. Is there a way that I can add a button to my form that will auto-populate fields with default values, but the user can change ...
APIs and custom code
Buttons
AhuvaBrown's avatar
AhuvaBrown
Qrew Trainee
Could you describe the process to me in more detail?

If I understood correctly, it seems to me that the cause of your issue is this part of the code: rid=" & [Record ID#] 
That record ID is referring to the record that the button is being clicked on. If you're clicking the button on a different record than the one you want to change, you'd need to set it up slightly differently.

If, say, you're on a table called Tasks, and you're trying to access or edit a record from the related Projects table, you'd need to do this: rid = " & [Related Project]

 I might have misunderstood your problem, so if this doesn't solve it, can you give me a more detailed explanation?

------------------------------
Ahuva Brown
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
The likely cause is trying to click the button on a record that is in ADD mode where the Record ID# does not yet exists.

If you want to default in certain field values, then you should use form rules when in Add mode.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------