theyetti

Hi Derry, if I understood you correctly you want to view/edit the record that is selected in the portal in another layout? If this is correct place a button in the portal row and in Button Setup add the "GTRR" Go To Related Record" details. If this is not correct can you post more info or a sample file?

You could try scripting a Relookup Field Contents button based on your relationship field but this may be unnecessary. Can you explain more about what you want to do?

Hi All, I need create a new purchase order line item from a request for quotes line item record which already exists in another table. Currently I'm using the set field script step but because of the large number of fields that need to be copied this seems a bit long winded. Is there some way that I could easily create a new P/O line item record from the RFQ record detail. Most but not all of the field data needs to be copied across. I tried searching the forums but didn't find much, maybe I specified the wrong criteria? Thanks for your help, Cheers Peter -)

Thanks Comment, it's amazing what I can miss when I'm not looking in the right spot :-) Would it be handy for other users if this write information function feature could be specified rather than just one button being enabled? Regards Peter :-)

Hi All, I hope someone can help with this script as it's driving me crazy. My script has a custom dialogue box hat allows the user to enter the number of days the part is going to take to arrive and then set the EDD or Working Days EDD based on this. The EDD works fine but when I try to use the WD EDD the value entered is not passed to the No: of Days Field so no value is set. I'm not sure why as both script sequences are pretty much the same. I've attached a sample file, Thanks Peter :-) Test.zip

Hi, I'm very sorry I didn't mention the portal before, it completely slipped my mind until I was using the data viewer to problem solve. I'll ty some of your suggestions, I think I need to back off on the work load for a while, Thanks Peter -)

Hi mr_vodka, thanks, your suggestion worked on one but not the other. The one that is not working is actually a portal so it's returning the name of the active window that contains the portal not the source layout. I've had a look at the various function options but haven't managed to find a way around this. Cheers Peter -)

Hi All, at the moment I use an "If" statement in the "Set Variable" script step to utilize the same script on several different layouts. If ( Get(LayoutName) = "Stock Requests" ; Stock Requests::StockID_SK; Purchase Order Records::StockID_SK ) I would like to make the layout name change dynamic so what ever layout I am on is part of the value = set variable script step, is this possible? Eg. The value part is Stock Requests::StockID_SK on one layout but it is Purchase Order Records::StockID_SK on another. All the other script steps are the same for every layout. Thanks Peter :-)

Hi Robert, if you only need to show the current date for user reference you can use the text tool to display // anywhere on your layout which will show the current date. If the date field is to be used in a calculation, etc. you can also use the Get(CurrentDate) directly in your calculation. Cheers Peter :-)

Many Thanks Comment, it turned out that I only had one repetition specified on the main calculation field so it only showed the most recent value. Cheers Peter :-)

Hi Comment, I've tried using your suggestion but it seems to only evaluate the last P/O Line Item record created for each stock item? I've tried to figure out why this is but I'm not very familiar with some of the functions used. Could you post a small explanation about each step so I can learn from this? Thanks Peter :-)

Thanks for the ideas, I'll try them and see how I go. The individual purchase order line items use the StockID as a secondary key so are related to the Stock Items. Thanks Peter :-)

Hi All, is it possible to calculate the average price from the last three purchase orders for a stock item? I'm just not sure how to obtain and evaluate just the last three prices. Additionally some low use items may only have one price recorded for that item which makes it a bit harder. Thanks Peter :-)

Hi net2ride, thanks, I was also looking for some help with the DHL tracking address. I use a button with the Open URL function instead of the Web Viewer but it still works great. Cheers Pedro -)

Thanks to everyone for their ideas, I'll experiment with the ideas later on when it's less than 35 degrees Celsius :-) My script currently checks if a R/R exists first then branches from there, it's just using the find record step, etc. was a bit messy so I was hoping this could be accomplished in less steps. Cheers Peter :-)