LandonSmallwood
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Save and New Button creation
I am attempting to streamline (by removing manual actions) our part tracking process for newly machined parts and am looking for a way to add a "Save and New" button to the body of the form that preforms the same way as the built in Save and New button. Each part after machining is etched with a QR code that contains the relevant data for the part. Current setup below allows the user to click in the Part 3D Scan box, scan the QR code on the part at which time the data inputted and parsed into the correct boxes then it auto tabs to the Save and New button and pushes enter. My issue lies with the functionality of the button. Using the code I found in this forum I can "Save and Edit" however I can not figure out how to modify the code in order for it to open a new record for entry. var text url = URLRoot() & "db/" & Dbid() & "?a=er&rid=%%rid%%"; var text link = "<a href='" & $url & "' data-replaceRid='true' style='font-size: 11pt;margin-left: 5px; margin-top: 0px; height: 33px; width: 160px; text-align:center;background-color:#13294d;color:white;background-image: linear-gradient(to bottom, #13294d 0%, #13294d 100%);' class='SaveBeforeNavigating Vibrant'>Save and New</a>"; $link Any suggestions would be appreciated.Average Rating of last 4 inspections/entries.
Is there a formula that can be used in a summary report to show the average rating of only the last 4 entries of a given part number? Current table is simple with 2 fields. A part number is selected through a relationship dropdown, then the selected part number is then given an inspection rating of 1, 2, or 3 based on inspection criteria, then saved. Background: I am attempting to setup the % of parts to inspect based on the average rating of the last 4 inspections. My issue lies in the fact that not all parts are delivered and inspected on the same schedule (i.e. weekly, biweekly, monthly, quarterly or biannually) so I am unable to use a time period to capture an equal rating across all parts. Without a formula that only captures the last 4 entries of a part number, I fear I will need to add and manage a dropdown of "delivery schedule" on 1000+ parts to allow filtering to capture the last 4 inspections completed. (or keep using the 15 spreadsheets that I currently track this information on) Any suggestions or work arounds would be appreciated. Thank You.Create Record based on Due Date of Task -7 days
Good Day, I have an Assets table, each asset requires preventative maintenance on a schedule of X days (30, 60, 90 days, etc.) after last completed. This creates the PM Due Date. In the same App, I have a Work Order table that assigns the task to personnel based on the Asset selected. Is it possible to automate the creation of a new record (work order) when the due date of the PM (Asset table) is approaching (7 days prior). Any thoughts are appreciated. Landon ------------------------------ Landon Smallwood ------------------------------Create Record based on Due Date of Task -7 days
Good Day, I have an Assets table, each asset requires preventative maintenance on a schedule of X days (30, 60, 90 days, etc.) after last completed. This creates the PM Due Date. In the same App, I have a Work Order table that assigns the task to personnel based on the Asset selected. Is it possible to automate the creation of a new record (work order) when the due date of the PM (Asset table) is approaching (7 days prior). Any thoughts are appreciated. Landon ------------------------------ Landon Smallwood ------------------------------
