URL Add Record then Save

It sounds like perhaps what you are describing is when creating a new record, the embedded report of related records, is not displaying as you're expecting. This is because the new record (in the process of being created) hasn't saved, thus doesn't have an ID under the hood. The related records can't be displayed until their parent record is saved linking their IDs together.

Here are some things worth considering:

• You may check a box in your formula url by setting the field to 1 (true)
• e.g. &_fid_999=1 (where 999 is the ID of the checkbox)
• In Table Settings -> Forms -> Properties tab check "Show save & keep working choice" as Mark eluded
• Use Form Rules instead, to check the box when appropriate
• Consider a formula checkbox instead (that self checks when conditions are met)?
• Look into Pipelines to perform checking a box after the record is saved
• The latter seems like overkill for this situation

For me, it's unclear which table stores the checkbox data from your example. And what specifically it represents.

Anyway, hope that helps!

Try this

This button will work in both Add Mode or Edit Mode.

var text RID = If([Record ID#]>0, ToText([Record ID#]), "%%rid%%");

var text URL = URLRoot() & "db/" & Dbid() & "?a=dr"
& "&rid="& $RID;

"<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; background: #117a39; border-radius: 5px; color: #FFFFFF; display: inline-block; padding: 4px 4px 4px 4px; width:140px; text-align: center; text-shadow: none; border: 2px solid #0863f5; font-size: 12px \"href='"
& $URL
& "'>Save</a>"

// I changed the a=er (action = edit record)

// to be a=dr (action = display record)

Stephanie,

If you are testing Marks code, be sure that you change something in the record. The SaveBeforeNavigating only works as a 'Save' if something changes, so sometimes you will think it is not working, but really nothing changed so it just navigated away from the form. I can't tell you how many times this has tricked me (especially when using the code from an add record form - fields with default values don't appear to be changes so the added record would not auto save with the button push).

------------------------------
Mike Tamoush
------------------------------

When the EOTI user adds a record, as long as any single field on that record changes, it will be considered a change, and thus saved. I can't imagine someone will submit a form without selecting anything or typing in any single box.