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.
Login name: admin
Thank you in advanced.
By Steve Martino
Hello Forum. I had some basic questions (for starters) about a report I am trying to create:
1. Can this type of report be created?
2. Can you point me in the right direction.
I have the following tables: People connected to both Readings and Sessions with the usual primary key-foreign key relationship
I would like to generate a report for a person, with 1 Reading record, then Session records after that Reading record timestamp, then another Reading record, etc.
So basically it would look like this:
August 1 9:00:00 am (Reading record)
August 2 10:00:00 am (Sessions Record)
August 3 10:00:00 am (Sessions Record)
August 4 10:00:00 am (Sessions Record)
August 5 10:00:00 am (Sessions Record)
August 6 9:00:00 am (Reading Record)
August 6 10:00:00 am (Sessions Record)
August 7 10:00:00 am (Sessions Record)
August 8 10:00:00 am (Sessions Record)
August 9 10:00:00 am (Sessions Record)
I've researched and used the VL technique, but didn't see an example that matched this. I could do it with 1 Reading record and multiple Sessions records, but not multiple/multiple.
If it is possible, I just don't know where to start. I've considered another TO where all the records reside, basically creating them in the order I need them for the report, but that's more like the VL.
If I want them all to line up it would be easier, or do I just do a VL report, and as I'm appending the records, if they are Session records, just add a tab space?
Just need some pointers.
I have a business unit within my company for whom I set up a quick time tracking database about 6 months ago based on the time tracking system that my business unit has been using for years. After their "pilot" usage, they sent me back this graphic of what they want the interface to look like. It's a spreadsheet. Really. I'm super frustrated. I don't even know where to post this. I don't know why they don't just use a spreadsheet if they want a spreadsheet.
What I would like to do (after my top 3 completely unprofessional responses) is either refer them to an existing product that someone has already developed that looks like this OR find out if there's a relatively simple way to set up something like this in FileMaker. Did I mention this is all a "favor" that I'm expected to do at no cost, and aside from my normal workload? Right now I can't even begin to wrap my head around how to do something like this. One record with the Project, Task, Notes, and then one field per day of the week for hours to be entered?
Grateful for any suggestions!
I am examining a demo file. The field SportName uses a curious auto entry calculation. Let[Trigger=SportCategory;""], where SportCategory is another field in the same table. What's the purpose and what does it mean? Being auto entry, I thought it only effected new records.
I have a script that is supposed to open a URL. Instead, it opens a folder on my desktop. Two script steps: Enter browse mode; OpenURL. The field that the script uses is a text field and contains the web address that starts with http://. Why should it be opening a folder? I can't find a setting anywhere to control this.
Who Viewed the Topic