Jump to content

X-Pert Pool

Members
  • Content Count

    14
  • Joined

  • Last visited

Community Reputation

-1 Poor

About X-Pert Pool

  • Rank
    member

Profile Information

  • Gender
    Not Telling
  1. Was I correct in the assumption of how FMGO handles connectivity differently? Meaning it won't have disconnection errors over cellular wifi? I personally would prefer to email invoices but some customers are elderly and I doubt they are computer savy. In your opinion though, if you hired a plumber or equivilant to come to your house would you expect them to email the invoice to you? I think a majority of people are still handwriting bills, the only bills that I'm currenly paying in a pure paperless fashion are utitlies, cellphones, and online shopping. I'd be suprised if someone cam
  2. It was hard trying to figure out which forum to post this topic, I hope this was the best choice. Let me explain my situation and hopefully someone can point me in the right direction. I run a pool company and I have been using a modified version of the john mark osborne solution. Basically its a database that keeps customers data and invoices. I'm using FMP11 to share the database to two laptops on the road also running FMP11. The laptops get internet connectivity from cell phone wifi hotspots. So I can go to a customers record make a new invoice add products and print out the
  3. How much work do you think it would be to add a payments table and change two of my products to have a calculated price based on the customers table? :(
  4. [i posted this yesterday but I chose the wrong forum] I'm switching my company over to paperless invoicing via laptops this year. It's a seasonal business and I've just learned of filemaker not to long ago and I'm starting to get busy again. I'm using the invoicing solution based on the VTC.com tutorials by John Osborne. Anyways, I've modified the solution to my needs and I need someone to incorporate a few features that I've been having trouble with and I'm basically out of time trying to figure it out on my own. Naturally I will provide my current solution with admin password so
  5. I'm switching my company over to paperless invoicing via laptops this year. It's a seasonal business and I've just learned of filemaker not to long ago and I'm starting to get busy again. I'm using the invoicing solution based on the VTC.com tutorials by John Osborne. Anyways, I've modified the solution to my needs and I need someone to incorporate a few features that I've been having trouble with and I'm basically out of time trying to figure it out on my own. Naturally I will provide my current solution with admin password so you can modify it. This work looks easy to me and wil
  6. What about a price that doesn't really change much? For example a 16x32 pool with a safety cover has a price of $200 and a 16x32 pool with a tarp cover is $10 more so it would be $210 having a tarp cover just really adds $10. But I wouldn't want to show that on the invoice, just include it in the price of the "pool opening" product price. would something like the price field in lines equaling "productprice * qty + coverprice" be a good idea assuming that if a customer didn't have a tarp cover that field would equal zero? Although I think this is something I tried to do bef
  7. that's okay. I understood now what you meant with lines2 my question is though the example your giving with fromqty. You are just giving a basic example of cost per unit reduction based on quantity right? Anways I was trying to figure out if I should add more fields into my prices table for example the price would change based on the square footage of the pool as well as the type of cover for example lets say the square footage was 392 or less it would be a price of: $207 with a safety cover and $217 with a tarp cover. Would this be possible with the curre
  8. If it's not too much of a bother could you visit the chatroom? It might make it easier for me to understand Thanks
  9. Sorry, things just have a hard time clicking once in a while.. So I have a link from prices to products via productID and I should link prices2 with lines by... Prices2Table>foreignkey_productsID to LinesTable>foreignkey_productsID ? I'm really sorry it all just gets so confusing sometimes. I'm trying to learn FMP and it seems like everytime I get something to work right I find another problem.
  10. my prices table has a primarykey for prices and a foreign key for products. Do i link the prices table to products table via the pricesID or the productsID? and what would the relationship link be between the prices2 table occurrence and lines?
  11. okay Just to clarify things I've got a table for products, invoices, lines, and now I need to add a table for products_prices right? and inside that table put something like this PriceID ProductID FromQty Price 1 18 0 100 2 18 500 50 3 18 750 40 4 18 1000 25 ... Or did you mean to get rid of / modify my current products table to work something like that? Sometimes I can't visualize how to link everything together. Thanks
  12. Thank you for the information, I'm going to try that. I hate to keep asking questions because I feel like a bother. If I do run into a problem I can't figure out on my own in the future is it against board policy to offer payment via paypal for hands on help with a solution?
  13. I'm trying to attempt to go the route you suggested with a new table for product prices. Please keep in mind though, I'm very new to filemaker and sometimes get stuck on relatively easy tasks (for example I got stuck once because I made a field a number instead of a calculation and wondered why it wouldn't show data automatically). Anyways I've made a new table with a foreign key connected to primary key of products. Do i need another link of keys between prices and customers table? I'm also a little confused on what to put inside the price field of products_prices. It's supposed
  14. I've been modifying John Mark Osborne's invoicing solution found at vtc.com I run a swimming pool company and what I want to do is modify the price of a swimming pool opening based on the total square footage of the pool in the customers record. I've tried making "swimming pool opening" as regular product with a base price and then made another field called "price_modifier" with a case statement that said if the product seleted was for the pool opening and if the pool was a certain size to return a number into the price modifier field. so for example if a pool was 500 square feet
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.