DomDomQrew Trainee7 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 LikedSort ByMost LikedOldestNewestQuickBaseCoachDQrew Captain7 years agoCan you post the code for the current formula? I may have an answer depending on the complexity of the URL.DomDomQrew Trainee7 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 Captain7 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 Trainee7 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 Trainee7 years agoformula URL*QuickBaseCoachDQrew Captain7 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 Trainee7 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 Trainee7 years agoI want it to change from "Approve" to "ApprovedQuickBaseCoachDQrew Captain7 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 Trainee7 years agoLink text
QuickBaseCoachDQrew Captain7 years agoCan you post the code for the current formula? I may have an answer depending on the complexity of the URL.
DomDomQrew Trainee7 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 Captain7 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 Trainee7 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 Captain7 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 Trainee7 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 Captain7 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 ContentCreate a formula duration over 5 yearsPipeline trigger(s) based on formula field changesLooking for State abbreviation to full spelling formulaChanged To / Changed FromReport Link Unfiltered
Recent DiscussionsShare your feedback on the new Qrew DiscussionsExtrapolating nuanced dataSolvedGenerating QR Code with URL to recordFilter Monthly, Quarterly, Yearly from one Date fieldForms help