ContributionsMost RecentMost LikesSolutionsRe: Bar Code UsesYes, thank you! That gives me a good direction. I appreciate the help! Mike ------------------------------ Mike michael.rorstad@ameebay.com ------------------------------ Re: Bar Code UsesJohn, thank you for the ideas! I can definitely see the QR code getting damaged, especially on tools like torque wrenches. Can you please give an example of the formula in the button? I'm having a hard time wrapping my head around how to make use of the barcode once it's scanned. Regards, Mike ------------------------------ Mike michael.rorstad@ameebay.com ------------------------------ Bar Code UsesHello all! I found a useful app in the Exchange for making and reading QR and barcodes at App Detail (quickbase.com). I'm trying to use this for our calibrated tools inventory. We have a unique identifier for each tool. I'm able to use the rich text formula function to create a bar code or QR code for each of the tools. What I'm not sure of is how to put that into use. I want to be able to scan the code and then check the tool out (either for use or for calibration and testing), and then check it back in (either after use or to document its calibration). Does anyone have an example of something of that nature that I can try to implement? Thank you! Mike ------------------------------ Mike michael.rorstad@ameebay.com ------------------------------ Need Help With Parent Child RelationshipsHello QB Community! I am trying to find a way to add a record in a child table and include the relations to the parents' and grandparents' records. This is an example of the structure. We have multiple jobs in the Jobs table. Each employee is given the authorization to charge a certain number of hours against that job number. That is done through the table-to-table relationship "Add Authorization" which creates a record in the Authorization table. Each day, there is a daily report that the job site manager is summarizing in the daily report table. That is done through the table-to-table relationship "Add Daily Report" which creates a record in the Daily Report table. From that record in the Daily Report table, the job site manager has been entering the people who worked on that job and the number of hours they worked through the table-to-table relationship "Add Hours Log" which creates a record in the Hour Log table. Summary reports are used up the parent-child links to give a status on each job on how the labor hour consumption is going on each job. I would like to add the ability to enter hours in the Hour Log table directly but when a new record is created in the Hour Log, I can't figure out how to input the related Daily Report number and the related Jobs number. Can anyone help me with this? Thank you, Mike ------------------------------ michael.rorstad@ameebay.com ------------------------------ Re: URL LanguageYahtzee! Thank you very much!!! ------------------------------ Mike michael.rorstad@ameebay.com ------------------------------ Re: URL LanguageThanks Laura! I'm almost there but had a snag. My Parent table alias is _DBID_JOBS and I used [JobNumber] as my reference field. the formula isURLRoot() & "db/" & [_DBID_JOBS] & "?a=dr&rid=" & [JobNumber] When I click the link, I get an error message, "Job Not Found, It has probably been deleted. If you followed a link to get here, you may want to inform the author of that link that this job no longer exists." I tried a number of the other fields in the reference field part of the string but kept getting the same error message. ------------------------------ Mike michael.rorstad@ameebay.com ------------------------------ URL LanguageI am trying to find a good tutorial that will help me to create a button to return to the related record in a parent table. I see some discussions in the Community but I don't know the language. Is there a tutorial on the URL formula language? In the short term, I want the button, but in the long term, I want to learn this so I know what's going on. Thanks! Mike ------------------------------ Mike michael.rorstad@ameebay.com ------------------------------ Re: Is an automation the best way to tackle this?Sharon, Thank you for getting back to me! I was able to figure out how to use the snapshot for calculating a balance in a checkbook, and I can definitely see the problem you pointed out about incorrect transactions and the historical values. I was trying to use the bank account scenario to learn how to get a running balance, but my real problem is a bit more complex. I have various jobs that have a certain number of employees assigned to them with a certain number of hours authorized for each employee. For example, Job 1 has Joe and Anne assigned and each of them is authorized to charge 80 hours of regular time and 10 hours of overtime. The main table is the Job Log - there will be numerous job log records I have a one-to-many relationship between the Job Log record and a table called Time Authorization Table. I have a one-to-many relationship between an Employee Roster table and the Time Authorization table. From the Job Log table, I can push the "Add Employee to Time Authorization" button andthe number of RT and OT hours can be added. For each day that a job is being performed, we have a daily report where the employees that worked on that job during that day, and how many hours were spent on that job is listed. I am trying to get the running balance for each employee on that job at the end of that day to be displayed on that daily status report. ------------------------------ Mike michael.rorstad@ameebay.com ------------------------------ Re: Inventory On HandI'm very anxious to see if you get a response. I'm trying to do something similar and can't figure it out. I think it may need an automation so I've been experimenting with them but no luck so far. Good luck! ------------------------------ Mike ------------------------------ Is an automation the best way to tackle this?Hello, I am trying to solve a problem and I believe automation may do the trick. I just don't know how to do automations very well. An example of what I'm trying to do is similar to a bank balance. If I have a Bank Account table that has a related Check Book Table, I want the remaining balance to be calculated for each time a record is completed in the Check Book Table. Is this best done by an automation or is there another way to do this? Thank you, Mike ------------------------------ Mike michael.rorstad@ameebay.com ------------------------------