DomDomQrew Trainee9 years agoFormula URL link text changeUpon clicking on a formula url button I need it to change the link text to something else from what it is set as. Any solutions?
12 RepliesReplies sorted by Most LikedQuickBaseCoachDQrew Captain9 years agoCan you post the code for the current formula? I may have an answer depending on the complexity of the URL.DomDomQrew Trainee9 years agoURLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=zyah96dfz2bmrrr9h5idzambes" & "&_fid_242=BlahBlah(another field)" & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])& "Javascript:'DoSaveAdd()'QuickBaseCoachDQrew Captain9 years agoSorry, I'm not sure of the format to make that into a hyperlink where an image could be used. The rdr tends to not work.DomDomQrew Trainee9 years agoI've used formula display as a button on forms and report, and set the link text as something. It works but I want the link text to change.DomDomQrew Trainee9 years agoformula URL*QuickBaseCoachDQrew Captain9 years agoYou cannot change the color by formula on a formula URL field. it would need to be a different field type.A low tech solution is to use two buttons and control which shows by formula and / or form rules.DomDomQrew Trainee9 years agoThat is the current solution I'm working with (two buttons) but its the link text not the colour of the button i.e. the text that I have chosen DomDomQrew Trainee9 years agoI want it to change from "Approve" to "ApprovedQuickBaseCoachDQrew Captain9 years agoIt's is not clear what your question is as I can't see them screen shot clearly. Are you trying to change the Link text or the action if the button?DomDomQrew Trainee9 years agoLink text
QuickBaseCoachDQrew Captain9 years agoCan you post the code for the current formula? I may have an answer depending on the complexity of the URL.
DomDomQrew Trainee9 years agoURLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=zyah96dfz2bmrrr9h5idzambes" & "&_fid_242=BlahBlah(another field)" & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])& "Javascript:'DoSaveAdd()'
QuickBaseCoachDQrew Captain9 years agoSorry, I'm not sure of the format to make that into a hyperlink where an image could be used. The rdr tends to not work.
DomDomQrew Trainee9 years agoI've used formula display as a button on forms and report, and set the link text as something. It works but I want the link text to change.
QuickBaseCoachDQrew Captain9 years agoYou cannot change the color by formula on a formula URL field. it would need to be a different field type.A low tech solution is to use two buttons and control which shows by formula and / or form rules.
DomDomQrew Trainee9 years agoThat is the current solution I'm working with (two buttons) but its the link text not the colour of the button i.e. the text that I have chosen
QuickBaseCoachDQrew Captain9 years agoIt's is not clear what your question is as I can't see them screen shot clearly. Are you trying to change the Link text or the action if the button?
Related ContentSecure Links & File AttachmentsSecure Links for Instant Access and Full ControlCoping with EntraID username changeLink to Record in Outlook PipelineCode Page Formula Button