Missing "rid" parameter.

When  you make a Notification of type Open, while it does not seem to be documented, in fact you can just paste in a list of fields (I do them vertically) containing the fields of type email that have the email addresses.  Each field must only have one email address, not a list of email addresses.

so for example in the email who box, type

[email field 1]
[email field 2]
[email field 3]


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

------Original Message------

When  you make a Notification of type Open, while it does not seem to be documented, in fact you can just paste in a list of fields (I do them vertically) containing the fields of type email that have the email addresses.  Each field must only have one email address, not a list of email addresses.

so for example in the email who box, type

[email field 1]
[email field 2]
[email field 3]


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

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

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

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

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

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