ContributionsMost RecentMost LikesSolutionsRe: URL Formula to open file attachmentUnfortunately when I do that, the URL quits working.... I didn't change anything else at all! would it be possible/easier to use an icon?Re: URL Formula to open file attachmentBeautiful! Works perfectly - is there any way to get it to show up as a button?Thank you!!URL Formula to open file attachment Ok - I may be missing something easy here, but I need help. I have a file attachement field that may or may not have a pdf attached. Is it possible to have a URL Formula (so I can have a button) that will show up only IF there is an attachment and the URL would be a link to that attachment? If it's not possible to have it show up only if there is an attachment - what would the formula be to link to that field either way? - I know there is the link that is the file name, but I really just want it to show up as a button. Thanks! Re: Use the Image Onload Technique to redirect to a specific report - or some other method.I have answered this with some amazing help from Dan Diebolt and his techniques using javascript. I want to say this in earnest to anyone who may be in a similar situation as I am...our Company has grown rapidly and we are working to improve and expand our Quickbase along with it.We have requirements and ideas outside of what the native Quickbase function allows. I am learning and now know that there ARE ways to do just about anything you want or need to do in Quickbase. **It will be worth your time to explore and learn what Dan is teaching with his Image Onload technique and other methods of employing javascript within your QB pages.Instead of chasing these patched together formulas that are time consuming and difficult to figure out, you can have a quick, efficient answer. I went from the convoluted attempt you see above to now having my solution and it is literally accomplished on 2 lines of javascript and has no more than about 20 characters.. I also have a plethora of other possibilities I can now explore. THANK YOU, Dan!!Re: Use the Image Onload Technique to redirect to a specific report - or some other method.I'm sorry - was that an answer to my question?Use the Image Onload Technique to redirect to a specific report - or some other method.I am trying to accomplish something with either the Image Onload Technique - or via my Formula URL, using an icon as a button. I have a parent table where the user clicks a button to add a "detail" on the child record. Once that window opens, they will fill out specific information, and then of course save the record. What I WANT to happen, is for them to click on the Save Button/Icon, and it saves the record and then puts them back on the original parent record they came from - OR a specific report could work also. An alternative could be:They click on the save button, it saves and then closes the window they are on. What I have now - I have a button that they can click to save and it keeps them on the same record.I also have working the Image Onload Technique that will save the record and then redirect to the homepage of the app. I need to either redirect to the homepage of the app, or have it close the current window.Can anyone help me with that one last step?? Here is my IOL code: $("#RedirectURL").val(gReqAppDBID); $("input[name=rl]").val(""); Here is my button code: var text URL = "javascript:void(DoSaveAdd())"; var text URLtwo = URLRoot() & "db/" & [_DBID_APPOINTMENTS] & "?a=dr&rid=" & ToText([Related Appointment]); var Text Image = "<a id='saveButton' class='Vibrant Success' onclick='DoSaveAdd()' href='#'>Submit</a>"; "<b href =" & $URL & URLEncode($URLtwo) &">" & $Image & "</b>" Thanks in advance for any helpRe: Text Formula URL to open external webpageI got it!! Here is what I did "https://MY.quickbase.com/db/bxbxbxbxbx?a=dbpage&pageID=7&rid="&; URLEncode([Record ID#])&"&company="& URLEncode([Company Name for URL])&"&time="& URLEncode([Date and Time for URL]) Works beautifully nowRe: Text Formula URL to open external webpageyes, rid - ... what I am trying to do - I have this in an email with html:"<a href="https://MY.quickbase.com/db/bxbxbxbxbx?a=dbpage&pageID=7&rid=[Record ID#]&company=[Company Name for URL]&time=[Date and Time for URL]"> it works fine from the email - but if I try to make a button out of it ... it doesn't pull the information from the fields in... that's the part I need help withText Formula URL to open external webpageI want to create a formula text "button" that will open a specific html page I have built in QB - this URL also passes information from some of the fields in the table it sits on: This is what the URL looks like: https://MY.quickbase.com/db/bxbxbxbxbx?a=dbpage&pageID=7&aid=[Record ID#]&company=[Company Name for URL]&time=[Date and Time for URL] I'm having trouble getting it to work - and it's probably something silly I am missing. Thanks in advance for any help!!Automatically create child record when parent record savedIs it possible to, when my parent record is saved, have a formula that will (if a specific field has been updated), automatically create a child record on my related child table, populated it with the data from that field and then save it (without the user having to hit Save manually) Thank you in advance!!