Hello everyone, here is my problem, I have a “request list” table in it there are for each month and for each service provider several records which contain the month and year, activity and name of the user as well as the primary key of the provider.

I display this in an external table to list its services over a month, previous month and following month allows me to move from one month to another using as a script: Search for worker ID and month+1 and year My problem is if it doesn't work in 2/2024 but in 3/2024 it doesn't necessarily show it to me like I do +1. So I don't see how to make my script for this. Thank you for your help

I don't understand your question. You are showing a portal that shows records in the selected month and year but we don't see how the relationship is defined. And you say you have a script to "Search for worker ID and month+1 and year" - but you don't need to do a search to show related records.

Are you asking how to increment/decrement the Month and Year fields by 1 month? Or something else?

 

Sorry I will try to be clearer, when searching for the month of the service provider's service, if he did not work in February, but he worked in March, once in the month of February if I use my "next month" button, it tells me that there is no service which is normal but I would like it to then show me the month of March directly. I don't know if it is clearer.

Thank you for your help

Edited August 30, 20241 yr by aletournai

1 hour ago, aletournai said:

I don't know if it is clearer.

I am afraid it's not. I am still confused whether you want to use a relationship or a find.

Here is a file that does something similar to what you describe (I think) by using a relationship. If this doesn't meet your need, please explain in more detail.

 

EventsInMonthX.fmp12

 

Thank you, that's almost it, I'll attach my database for you to understand better

 

Prestations_ALE.fmp12 Prestataires_ALE.fmp12

Attaching a file that does NOT do what you want is not a good way to explain what you DO want.

I am guessing (!) from the fact that the portal is showing records from the current found set (a.k.a. a "master-detail" layout) that you want to use a find to show the records in the target month, rather than a relationship. This could be done as shown in the attached file.

 

FindEventsInMonth.fmp12

 

it's good with a search that I want to work, just for gViewMonth I prefer to have the month in numbers and the year in numbers

3 minutes ago, aletournai said:

I prefer to have the month in numbers and the year in numbers

You can format the gViewMonth field to display in any format you like. You can even use two instances, one for the month and one for the year.

 

 

I'm trying to remodify your file to understand you better, because I see that what you did is good but I need to find the list of requests for a month for a single worker.

8 minutes ago, aletournai said:

but I need to find the list of requests for a month for a single worker.

Why is that a problem? You just need to add the worker's ID as another criteria to the find request.

 

THANK YOU SO MUCH FOR YOU HELP