Forum Discussion

ltduranltduran's avatar
ltduranltduran
Qrew Cadet
8 years ago

Is it possible to create a ""Save and Keep Working"" button from a formula URL field?

I realize the "Save and Keep Working" button was introduced by Quickbase, but I am wanting to add it somewhere in the middle of my form. I've seen posts relating to this kind of thing, but all of them...
APIs and custom code
Ask about Quickbase functionality
Forms
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
7 years ago
Put a Rich Text Formula field in the middle of your form with this definition:

"<div style='Vibrant Success' onclick=$('#footerSaveAndKeepWorkingMenuOption').click();>Save and Keep Working</div>"

When it is clicked it will trigger the clicking of the native Save and Keep Working button (even though it is not visible at the moment).  FWIW, this type of strategy of embedding JavaScript into a form which emulates a user clicking on a native features is safer than other methods of more directly invading the native markup and code.
  • ltduranltduran's avatar
    ltduranltduran
    Qrew Cadet
    7 years ago
    Thank you so much, this is exactly what I was looking for! HUGE help.
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    7 years ago
     
     _________________ < You are welcome >  -----------------        \          /\/\         \         \/\/          \        /   -\           \     /  oo   -\            \  /           \              |    ---\    -\              \--/     \     \                        |      -\                         \       -\         -------------\    /-\                          \        \-------/              ---/    \                           \                                  |\   \                            |                                 / |  |                            \                                |  \  |                             |                              /    \ |                             |                             /     \ |                              \                             \     \|                               -              /--------\    |      o                                \+   +---------          \   |                                 |   |                   |   \                                 |   |                    \   |                                 |   |                    |   \                                 |   |                     \   |                                  \  |                     |   |                                  |  |                      \  \                                  |  |                      |   |                                  +--+                       ---+
  • GauravSharma3's avatar
    GauravSharma3
    Qrew Commander
    7 years ago
    Hat's Off Dan! You will always be a Champ of this Community. :)

    Thanks,
    Gaurav
  • ChadBrandmire's avatar
    ChadBrandmire
    Qrew Assistant Captain
    7 years ago
    Is there a way to make that call the header button instead of the footer?
  • ChadBrandmire's avatar
    ChadBrandmire
    Qrew Assistant Captain
    7 years ago
    Nevermind. figured out what I needed to do.

    "<div style='Vibrant Success' onclick=$('#saveButton').click();><img width='100' src='_Image link Here'></div>";
  • GaryMcDonald's avatar
    GaryMcDonald
    Qrew Trainee
    7 years ago
    Not sure what the difference might be...but this worked beautifully in one of my applications right out of the box....but can't get it to work in another app?  I have looked at all the security setups and I can't see a difference between the apps?  What am I missing?  
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    7 years ago
    You are not providing any significant information to debug this other than saying one case works and the other doesn't.

    Can you copy each application and produce the same two different results? If so there is probably some subtle difference between the two formulas. Can you switch the two formulas between the two copied applications and reverse the outcomes? Post the formulas. What does "can't get it to work" mean - what happens?
  • GaryMcDonald's avatar
    GaryMcDonald
    Qrew Trainee
    7 years ago
    The Formula is as follows

    "<b><font color=Red><font size=6><div style='Vibrant Success' onclick=$('#footerSaveAndKeepWorkingMenuOption').click();>>>[Values have Changed. Click Here to Update!]<<</div>"

    This works in one application and not the other.  I copied the formula from the application that does NOT work into a new field I created in the table of the Application where the formula does work and added that field to the Main Form...it works perfectly there.  So I have two fields now where it works in one application and I can't get it to Save and keep working in the other application?  The Applications are set up exactly the same way from everything I can see?
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    7 years ago
    Your formula has some unbalanced tags and you are using ">" and "<" characters as part of the text. I may be possible that the HTML parser is getting messed up as there is different content on the pages of the two applications.

    Try using a stripped down formula in the application where it currently does not work:
    "<div style='Vibrant Success' onclick=$('#footerSaveAndKeepWorkingMenuOption').click()>Click Here</div>"
    The above is one line of text. If this solves the problem add your other tags one by one using balanced tags.

    Also make sure there are no spaces in the value of the onclick attribute as we are not using any quotes.
  • GaryMcDonald's avatar
    GaryMcDonald
    Qrew Trainee
    7 years ago