Jump to content

Steve T Cunliffes

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Steve T Cunliffes

  • Rank
  • Birthday 01/17/1973

Profile Information

  • Gender
  • Location
    St Helens, Merseyside, England
  1. Would be most grateful if somebody could help please. I have developed a WebDirect solution which all works fine. I type in into my browser, it lists my database file named 'Portam' and I'm then able to log-in. I'm also able to access the file via Filemaker Pro Advanced using the Open Remote File facility and selecting the host fmnet:/filemakerserver.cunliffes.local/, this then lists my file 'Portam' and like with above i'm then able to log-in. I firstly have to make a VPN connection however to my office for my file 'Portam' to be listed when selecting t
  2. Hi Comment, yes my unstored calculation fields depend on changes made to data in related fields. Some of the related fields can be more than one level deep however. I'm unsure if more than one level deep you would still class them as related but if the tables are joined in one way or another I suppose you would. I forgot to mention, my database is being developed for use via WebDirect and one article I read suggested not using a flush cached join.
  3. Hi All, Hoping somebody can help please or just point me in the right direction. Is there a way to refresh / update calculated fields on a layout. I have tried a 'Refresh Window' script, 'Refresh Object' script but neither appear to work. At present I am leaving the field's browse mode on in Inspector, as I have discovered through trial and error that when I change/add data then click in the calculated field it activates a refresh..... well in most cases it does. This isn't ideal as on one particular layout I have 2 calculated fields, plus two portals each with a calculated fiel
  4. LOL you folks are amaizing, both work brilliant! Thank you once again for taking the time to reply and help me, it's very much appreciated. Steve
  5. Hi Lee, Ah right yes, I understand what you mean now by a found set. I don't think this is what i'm after however and don't think I have explained my problem properly. It's not that I have lots of records where this has occurred i.e a return or space but no data and need to easily find and delete them. Also the database isn't live yet, i'm only testing it so losing any data at this stage wouldn't be too critical anyway. My layout has several fields that the user will 'fill in' then submit the form. They are however able to go back into that particular record/form and edit the dat
  6. Hi Lee, It's just simple txt and numbers that are supposed to be in the fields i.e. an address, persons name, tel no. etc. I'm not familiar with Found Set but will read up on it as I have a good few books here i've purchased to help me with my learning of FM. Steve
  7. Hi, Hoping somebody can explain why this happens. If you have a basic script attached to a button as follows: - If [IsEmpty (Projects::Client Name )] or If [Projects::Client Name = "")] f you place the cursor in a field and hit return then click out the field, so field is still free of any text but has a return in it, the script fails. If I go back into the field and take the return out, the script works. It's as if the return is acting as an entry even though the field is still blank/free of any text/data....... confused I came across when asking a colleague to tes
  8. Understood! I shall change to use SetField[] and clear the global at the end of the script. I will save a copy of my file and work on Comments solution also to get it working. Thank you again, I am very appreciative of everybody's help, comments and advice. Steve
  9. Bruce, thank you for the idea / suggestion. I will look into it to see if that is a more suitable way but I have solved it for the time being using LaRetta's original script. Comment, I have played around for a good for hours trying to get one of your examples your provided to work but with no luck. It's a great example but I have many many tables, joins etc and struggling to configure it for my development. I'm sure if you had a copy of my file you would quickly adapt it to work but i'm still learning. LaRetta, I have simply created a global field for my second portal and tried thi
  10. Hi LaRetta, OK, thank you for your reply. I'm going to work again now on Comments direction, determined to crack it!! Thank you both for your help and time to date and pointing me in the right direction, will let you know how I get on Steve
  11. Hi, Comment - Post 355429 is exactly what i'm trying to achieve, unfortunately I can't get it to work for me but will keep trying. LaRetta, I think I now understand your script but it just keeps returning the message "Aided funding type has already been added": - If the 1st line of the script lists the full list of ID numbers from the first portal, in my case from my attached screen shot B-355, B-356. Then filters the results based on the ID numbers in the 2nd portal, this being B-355. Then isn't it always going to evaluate as not empty regardless of which record i'm in when I cl
  12. Thank-you all for your posts and suggestions / help. LaRetta, I tried your script and can't get the first line to work when writing it, keeps saying there are too few parameters in this function. As asked, let me try and explain further what this is about. Please see attached snap-shot of my layout. The portal with the heading above it 'Available (Aided) Funding Sources' is named 'Funding Available Portal'. This is where I am trying to copy the data from. The portal with the heading above it 'Add Aided Funding' is named 'Aided Funding Portal'. This is where I am trying to pas
  13. Would be most grateful if someone could help or point me in the right direction please. I have a button on a portal whereby when clicked I would like it to copy data from a field on it (field named 'Beneficiary Allocations ID PK'), then paste it into a field on another portal (field named 'Beneficiary Allocations ID'), then perform a find to see if that value already exists. Note: both portals are on the same layout. I just keep getting the same message returned ""Aided funding type has already been used". Here is my script: - Go to Object [Object Name: “Aided Funding Portal”]
  14. Hi Comment Thank-you for pointing me in the right direction, have been having a play around with it and this seems to work great: - Set Error capture [On] Enter Find Mode [] Set Field [Projects::Consultant ; Get (AccountName)] Perform Find [] Sort Records [ Restore ; No dialog ] If [Get(FoundCount) = 0] Show Custom Dialog ["No Records Have Yet Been Created"] End If   Thanks again Steve
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.