Jump to content

Greg58

Members
  • Content Count

    21
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Greg58

  • Rank
    member

FileMaker Experience

  • Skill Level
    Novice
  • FM Application
    16 Client

Platform Environment

  • OS Platform
    Mac

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Thanks very much for the replies. I will try to progress it as you have suggested.
  2. I have been trying to work this out for a while now but just can't get it to work. I have a ToDo app I am making for my own use. On the ToDo page i have a button that sends non-urgent tasks to a table called TOMORROW. It date stamps the task being sent to TOMORROW with the current date. When I open the app the next day I want a script trigger to go to TOMORROW, check the date of the tasks. All that are less than todays date (which should be all of them), it sends them to the ToDo table. I have it working OK but it only does one record at a time. It won't loop through the records for some reason?? A copy of the script is below. Any advice is appreciated.
  3. Thanks for the advice; it makes sense what you are saying. I am trying to mimic an app my daughter has which presents her with a list of tasks for the day. She has overwhelming lists, and can put some less pressing ones off until tomorrow. The ones she puts off until tomorrow, re-appear the next day and the process starts again.
  4. I have a TODO list. Some tasks I want to put off until tomorrow, but have them re-appear on my TODO List the following day. I have two tables; TODAY, and TOMORROW. I can get the individual records to go to the TOMORROW table ok by just using a button and script. This operates on only one task at a time. I am having problems getting the records in the TOMORROW table to automatically come back to the TODAY table the following day. I date the records going to the TOMORROW table and have tried to use this as a criteria to send them back to the TODAY table. One problem is that there are often numerous records and not just the one that need to be sent back. I have tried a script trigger on the file so that when the file is opened, the records in TOMORROW are sent to TODAY. The problem is that there are numerous records. Any assistance is appreciated. Thanks.
  5. Sorry. Just realised this is on the wrong forum...
  6. I have a TODO List. Some tasks I want to put off to tomorrow, but have them reappear on my TODO List the following day. I have two tables; TODAY, TOMORROW. I can get the individual records to go to tomorrow ok by just using a button with a script. This operates on one record at a time which is fine. I am having problems getting the records in the TOMORROW table to automatically come back to the TODAY table the next day. I date the records when they are sent to the TOMORROW table, and have tried to use this date as the criteria for them to re-appear in the TODAY table. One problem would seem to be that there are often multiple records to be sent from TOMORROW. I have tried to set a script trigger on the file itself so that when I open it the next day it sends the records back to TODAY. Any help is appreciated.
  7. Actually I worked it out thanks. This was just trial and error file I was using to experiment with. Again thanks for your time.
  8. I am trying to loop through just 5 records (just using a test file) to copy owner ID's into consecutive fields on a separate layout. The loop is working, but copies each of the 5 ID's into each field over 5 fields. Can anyone advise what I am doing wrong please??
  9. Thanks very much for this information. Helps heaps 😀
  10. I have a simple database with two tables; Owners and Pets. One owner can have many pets. The pets table also has the field for type, such as dog or cat. I am having problems creating a portal to display just the dog owners. Have tried various things including a field with the word "Dog" hard wired into it with an = to type on the other side of the relationship. Any help would be appreciated please. I have attached my database. Pets 190802.fmp12
  11. Not sure I thanked you guys for your help. Sorry for the delay but your advice assisted me immensely.
  12. Thanks for that. I did the validate as 'not empty' and that does fix the problem, but as you say not a great user experience. I will work on that. Thanks again. Greg
  13. The add button is to add the task to the db. But if I decide not to add it and press the menu button it add the blank task.
  14. Thanks for that advice. Just to clarify, the below image is where I add a task. My problem is that if I hit the menu button from this page without filling out a task (perhaps I decided not to do it), I get a blank entry as in the next picture. I would like to have that blank task delete if there is noting in it. Thanks for any help you can give.
  15. I have a list with three fields of data. The first is 'task', and the next two have autofills for 'not urgent' and 'incomplete. If the task field is empty I would like the record to automatically delete. I have messed about with 'IF (isempty)' but having no success. Any assistance would be appreciated please.
×
×
  • Create New...

Important Information

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