Jump to content

Kishan_Canoo

Members
  • Content Count

    39
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Kishan_Canoo

  • Rank
    member
  • Birthday 11/23/1977

Profile Information

  • Title
    Head of Sale
  • Industry
    ICT
  • Gender
    Male
  • Location
    Mauritius

FileMaker Experience

  • Skill Level
    Novice
  • FM Application
    12 Advanced

Platform Environment

  • OS Platform
    Windows
  • OS Version
    10

FileMaker Partner

  • Certification
    Not Certified
  • Membership
    FileMaker TechNet

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I would like to have options to enter either fields (selling price or margin) and the other should be automatically calculated for instance: Cost Price = 100 (Available) Sell Price = Calculation field or ?? Input amount Margin = Calculation field or ?? Input percentage If i put 160 on sell price it should automatically put 37.5% in margin or if i put 37.5% in margin field it should automatically fill sell price for 160. File uploaded Login name: admin No Password: Thank you in advanced. TEST.fmp12
  2. Generally the user will create one record for one car and fill all informations and then duplicate the record to 365 records = 365 days. On the calendar View as attached you will see all the dates have been booked.
  3. I have a car rental solution and for rental of short term one to two weeks i just need to create a new record one by one which will appeared in my calender View layout via Portal. In case, the customer decided to take the car for one year, i can't create 365 new records, It their any possibility to create 365 records automatically by selecting Start Date to End Date? Thank you.
  4. comment you are the best Your solution worked fine. Thanks a lot.
  5. I have 3 fields and the first field is Amount the second field is Deposit and the third field is Balance. Generally my calculation should be Balance = Amount - Deposit If i insert the Amount, example $100 and the Balance automatically changed to $100. I need the Balance remain empty unless i insert a number in the Deposit Field. In my outstanding due report, if their is no Deposit, the Balance field should remain empty. Any help.
  6. Hello Win, Thank you for the general notes. Kindly find attached. Thank you. Flexi V3.0.fmp12
  7. Hi, In an existing solution one of my client my client has requested to add a field name ‘Item Movement’ (e.g. Best-seller, Fast, slow) and this should be based on a formula per product item and linked to 'Stock re-order level’ field. For example, if product A reaches ‘Stock re-order level’ in less than one month, it is categorized as ‘Best Seller'’. If Product A reaches ‘Stock re-order level’ in 2 months, it is categorized as ‘Fast’. If Product A reaches ‘Stock re-order level’ after more than 2 months, it is deemed ‘slow’ Since it’s depend on a date, I found it a bit complicated. Any help will be most welcome. I have attached my solution and i have the following problem. When i create a new product the Item Movement set to Best Seller and it should be a New Product instead. Secondly, the Item Movement status doesn't change when the date is being changed within the set value. If a product was in best seller and the is no more available will the status remain the same? Thanks for your help. Flexi V3.0.fmp12
  8. Thank you all. That works as expected. My problem is solved now.
  9. I have a field, ‘CRM Category’ (I.e. Diamond, Gold, Silver) for B2C End Customer – and another field for Total purchase over last 3 months – Calculation - If customer purchases for Rs 10,000 over last three months, a Diamond Customer, If customer purchases Rs5,000 over last three months, Gold customer. If customer purchases less than Rs5, 000, silver customer My question is for the calculation of the Gold customer as for the Diamond i will use the grater symbol and for Silver the less symbol. Case ( Total_Revenue < "$10,000" ; "Diamond") Thank for your help
  10. Hello Wim, As per attached you will see a script created for the current date transaction an it works fine. Now based on the result i need to get the current account name which is admin on the same script. Thanks for your help.
  11. I have a stock module with two fields one Stock Re-order level and one Item Movement. Based on the item sold i want the item movement to be changed automatically for example: ‘Item Movement’ (e.g. Best-seller, Fast, slow etc.) should be based on conditional formula per product item and linked to 'Stock re-order level’. For example, if product A reaches ‘Stock re-order level’ in less than one month, it is categorised as ‘Best Seller'’. If Product A reaches ‘Stock re-order level’ in 2 months, it is categorised as ‘Fast’. If Product A reaches ‘Stock re-order level’ after more than 2 months, it is deemed ‘slow’. Is there any possibility to automate the process?
  12. I have a pos solution, i need to create a balance report based on current date and cashier account name, so as to be able to get the total balance before check-out at the end of the day. I have created a button CASHIER CHECK OUT and at the end of the day the cashier can check physically his income and the balance on the report figure equaled. Any idea i can automate this process via an script?
×
×
  • Create New...

Important Information

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