Forum Discussion

Qrew Member

3 years ago

How to Create a Save and Refresh Button

Hi all, sort of flummoxed by this because I consider myself an advanced builder so am surprised that I can't figure out how to do this and the forums seem to be filled with javascript based suggestion...

ProcessQ

Qrew Member

Hi Mark, thanks so much for this but the formula throws out an error because in the first sentence of the formula the first % symbol in "%%RID%%" is highlighted yellow

Any ideas what this could be?

------------------------------
Process Q
------------------------------

MarkShnier__You

Qrew Legend

3 years ago

Sorry, I forgot the quotes.

"%%RID%%"

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

ProcessQ
Qrew Member
3 years ago
Hi Mark, now it highlights the "%%RID%%" and says "expecting number but found text" . any ideas?

------------------------------
Process Q
------------------------------
- MarkShnier__You
  Qrew Legend
  3 years ago
  ok try this, I've been on a bike all week and not on my regular computer .
  
  var text RID = IF([Record ID#] > 0, ToText(Record ID#]), "%%RID%%");
  
  ------------------------------
  Mark Shnier (Your Quickbase Coach)
  mark.shnier@gmail.com
  ------------------------------
  - ProcessQ
    Qrew Member
    3 years ago
    that worked, thanks mark, really appreciate it
    
    ------------------------------
    Process Q
    ------------------------------