Check a box while opening a new record

Question

I would like to mark the parent record assigned at the same time a new child record is created, in one scenario. So what can I add to the existing 'Add Record' formula to do that?

URLRoot() & "db/" & [_DBID_LOCATIONS] & "?a=API_GenAddRecordForm&_fid_10=" & URLEncode ([Record ID#])& "&z="

-and-

In another scenario, I am looking to populate the Date/Time field while opening a new record.
What can I add to my existing Time Stamp Button formula to do that?

var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" &([Record ID#])
& "&_fid_29=" & Now();

"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});" & "void(0);

quickbasecoachd · Answer

Fr the first one, I suggest that you consider an alternative approach. If the "definition" of a parent record being assigned is that it has a child record, how about adding a summary field for the [# of children]

Then make the checkbox field for [Parent Record assigned?] can be

[# of children] >0

or if you prefer to be needlessly verbose,

IF([# of children] >0, true, false)

As for the second question, are you saying that whenever the record is manually edited you want to set a date/time field to now()? If that is the case, why not just use the built in [date modified] field as it will be auto populated with the date/time of the last edit.

mcfneil · Answer

If you are looking to edit the parent record then create a child record, you will want to use an

API_EditRecord call with a RDR to the AddGenRecordFrom.

Generally speaking it will look like this:

URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_EditRecord&rid="&[Record ID#]&"&apptoken=xxxxxx&_fid_12="&URLEncode("true")&"&_fid_39="&URLEncode(User())&"&_fid_48="&URLEncode(Now())&"
&rdr="&
URLEncode([URL Add Time Entry])

This one Edits the parent task (marks complete) and redirects to add a time entry.

kellybianchi · Answer

In both situations, I just want to execute an action based on the push of a formula button that already exists. The idea is just to streamline the workflow from 2 steps to 1.

kellybianchi · Answer

I want to consolidate the 2 buttons into one step.

mcfneil · Answer

[Location Assigned]&amp; "&amp;rdr=" &amp; URLEncode([Add Location])This might do it.

Forum Discussion

Check a box while opening a new record

Related Content

Formula URL Button to Open New Form and Check a Box

Nested API Button open form to add input, check box and redirect back to original form

Custom Record Titles

Using Grid Edit to Edit Multiple Records at Once

Check one field for multiple conditions