3 posts in this topic
I have a Layout in Table Mode as (partially) shown in the attachment.
(Note: First row will have a Country Code in it - not shown in attachment)
I want to "fill-down" the last country code in all rows (in the Country Field) UNTIL the country code changes. Then I want to similarly do it for that one. Until I reach the end of rows.
My database will grow from 500 to 10,000 rows of text/number data. I am uploading in batches from Excel.
Is this possible? I've tried various calculations and scripting without much success. Thanks!
I'm trying to get something like this:
By Peter Barfield
Hi all not sure if this is the right area for this post however,any Help appreciated
in a design that i am working on for a small point of sale i have an issue (or challenge)
the normal price is set as a Retail Price (all good)
however I have been asked to now fulfill this next part.
A Multi-buy concept.
so e.g. a bottle of wine would normally sell for $12.99
however there is a promotion where you can get 2 for $20 ea (or a breakdown of $10 ea)
Now I have put a field in inventory table for multi buys i.e. fields
1. a checkbox for whether it is a multi buy item.
2. a field which indicates the qty of item that is applicable as in the above example 2
3. a field which indicates the multi buy price.
4. A field which calculates the individual price as in the example above $10. (multi buy price / qty)
and just to throw a little more into it there is the possibility of a situation whereby it could be 2 OR MORE.
so I have created a field which is a further checkbox which indicates whether OR MORE is applicable or just the base qty.
I guess the question is how does one tie this into the POS where an item would usually under normal circumstances be scanned and price picked up from the inventory table
I am just a little lost on this. I thought of a script that checks for multi buy applicable then pops the qty and price into variables which could somehow be used back at the POS screenoveriding the "usual price". Then the issue of OR MORE came into play and that is just for me draining my limited grey matter.
or am i looking at this completely wrong and is there a possible better way ie use of a related table etc.
Any Ideas would be appreciated.
I hope this makes sense.
I am new to FM, coming to it from a SQL Server/Oracle/Access background. I have created a database with layouts and while there is certainly much more for me to learn it generally is working as I desire it. However, I need to perform a task that I do not understand how it would be done in FM. The example below is not my actual problem but does exemplify my core issue and hopefully is easier to understand than if I described my project.
I have a table of Users, a table of Entitlements, and a join table of UserEntitlements. I want to execute SQL that, for a given User, will read from the Entitlements table and insert rows into UserEntitlements for this user. The query will read from Entitlements, insert a row for every entitlement for this user and, based on data in Entitlements take, will mark some of the entitlements as 'active'.
Ideally, every time I created a new user this SQL would be called (I'd have it as a trigger in a SQL or Oracle database, or I'd have a batch process that ran frequently looking for new users). Basically, as a new user is created I want to create their entitlements profile and activate standard entitlements.
I don't need/expect a full answer - was just hoping I could get pointed in the right direction: is 'scripts' the area I need to explore? Is there a SQL capability to FM? I have not found it if there is.
Thank you for any assistance you can provide,
This may have been addressed before and I am very new to scripting in filemaker. Basically what I am trying to create is a script where I can find records from a carriage return separated list. I have created a field and a button to execute the script.
For Example: If I have 50 records for every US State, in the field I could put:
Thus populating just the 3 records.
Any help would be greatly appreciated.
I am running FileMaker 14 on a Win 10 machine. I have a set of records that each have a field with a starting number and a field with an ending number. I have to perform a find that locates the record where the find criteria is greater than or equal to the starting number AND less than or equal to the ending number. I need to write a script that will just let the user enter the find criteria in a edit box and then go to the record. This will theoretically be only one record that would match from the dataset. Can anyone point me in the right direction with this?