Missing "rid" parameter.
i have created one formula (button) which updated the checkbox to checked and redirect to the new custom page. URLRoot() & "db/" & Dbid() &"?a=API_EditRecord&rid="& URLEncode ([Record ID#])& "&_fid_...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIf you edit the FORM properties for where that field is on the form, you can override the field heading words by a checkbox, but then leave the words blank.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Do i need to create one checkbox and add the rule on checkbox ?
Could you please elaborate more.------Original Message------
If you edit the FORM properties for where that field is on the form, you can override the field heading words by a checkbox, but then leave the words blank.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- MarkShnier__YouJust view any record or get into Add mode to add a record.
click at the top right in Customize this Form
locate the field on the form
observe the checkbox to use Alternate Label Text
Check the box but leave the words blank to override the heading to blank.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - Good morning!
I'm having a similar issue. When creating a new record I want to be able to add a Label PO and change the Status field to "Labels Ordered". The status field is a drop-down box. I'm guessing it's due to the record being new is why my formula does not work.
URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Order ID#]
& "&_fid_28="&URLEncode("Labels Ordered") &"&RDR="&URLEncode(
URLRoot() & "db/" & [_DBID_LABEL_PURCHASE_ORDERS] & "?a=API_GenAddRecordForm&_fid_25=" & URLEncode ([Order ID#]) & "&z=" & Rurl())
------------------------------
Bryan Fichtner
------------------------------ - MarkShnier__YouI suggest that you use a Dynamic Form Rule
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - That's the biggest give-up answer ever. How would a dynamic form rule add a new record and change certain fields?
Here is what I'm trying to.
I add an Order PO, to that purchase order I add a Label PO, and when I add the new Label PO to the Order I need it to change the Status field (drop-down field) to Labels Ordered.
------------------------------
Bryan Fichtner
------------------------------ - MarkShnier__YouRe: That's the biggest give-up answer ever. How would a dynamic form rule add a new record and change certain fields?
The question was that the user was already in Add Mode for manually entering an (unsaved) record and wanted a button to check a box to checked. That did not make sense to me as an "ask" as the user could just check the box manually instead of pushing a button or else use a dynamic form rule to auto check the box if some conditions were true.
As for your question, I suggest using an Automation or Pipeline.
The Trigger would be that a label PO Record is added, and the Parent Order PO status field (looked up own to the Label PO record) is not "Labels Ordered".
The Action would be modify the Order PO where the filter is that the [Record ID#] matches the [Related Order of the "trigger record" and set the status to Labels Ordered.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
