This has probably being asked before, but I can’t find a solution to my problem.
I have a repeating group containing a list of Users.
The Users have a list of Qualifications which may/may not have an expiry date.
I would like to filter the RG based on the qualifications that expire within a certain period.
The period is determined based on an integer input field.
I would create a relationship datatype and then use it as my data source. Here, if you prefer, you can use the field creator instead of duplicating the field user:
Thanks for replying @mateusproto.
I’m still fairly new to Bubble so your explanation has gone over my head unfortunately.
At the moment my User’s have Qualifications linked back to them as per the screenshot below.
Are you suggesting that I create a new Thing “UserQualification”?
Forgive my ignorance, but I’m not sure how that would work, considering I’m trying to use the expiry date as a filter in the repeating group.
Yes, you understood correctly, create a new thing called “UserQualification”. It is going to have the User (or Creator) field linked with the “User” datatype and the Qualification field linked with “Qualification” datatype:
Thanks for your patience @mateusproto .
I’m now struggling with the workflow to create a UserQualification.
I have a form for Users to complete and then submit, the first workflow action creates the Qualification, the second action changes to the current User to add the Qualification to their list of Qualifications.
I tried to use the following action to change the UserQualification but it didn’t work for me.
Sorry for the late reply! Please, don’t worry if you have more questions.
You will need to take care of these this way:
Create a new qualification: You will need to create a new “Qualification” and after that you will need to create a new “UserQualification” with the the result of the created “Qualification” in qualification field and the user in the user fields.
Change a qualification: You don’t need to change anything in the “UserQualification” thing because they are linked, just update the fields in the “Qualification” thing
Delete a qualification: You need to delete first in the “UserQualification” thing and after in the “Qualification” thing
Remove a qualification from some user: You need to delete in the “UserQualification” thing searching for the qualification and user first item