
fishma
Members-
Posts
77 -
Joined
-
Last visited
Everything posted by fishma
-
I currently live in Charleston. I have sent you a resume. If you do not receive it, please let me know. BTW - Chuck Norris checks to see if I'm under his bed!
-
Set up a a constant relationship. In the two files you want to relate together, create a constant key,... define a field as a calculation, = 1, defined as a number. Create the relationship in the file you want to push the information from. In the table where you have the stored data, set the stored value into the related global field. You now have the data at your disposal. Note that there are several ways to get this info, but this should suffice your needs and shows one way to utilize a constant relationship.
-
'g_n_' just the naming convention I use. The field should be defined as a Global Number field under your field definitions. You may name the fields whatever suits you best.
-
There is a plug-in available at... http://www.your-filemaker.com/
-
No prob...
-
Easy Way to Rename ALL files in Filemaker solution
fishma replied to rwfresh's topic in Script Workspace and Script Triggers
You need to use the FileMaker Developer Tool which comes with FMPDev. It should be listed in your Program Files. Then select the Rename Files and Update all external links selection. -
For a one to many relationship, a field definition is not a good way to solve the problem. I would script the change of the status and set the new status into a text field in the Main table.
-
Excellent...I'm glad you got it to work.
-
In your main file you are relating to the child record... Case ( related::Policy_Active_Inactive = "InActive";"Holding"; related::Policy_Active_Inactive = "Active";"InHouse Review"; related::Policy_Active_Inactive = "Closed";"Closed") Note that this only works on a 1:1 relationship (main:child) If you have a 1:many relationship you will need a more complex definition.
-
Run the same Case statment on the related field in the main table. SetField["relatedMainStatusField", Case ( Policy_Active_Inactive = "InActive";"Holding"; Policy_Active_Inactive = "Active";"InHouse Review"; Policy_Active_Inactive = "Closed";"Closed") ] Make sure you run this Case statement before you change the Policy_Active_Inactive field Case statement.
-
SetField["c_Large_Image_Path", "Substitute ( Image_Path:, "file://X:/images/M/", "file://X:/images/L/")"]
-
Easy Way to Rename ALL files in Filemaker solution
fishma replied to rwfresh's topic in Script Workspace and Script Triggers
If you do not have developer, you can solicit the services of a developer who does have it. Should be cheap as it only takes a few minutes. -
SetField(g_n_counter, 10) SetField(g_n_field1, 1) SetField(g_n_field2, 1) SetField(g_t_field1, ""data you want"") Loop NewRecordRequest SetField(field1, g_n_field1) SetField(field2, g_n_field2) SetField(field3, g_t_field1) SetField(g_n_field1, g_n_field1 + 1) SetField(g_n_field2, g_n_field2 + 1) SetField(g_n_counter, g_n_counter - 1) ExitLoopIf(g_n_fcounter = 0) EndLoop My shorthand is as follows g_n_... = global number g_t_... = global text
-
If you know what field has been changed, you can use the script step GoToField. It shouldn't be too much of a hassel because if your marking an x next to the field which has been changed, you know which field to return to.
-
You must loop through the entire text field word by word. Evaluate each word as you loop through and rebuild the "selected text" by evaluating the length of the word. If the length of the word = 1, do not add it to the rebuilt "selected text", else add the word to the rebuilt text. You probably should use global fields to complete the evaluation. Keep in mind that text parsing is tedious and difficult. But it is one of the keys to becoming a professional.
-
Adding multiple records to a table at once
fishma replied to Boto's topic in Script Workspace and Script Triggers
Set all the IDs individually into individual global fields. Each selection sets the correct ID in to the correct global ID field. The information is then at your disposal. -
When you call a backend script from the front end, the script must be completed on the backend before the front end is released (i.e. unfrozen). There are some tricks to getting around this problem, but you will need another workstation to perform the task (requires a plug in as well), or you need to schedule the backend tasks for off peak usage hours (scheduled tasks will not update the data until the task is run). The best suggestion is to re-examine your backend tasks to find ways to speed these tasks up.
-
Much faster. In the case of calculating totals, scripts run faster than calculated fields.
-
You can set up a Global text field in the File in which the error occurs and set all the information into the global field, and then copy all the information before you move to the Errors File. Keep in mind the global field must be present on the layout if you want to copy the information it holds. The best way to do this is to set up a constant relationship, and pass the information through an external script. You can then use the SetField function, and the field does not have to be present on the layout. In this example, your user never leaves the Layout where the error occurs, and you capture all the information you need on the layout where the error occured.
-
Collecting data from same field in a found set.
fishma replied to Mac3danim8's topic in Script Workspace and Script Triggers
Create a layout with only ht NAME field on it (list view) Goto that layout Copy All Goto Layout containing the container field Paste Viola! You are limited by the 64,000 character issue. -
Sorry Jon, It's early and I've not had enough Coffee. POP3it Receives emails, SMPTit sends them. Clark
-
You can use the SMPTit plugin (found here http://www.cnsplug-ins.com/products.htm?product=SMTPit ). I have used SMPTit and it's sister plugin POP3it to create a full-on email client. Both plugins are very solid. Keep in mind that you will need to understand how Exchange stores and serves emails. Good Luck... Clark!
-
Need help with summary report field
fishma replied to Eric Kelly's topic in Calculation Engine (Define Fields)
You need to add an additional Sub-Summary PART. See attachment... 91671-Revised.zip