rwc.sheehan

So I'm trying to write a script (which will be run at login, or manually run...I'm not sure yet) that exports all records who ordered on a given day of the month (If today is the 20th of the month it will export every record with an order date of jan 20, feb 20, march 20, etc...). However, I run into problems when combatting the issue of months without 31 days. If someone orders on March 31, they will not be exported in April because there are only 30 days. Now, I came up with a potential solution where I just export all orders from 28-31 on the 28th and include a command at the beginning of the script that cancels it on 29, 30, and 31. But this got me thinking if there was a better way to do stuff on a monthly basis like this and fixing the 30/31 issue, instead of avoiding it like I did. Any help would be greatly appreciated as I am not a huge fan of the solution I came up with.

I have read through the topic of conditional pop up menus countless times and there are still a few questions I have about them. Can anyone help me out? 1) Do you need to have two tables in order to use setup a conditional menu? 2) Is it possible to use a value list that is based on the entries into a certain field as part of this conditional menu?3) Is it possible for the conditional menu to be located in a global field? Thanks. If anyone could help me out I can layout a much more explicit description of what I'm trying to do. FM 6/Windows XP

oh thats true...i was just trying to compare it to what had changed since last login date. however, you're correct. if i compare the expiration date to the date of last login that would make much more sense. i'll go ahead and try that. thanks

I am not currently but I could if necessary.

A little something that's been givine me a headache... I have a database full of records. The field active keeps track of which records are active, and automatically updates itself once a record passes its expiration date. I would like to know when any record goes sour so I can assess whether it needs to be renewed. I want to setup a script that runs at login(no problem there) that will check if any records have expired since the last time I logged in, and hopefully tell me which one (although that can be found out with minimal detective work if it cannot be scripted). Any takers on this one? I know how to setup a script to run at login but I don't know what functions to use. I've tried a few things but no luck so far. Thanks

well i'm importing from a txt file that was created by php programming (about which i know nothing because i did not write it, i am simply using the result of it)...but getting to the substitute function was the only part i needed. thanks ender

So I should most definitely know this by now, but its 4:30 and I'm burnt out right now so I'm having troubles. I wanna script something that includes using the substitute function to get rid of field names that were imported into a record. However, I can't even figure out how to use the substitute function as a script step. Any help? Thanks

I am doing this same thing and I have "perform without dialogue" checked. However, Outlook is still making me say its OK to send it. I know this is more of an Outlook issue but I was hoping someone could help me out. Clicking "yes" 138 times sounds like no fun.

Seems simple...I searched the forums but didn't happen upon it. If i have a field of check boxes using value list with an "Other" option...how can I get it to display what the user inputs?

ya thats all i came up with but i was hoping for an easier way cuz thats kinda a pain for me to go ahead and get an image ready for that...thanks though

much thanks,to both of you

So this might be a bit hard to explain but let me give it a go. I have a search interface in which you type the text you're searching for in a global field called "g_SearchText" and there's another global field (formatted as a pull down menu) called "g_SearchCriteria" where the user chooses in which field they will be searching. Now, in scripting the search I am trying to use the SetField function to put together a find based on the user's request. The function looks like this: SetField["g_SearchCriteria" , "g_SearchText"] Here is the problem that arises: When I use the SetField function to put the text from g_SearchText into the appropriate field, the function wants to set g_SearchCriteria rather than the field specified by g_SearchCriteria. Does that make sense? If not, I can post an attachment cuz this is really bugging me.

A little nit picky of a detail but how does one add those little arrows on the far right of a pop up menu or list? It's real useful for showing people that there's a dropdown menu there. Sounds way too easy for me to even have to ask this question.

My problem is that when I do said export, the field names are not exported along with the information. With a large number of fields being exported it is very cumbersome to have to go through and title each column. Is there a setting that I am missing somewhere or is this more complicated than I think? Thanks.

I want the text color of field X to be dependent on which of two values is present in field Y. It should be simple but I'm super busy right now and not thinking straight. Any Suggestions? Thanks

I've made a custom message with new options that pops up if a search returns no records. However, before this message can pop up, the default FMP one shows up. If I click "continue" it proceeds to my message. How does one go about suppressing the system's default message so that mine alone will show up. Thanks

any quick ways to do a data dump into excel for a simple pie chart or bar graph? when it exports it only takes the info from the fields themselves and does not include the field names (and it is quite time consuming to type each category up individually when you have 25 categories). any help?

ya, i think that's the direction i'm heading because i too am "thrifty"

Is there any way to do these in FMP 6? I know 7 has some built in features for graphs. Is there any way to do 'em in 6...maybe a plugin?

thanks. ya, i'm not entirely familiar with relationships and summaries, so i've started doing it the long way with calculations and totals. thanks for the help

but what if i want to find how many currently found records have a value of "y" for "field x"...sorry for the poor explanation

Possible? How? -or is it possible to count based on a field meeting a specific criteria (containing a specific value, not just any value)?

Lee Smith = spectacular...thank you so much

let me just start from scratch cuz i was confusing myself. i have a list of delegates to a conference, each in its own field so as to allow them to be coordinated with their home institution. i want to be able to search all the delegates fields without having to know which one a certain person's name may be held in. ie-record A has "n" delegates. john doe is delegate 7. when searching all the records to find john doe, i would like to be able to type it in one field and have it search in fields "delegate 1" "delegate 2"..."delegate n" sounds like it should be simple. i'm still learning a lot about FMP so forgive my ignorance.

Newbie question again, sorry. Is there a way to search in a field and have it search all related fields (in the same file) as well?