gregorj

This one has me scratching my head. I'm working on a touch screen, point of sale retail solution for a golf course. I need to generate a report at the end of a period of sales that summarizes the various "products" sold. There are 37 products, each with a PRODUCT NO., PRICE, QTY and DESCRIPTION. These are sub-divided into 8 logical groupings. On any given day there could be from 0 to over 50 units sold for each product number. The printed report summarizes the number of units sold as follows: NO. DESCRIPTION QTY PRICE Registration 001 Resident 2 90.00 002 Senior 0 0.00 003 Student 1 30.00 ** SubTotal ** 3 120.00 Greens Fees 101 Resident 9 Hole 12 168.00 102 Senior 9 Hole 9 90.00 ... (others) **SubTotal ** 96 1321.00 Gas Carts 301 18 Hole Gas Cart 13 362.00 302 9 Hole Gas Cart 9 142.00 **SubTotal ** 22 504.00 ( 5 other catagories, each with a catagory sub-total) Finally a Gross Total which is the sum of all sub-totals in units and dollars. ***TOTAL*** 168 2470.00 I imagine a script would start with sorting on the part no. field and the break field would be the catagory in which those specific no.s were placed. A subsummary report ?? I can't seem to get a handle on how to nail this one down. Help please.

Please give me the best way... a calculation on a field?... a script ...that will start me off at 1 at the beginning of the day, will increment by 1 for each additional record. Will show as a field in my daily report that is also printed and is deletable at the end of the day. Thanks

I just want to save the data from one day to the next in the form of an Excel spreadsheet. I will never have a need for the data generated that day to be used again in FMP it is history. Why I even need the record number field is so we will know thru the day how many transactions (customers} we have had and a summary report at the end of the day will show the transactions including a transaction number associated with each record. There is never a need to find on record number. I could even start with a fresh database for each day but I have tables as lookups that would have to be repopulated each day...not a good solution. Thanks

Your right, of course, I misspoke. I am actually using a transaction number that is auto-enter serial number and increased by 1 for each new transaction. It doesnt NEED to be a serial number just a auto enter starting at 1 and increasing by 1 for each new transaction. There could be 100s of transactions in one day but once the day is finished the data is printed, saved and done for. The next morning we start over again fresh with the transaction number back to 1, with a new date. This is a POS solution by the way. How would I set up a calculation/script that would give me the progressive numbers for each transactio and something else I can use to delete same at the end of the day? Thanks

I have a typical auto-enter unique serial number field in a table that has data copied and erased at the end of the day. The new day starts with a new record and I need to set the serial number back to 1. It would be better if this were done via a script but I could live with doing it manually. Thanks for your help

Sorry for the delay in getting back to the Forum. I was away. To respond to your solution, I have attempted to implement it but the specific nature of the task needs a solution that immediately warns the cashier thru a beep and a text message in the appropriate field that this member's card has been used earlier today. Again, a five digit barcode is scanned into the Customer_ID field which includes a "return". I have one script that immediately checks if the member has renewed his/her membership this year, that checks if the "Student must now renew as a "Regular" member, that checks if the "Regular" Member now qualifies as a "Senior" member at a reduced rate, that checks if the member qualifies for any "Specials and finally checks to see if the member is already on the course. This all happens in a flash and unless the transaction is part of a script that is interupted by a beep, and a text notification and a halting of the script, the cashier will continue to touch a transaction button before he becomes aware that there is a passive indication on his touch screen that he just screwed up. I need help in just the "already used card today" part on the script. My transactions table records the member number as part of a new record request so any script syntax would have to ignore the first appearance of that unique number for this date and only flag the cashier for the second appearance. Data is this table is erased at the end of the day so I don't even need a date check. Thanks once more for your help. Greg

I think this has to be generated by a script. When the cashier is finished with the last customer, (this is a golf course), the cursor is left at the Member-ID field for new input (the next customer). The reason we want to flag the card if it is used again today is that their are deadbeats even amoung golfers and it is not above them to "loan" their card to another player so he can play at a reduced members rate instead of a walk-on. So the card is scanned and the member-ID is inserted in the field. The cashier hits enter which is a scripted button that actually does about 6 different things and has at least 3 alerts that could be posted to the Profile Message field. This is all accomplished before the next scripted button it hit based on what the golfer wishes to do. Looking at your particular solution I see where its close but I'm missing something. If the card is swiped at the Main table and the ID exists in the entries table then a "Your a bad boy" message appears. However, if the card is swiped at the Main Table (mine is called Transactions) and this is its first use today, as far as I can tell, this transaction history never gets to the entries table. If, on the other hand, we use the entries table to generate the transaction, although this was the first time the ID number appeared in the table, the badboy message is generated. It also needs to be a script because the Transaction screen is loaded with buttons and text boxes. Not much room for adding stuff. Also we need to give the cashier 1 button to hit to refuse to allow the transaction (Clear Button) or allow the transaction to continue when the next button is hit. I'm sorry to be so long winded but I know there is usually more than one way to get the solution. Thanks Greg

This looks very promising. I have a button that is pushed after the member-ID is scanned in. This is touchscreen POS. The button goes to a script that is called MemberScan which goes thru a series of tests including Renewal status, Senior status, Fees schedule to apply and more. Based on what you show here, how would you script your segment so that when the card is used a second time on the same day an insert text could be entered in my ProfileMessage Field such as ;"This member number has already been used today! Press 1 to allow. Press 0 to reject." Thanks' Greg

I really tried to follow solution and set it up the best I could but with no success. I am just not advanced enough to put it all together. Let me tell you what I have so far: Added a Table called Swipe with 5 fields; Current Date Date Global Auto Enter Calc CurrentDate = Get CurrentDate Member-ID Text Already Swiped Text Primary-ID Text Timestamp Date Added a table called Swipe_Check with 3 fields; Member_ID Text Date Date Timestamp Date "Relationships" shows both tables with Member_ID relating to Menber_ID and Date relating to CurrentDate From this point on their are just too many ways I can get this wrong and I've tried a lot of them. How do I get a calc in the swipe table like the one you mention in your last line? You mention a calc field with a date result Date = GetAsDate(timestamp) This gives me an error massage "The specified field cannot be found" Wow, does flagging if the member uses his card more than once in one day have to be this involved? Many thanks for the time you spent on this. I need this solution real bad so please be patient with me. Thanks, Greg

Sorry for the delay in gettting back to you...I was away. Your solution really helped. Thanks a lot. Greg

Without using a find routine, how would the syntax of my calculation look for the following solution? A member has a bar-coded 5 digit unique membership number which is scanned in which becomes a transaction, date and time stamped. Call this 5 digit field Member_ID. We must keep track of this Member_ID during the day. He can only use the number once a day. If the card is scanned again later the same day, we must be alerted at the time of the rescan via a message to the operator. "Member has already used this card today. Allow? The key is to relate his usage to todays date. If he uses it tomorrow, its fine as long as he only uses it one time. This solution is in Kiosk mode...no keyboard...just a touchscreen. Not that that should make a difference. Thanks for your help Greg

Thanks for the prompt answer. I've looked at GTRR but I can't get it to work in this case. Let me flesh out the logic a little further. This is a golf course POS solution. The cashier has a Touch Screen with a hand scanner. A member usually shows a Member Card with a bar code. This is scanned in and the members vital statistics shows on the screen and starts the fees procedure. This has all been worked out. The solution I need is when a so-called member claims that they "forgot" their membership card but they memorized their 5 digit number. We have a field that displays the unique number when it is scanned in or it can be entered manually in the same field (member_ID) This is on the transactions layout. In order to check to see if the number submitted is in fact a valid member number, we need to access another table called Members. We then need to determine if the number is actually in the Members database. If it is not found then the cashier will see a message that the number is not valid, etc. etc. If I could get Copy/Paste to work, it is a simple solution. I get lost in GTRR as it relates to this application. Thanks again, Greg

This one has me sucking my thumb! I have a situation where I need to COPY a five digit field (CustID) in Transaction Layout. Then, Goto (Member Layout::Member Table). Enter find mode, select (CustID) field and PASTE. Then Perform Find. Problem is, it won't paste from the script! It will paste if I stop the script just before the paste step and manually paste the characters, so the copy part of the script works just fine. This however does not help because everything in this solution is scripted because it is in Kiosk Mode and no keyboard exists. Whats even stranger is that there is another case where the user needs to Copy/Paste the same characters but rather than Pasting the result into a find field, a New Record is requested. The paste function works just fine in this case. Exactly the same syntax other than going into find mode. I don't necessarily need to use Copy/Paste if there is another way to accomplish the task. I'm trying too determine whether this 5 digit ID number already exists in the member database. I have tried to use Set Field with no success but that may be because I have the syntax screwed-up, Please help. Greg Jones

I just want to thank both of you for leading me in the right direction. By no means do I have it all figured out but your suggestions are very helpful in me not only going forward but avoiding the snags and demons that await me around the bend. I'm sure I'll have additional questions, but until then...Take care. Greg

My confusion is in how to handle the logic and syntax of multiple branching events. I am developing a POS touchscreen system in Kiosk Mode for a golf course. No keyboard input. When a member's card is scanned it is entered into an edit box using: Insert Text[select;Transaction::Member_ID] Now I have a 5 digit unique member number. This in turn generates a 3 digit MTypeIDLookup number which indicates the type of price the member will pay when the transaction is selected. The member could be a Regular, Senior, Student and Others. Now comes my confusion...How do I script this? 1 - Has member renewed this year? If[Member::RenewalDate<01/01/2007] Renew Y - N If YES - then the member has to renew in order to play. This script ends and a renewal transaction is used to update the card. If No - then the member has renewed for this year and the script should go on to 2 2 - Has member used this card today? (This is to curtail misuse.) Transaction table has Member-ID field whereby the transaction is Date/time stamped. I'm not sure how to best test this test. If YES then I should have a Yes/No selection to override the trap. If NO then once again, the script should continue to 3. 3 - Check if using Weekday or Weekend Rates. The cashier has entered Weekday as Y or N in the Cashier Table::Weekday field. If N is in this field then the fees will be Weekend fees. (All fees are listed in a Fees table - The logic is as follows: Member::Member_ID generates thru lookup... 12345 Member::MType_IDLookup (3Digit code for price levels) 002 (Senior) Cashier enters transaction - 3 digit code Transaction::ProductType_ID 102 (Senior 9 Hole Rate) Lookup Price $16.00 Anyway, I can generate the lookups seperately I just have a problem scripting the logical seperate steps to smoothly arrive at the final endif. Thanks for your help. Greg