smokeyjones

Thank you! I confused search value with calculated value there.

for some reason Setvariable does not let me set a target field but only the calculation... I'm still not sure how this works, So I've uploaded a simple test I made to try this out, could you take a look and see where I did wrong? Find_Test.fp7.zip

thanks for the link comment, but when i tried to make the script working I encountered a small problem. Go to Layout["Resumo do mes"](Expense Report)] Enter Find Mode [] Set Field [ Date of End of Month ; ] Perform Find [] Sort Records [Restore; No dialog] for the I tried to use a field that is different from the Date of the Month field, for the sake of that example but it does not seem to work. However if I enter a specific value in place like 01/05/2010 then it works, what am i doing wrong?

Hi, I need help creating a simple script which I have no idea how to dispute my efforts of searching through the forums. The database I'm made has only 1 table. Field A contains a list of Last Names. Field B contains a list of First Names. Field C contains a list of Last Names then First Name separated by a space. I need a script that takes value from field C and searches records matching Both A & B fields, or at least find matching records for Field A. Any help is appreciated, if anyone could make a sample document of this so I can see how it works it would be wonderful.

thank you very much for your help!

Hi, I'm trying to generate a letterhead with the data I have. What I have is a field that says 1,2,3 and so on with people's name under them, 1 can have 5 names, 2 can have 3 and so on. The letter head I need to make will say something like: Hi [name field], please remember to take care of [1]. my problem is taking the [1] from the database I already have and change it into some form of text, like change [1] into [Throwing out the Trash]. Any help on this would be great, again I basically want to take the value from a field and generate a corresponding test based on the value. Thanks!

I'm a novice user of filemaker, and had no formal training aside from playing around with it myself. That said, I am trying to make a layout where lets say has fields Monday through Friday, as well as people's name and address. What I want to do is to make a schedule, if you will- to display for instance that on Monday bob and Joe has appointments, and on Tuesday bob and Jason has appointments then on Wednesday Joe and Jason has appointments, I want to sort them out so they display from top down from Monday to Friday. That means some name and address fields are needed to be displayed more than once in the same layout, how do I go about doing that? I apologize that this maybe a very amateur question, but any help would be greatly appreciated.