Miss A!
-
Posts
145 -
Joined
-
Last visited
Everything posted by Miss A!
-
Calculate Employee Sick leave accumulation
Miss A! replied to Miss A!'s topic in Calculation Engine (Define Fields)
Thank you comment, will attempt that.... Webko, do you have this implementation in Filemaker? If so, please share some light. many Thanks -
Hello Forum, Please assist me, i am struggling to get a working calculation for sick leave field, how to go about calculating how many sick leave days are due for employees if every employee has 30 sick leave days in 3 years, which will lapse if not taken. Can someone please point me in the right direction how to go about all this? Please ask if anymore question as i am also in an ambiguous situation. Many thanks, Miss Amen.
-
Date range calculation criteria
Miss A! replied to Miss A!'s topic in Calculation Engine (Define Fields)
Yohhh, got me clear now - Thank you Comment! -
Hello Forum, Can you please assist me with date range calculation for the following situation/problem/challenge: I have a date field = TG_StartDate and would like another field(Season(text field)) to display "HighSeason" if the date is between 15.08.**** and 14.11.****, that is from August 15th to November 14th all years, any year and the rest of the range display "LowSeason" Many Thanks, Miss-Amen!
-
Script does not look like it is running into any errors as per Script notification: FileMaker Server 14.0.2 on fmserver.packsafari.private reported the following event:2016-05-13 13:44:27.097 +0100 Information 150 fmserver.packsafari.private Schedule "Transport Invoices" completed.FileMaker Server automatically sent you this email. Contact the administrator if you no longer want to receive these notifications:P S <it@packsafari.com> Also running the schedule manually does not go for more than 3 seconds - it is like the schedule does not go through at all.
-
Hello Forum, I have scheduled a script that i expect to search for a running tour(on current date) and creates and invoice for that tour. The server gives a notification that that script ran but when i check the database, there are no records created. Also the script ran just fine initially and suddenly that began to happen, without any alterations. Anybody aware of a situation like this with server scheduled scripts and have an idea how to fix this. Thank you for your time and support. Miss-Amen.
-
Script to access data in another file
Miss A! posted a topic in Script Workspace and Script Triggers
Hi Forum, I am working on a script to be triggered when a field is modified so that it can pull data and update fields on a layout. Some data is in another file and i do not know if possible how to access this file and search for the data i need? Any thoughts on how to accomplish this? Thank you for assisting, Miss-Amen -
Hi Forum, Please help me solve a calculation for this problem, i have a table with various records, i would like to implement a field called Order_Check that would display a "1" if the table field Order_Num begins with "PT00" if otherwise it must display "0". This field Order_Num for invoice records appear to be either empty, has value ID that begins with PT00* or just have some random values, i tried the calculation: IF(Order_Number = "PT00*", 1, 0) Thank you for assisting, Miss-Amen!
-
Hello there Forum, On a filemaker 14 platform, i have a server scheduled script that goes through records and making use of the email field in order to send a Home Sync reminder to staff using SMTP, since its implementation it ran normal until very recently with no alterations on our system, i noticed there is an error in the schedule list for this script, i tried running script manually and i get an error message "Emails could not be sent successfully" also the email does not go through at all, that is none of the persons intended to receive it gets to receive it. Anybody have a solution to this problem please to assist me, Many thanks.
-
Hello Forum, Anybody with a solution or understanding as to why FM crashing when browsing records on layouts that have container fields?
-
Hi there, I have a field that has been altered for more than 100 000 records to the same value, it is a number field - I would like to know if it is possible to restore the old values for this field from a latest backup, importing only for this field. please help and many thanks, Miss Amen
-
Users can not view or access Calculation fields
Miss A! replied to Miss A!'s topic in Security Concepts
It is working now - Had missed the *Grant Full Access Privileges* on my new record creation script. Rgds, Saima-Amen -
Users can not view or access Calculation fields
Miss A! replied to Miss A!'s topic in Security Concepts
The other tables(Vehicle Rates 2015 and Vehicle Rates 2016) are in the file Transport Remmitance,
-
Users can not view or access Calculation fields
Miss A! replied to Miss A!'s topic in Security Concepts
I mean user is unable to work with the data contained in the table, they can create new records and populate their fields but the calculation fields do not calculate at a all, the remain blank and can not be entered. I have a vehicle rental price calculator, when the users enter this layout, i want them to specifies values e.g End date, start date, select a rateID(Is a value list), # of passenger and the KM driven - High season and Low season values depend on a particular rateID selected, The field Total is calculated from the high and low Season values by the High and low season days plus KM rate by KM driven - but this calculation is not going through for the users i intended to make use of the calculator.
-
I have a layout based on a particular table with fields from a table in another file through a relationship - I have full access and hence can access and edit fields, other user with custom privileges are unable to access or edit this fields, but can create records, i have tried editing the privileges on this tables for this users but still no change - what could i be missing? The table name is Rental_Calc, i have attached screenshot for the set privilege. Thanks for your help! Miss A!
-
The Files are on the server, and no the mode is not Find - Also it is happening not only in one file but on other files as well that this one user has access to- and only this one user is experiencing this problem.
-
Hello there - Somebody please help me..... I have a user who is experiencing problems with data entry on the database - when she re-opens the database, the information she has entered is missing. Anybody experienced this problem before? Please share ideal solution if any - Welcome any further question there may be. Many thanks, Miss A!
-
Hello, Please explain to me this piece of my problem - attached screen short. In the relationship captured, i would like to represent the Sub projects in a portal on the MainProjects layout - If i set the mainID field in Subprojects to be auto entered (number), the Fork end disappears, but when i remove this condition, the fork end is there but also the portal does not show the subs - How do i enable this condition such that through that relationship, there will be many sub projects in the subProjects table that i can represent on a portal on the main projects layout?
-
Hi Eos, I still struggle - how do i enable the relationship link for a one to many, when i am joining my TO's i still get only a one to one relation - How does the structure define a one or a many relationship for which side?
-
In the attached structures, one project has many tasks - what i want and don't know how to go about it is: to have another table that will have Sub-Projects so then that each project in the Projects table can have one or more Sub Projects - Then the Sub projects can have one or more Tasks. I am thinking then to create a Table(Sub Projects) and insert the Sub Projects TO between the Projects and Tasks TO's. This will mean breaking the existing relation between Projects and Tasks. Already there are records in Projects as well as the one or more Tasks related. I am worried that this exercise could destroy the relation of the Projects and their particular tasks. Thank you for assisting further.
-
Hello, Can somebody please advice me on what will happen to my records in a related table if i delete the existing relationship in order to insert a table in between? Or what and how possible a solution if i would like to add another table as a join? Many Thanks, Miss A!
-
Use radio button set instead of checkbox set.
-
Server Scheduled Script out of order
Miss A! replied to Miss A!'s topic in Script Workspace and Script Triggers
Hi Kris M, I am not using a global field for the find, only for storing found Tour Numbers which i then send out in the email. BTW - This script was fine a few months back until we upgraded to FM14 - Could this have anything to do with something? -
Server Scheduled Script out of order
Miss A! replied to Miss A!'s topic in Script Workspace and Script Triggers
How does global affect performance even when the found set is zee - why not exit the script, instead it continues to loop through all the 332 records in the list for the Tours, plus it takes time when i observe on the server even on zero records found......I do not get it! -
Server Scheduled Script out of order
Miss A! replied to Miss A!'s topic in Script Workspace and Script Triggers
Hi Wim, i tried your suggestion but problem remains. Hi Kris, No Triggers at all, The script is suppose to pass the first IF for no records found and just exit, but it don't do this - But in the Debugger it does just well.
