Custom Save and Close button
Hello everyone, This is probably a super simple solution but for the life of me I have not been able to get it to work. I am trying to create a custom button that simply saves the record on a form ...
Forum Discussion
It's actually a bit tricky to make a button. @Sharon Faust told us the trick here.
The issue is that if the only changes are to the grid edit child records and not to the parent record, the a button to redisplay the record will cause a pop up which will confuse the users. Also you want this to work on Add mode presumably too.
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: #4b7097; border-radius: 5px; color: #ffffff; display: inline-block; padding: 0px 0px 0px 0px; width:100px; text-align: center; text-shadow: none; border: 2px solid #030404; font-size: 12px \"href='"
& $URL
& "'>Save and Display</a>"
But this only works if the parent record was dirtied ( changed). So you can make a field called [dummy date / time field to force save] and then use a form rule to set that to the current date time at all times. That should dirty the record.
ie
when [dummy date / time field to force save] not equal to current date time ch age [dummy date / time field to force save] to current date time
be sure to uncheck that checkbox so it fires all the time.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
The issue is that if the only changes are to the grid edit child records and not to the parent record, the a button to redisplay the record will cause a pop up which will confuse the users. Also you want this to work on Add mode presumably too.
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: #4b7097; border-radius: 5px; color: #ffffff; display: inline-block; padding: 0px 0px 0px 0px; width:100px; text-align: center; text-shadow: none; border: 2px solid #030404; font-size: 12px \"href='"
& $URL
& "'>Save and Display</a>"
But this only works if the parent record was dirtied ( changed). So you can make a field called [dummy date / time field to force save] and then use a form rule to set that to the current date time at all times. That should dirty the record.
ie
when [dummy date / time field to force save] not equal to current date time ch age [dummy date / time field to force save] to current date time
be sure to uncheck that checkbox so it fires all the time.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Hey Mark, is there an easy way you can think of to get this to close the window/redirect back to the parent after a save? I'm trying to redirect it to my close window code page without success.
------------------------------
Elena Larrabee
------------------------------
Does this help? I haven't tried it, but looks promising.
https://resources.quickbase.com/db/bq8meiyhh?a=dr&key=21
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------Yeah, that's the code page I'm using. I got it working just making a button that redirects there and setting the records on that table to save on redirect. I was overcomplicating things. :)
------------------------------
Elena Larrabee
------------------------------
