Discussions

Expand all | Collapse all

Modify a button to save before adding a record in a separate table

  • 1.  Modify a button to save before adding a record in a separate table

    Top
    Contributor
    Posted 08-09-2017 20:14
    I have the following button working to go to a different table and add a record for the related project.  What I would like to do is add in a save part to happen before going to the new table and adding a record.
    URLRoot() & "db/" & [_DBID_REGULATOR_INFORMATION] & "?a=API_GenAddRecordForm&_fid_95=" & URLEncode ([ProjectID#])& "&z=" & Rurl()
    I saw Dan's Pastie about Save and Edit but it uses HTML and I don't know if I can use HTML with the above.


  • 2.  RE: Modify a button to save before adding a record in a separate table

    Posted 08-09-2017 20:19
    Try looking for a setting in the table where the button is under advanced properties, and check the box to Automatically Save when adding a child Record. That might work.


  • 3.  RE: Modify a button to save before adding a record in a separate table

    Top
    Contributor
    Posted 08-09-2017 20:31
    I set that after reading a post you did earlier about the benefit of that.  For some reason, using the above formula will not link back to the parent record unless it is saved first.