ContributionsMost RecentMost LikesSolutionsTrouble PrintingI have a from using IFV=1 to limit standard controls. I want the user to be able to print before they submit the form, and when I start this process the record is in edit mode. Here's how I attempted it: var text URL = URLRoot() & "db/" & Dbid() & "?a=dr&ifv=1&printr=&rid=" &[DSR ID#]; "<a class='Vibrant Primary SaveBeforeNavigating' data-replaceRid=true \nstyle=\"text-decoration:none; background: #0863f5; border-radius: 5px; color: #FFFFFF; display: inline-block; padding: 4px 4px 4px 4px; width:140px; \ntext-align: center; \ntext-shadow: none; \nborder: 2px solid #0863f5; \nfont-size: 12px \"href='" & $URL & "'>Print DSR</a>" I tried putting the printr function towards the front like this, and it says "access denied" var text URL = URLRoot() & "db/" & Dbid() & "?a=printr&dr&ifv=1&rid=" &[DSR ID#] It does the same with display record first. var text URL = URLRoot() & "db/" & Dbid() & "?a=dr&printr&ifv=1&rid=" &[DSR ID#] If I remove the DR& entirely like this it prints to PDF, but the associated report details disappear and I get an output like the attached Printout-.pdf var text URL = URLRoot() & "db/" & Dbid() & "?a=printr&ifv=1&rid=" &[DSR ID#] Does anyone have a suggestion how to change from edit to display while retaining the IFRAME mode and still launch it into print mode? ------------------------------ Wade Myers ------------------------------ Remove the option to delete from a reportI want to remove the ability to check a box on a report and be presented with the option to delete. I don't want to do this everywhere, but just certain reports which are only intended to be a visual display on a from to represent data in a child table. I'm not looking to disable the ability of a user or a role to delete that record. I just don't want them performing that action from the particular report. ------------------------------ Wade Myers ------------------------------ Re: Branching to a page and returning, using Iframethat seems to work fine, but the Tasks assigned to this dsr get redisplay no-longer in grid edit mode ------------------------------ Wade Myers ------------------------------ Branching to a page and returning, using IframeI have a Daily Status Report (DSR) form which contains several rules, and 2 reports. one of those reports points to a TASKS table. Each record in the shows a "copy" button, which purpose is simply to duplicate the task in that row with all the same data. The DSR uses Iframe (launching the DSR Form using IFV=1) Problem: when you click the "Copy" button it does what it is supposed to by duplicating task, BUT it drops you back into the DSR form without the Iframe controls - basically it looks like any other form. The code looks like this: var text Copy = URLRoot() & "db/" & Dbid() & "?act=API_CopyMasterDetail&relfids=80&recurse=false©Fid=6&destrid=0&sourcerid=" & [Record ID#] var text DisplayDSR = URLRoot() & "db/" & [_DBID_TIME_CARD] & "?a=dr&rid=" & [Record ID# of Focus DSR]; $Copy & "&rdr=" & URLEncode($DisplayDSR) I tried modifying Display DSR by adding iframe in the end like this: var text DisplayDSR = URLRoot() & "db/" & [_DBID_TIME_CARD] & "?a=dr&rid=" & [Record ID# of Focus DSR] & "ifv=1"; The results were that it created the duplicate task, but the it gave me a message about not having permissions to that page, so I removed it. I'm looking for help on how I can modify the button code to bring the user back to the form in iframe mode. Thanks in advance! Side note: There is a token required on this app, but I didn't want to post that here. ------------------------------ Wade Myers ------------------------------ SolvedRe: I need a button to launch an external URL in a new windowThanks, and yes we had already done that since part of my app utilizes EOTI. ------------------------------ Wade Myers ------------------------------ Re: I need a button to launch an external URL in a new windowAustin, Thanks, yes I understand the behavior. I'm asking what the formula would be, or how to construct it. ------------------------------ Wade Myers ------------------------------ I need a button to launch an external URL in a new windowI know how to create a new field that appears as a button on the page, and opens a pop up window. What I seek help in defining is the actual formula to open an external web page - Origin-Based and Destination-Based Sales Tax Rate - TaxJar The purpose is purely to provided users with an external reference when adding a new Customer, so they can populate the tax rate that is applicable for the state in which the customer resides and the type of purchase (services, software, hardware, other). It does not need to integrate data or return anything at this point. I just want to open a new window with the website in it. Thanks! ------------------------------ Wade Myers ------------------------------ Re: Calculating for Nexus Thanks to all. That was very easy to set up. Wade C. Myers, C.E.O. LightSpeed PM Office - (502) 653-7410 | Cell - (502) 529-6145 Email - Wade.Myers@LightSpeedPM.com | Website - www.LightSpeedPM.com Certified Partners with: Quest Software, One Identity, Optimiz, Dell, SmartBear, Arcturus Certified on SAM.gov – Cage Code 87NX5 Re: Calculating for Nexus Thanks, both of you. I'll be looking this over probably tomorrow. My primary customer is doing a major migration so I'm being asked for a lot of validation info that will take my time. I just wanted to state that so you don't think I'm being unresponsive. Thanks again! Wade C. Myers, C.E.O. LightSpeed PM Office - (502) 653-7410 | Cell - (502) 529-6145 Email - Wade.Myers@LightSpeedPM.com | Website - www.LightSpeedPM.com Certified Partners with: Quest Software, One Identity, Optimiz, Dell, SmartBear, Arcturus Certified on SAM.gov – Cage Code 87NX5 Calculating for NexusPart of the rules associated with taxes (when selling products or services to other states) requires that you evaluate whether or not you have a nexus with the particular state which you are doing business with. My goal would be to build a table with all 52 states listed and have a simple check box next to any state where you have a nexus, and then associate it with customers, and use the information to feed down into quotes. so, for example if I have 6 customer total and 3 customers are also in Kentucky. The nexus check box next to Kentucky in the states table would be evaluated as true for the 3 customers. So, the first thing I need is a pointer to a stand alone table of US States if anyone has that. The second thing I need is help understanding how I would compare just the State sub field of the Address field of my Customers table. I'm pretty sure I need a many to one relationship, one state to many customers I'm a little foggy on how I set up that relationship and compare it. ------------------------------ Wade Myers ------------------------------