Databases can be confusing at first. You aren’t alone. I am not sure of what your ultimate goal is. It would help to understand what you want your end result to be, but I will try my best to help.
This is my best guess about how you might want to set up your database. Again, without discussing in more detail, it’s just my best guess.
Assuming that you want to display a list of all of these entities together at some point, here is my suggestion. There are other ways to do it too, but this is just one way.
Database Structure:
Entity
entityType = (business, charity) as an option set.
entityName = text
about = text
logo = image
User
parentEntity = entity
firstName = text
lastName = text
email = text
volunteer = yes/no (maybe?)
That way you are only creating one thing and then attaching it to the user on sign up.
Does that make sense?
I am still not sure what you want to do with the volunteer list though. Maybe you can explain what your goal is, then we can try to help more.
Hello kind folks. I’ve run into what seems like a very petty issue and I’m probably missing something very basic, but I’m unable to move forward.
So I’ve got two data types - Users and Articles.
Everything is great with users. My users can change, modify,update, delete whatever when they store their info. Everything remains private, no users see anything that belongs to other users.
The problem is with the common articles data type. So this is the data to which users can contribute to a common pool. They enter the data in 5 fields, click ADD and the workflow adds a new article to the database. This is visible via RG to the others. All good.
But if users need to modify the article - how to do it? What is the workflow to retrieve a particular article from the database and update its image or name? I’ve created a modify articles page, but unable to retrieve a particular article from the database to update. There are no privacy issues, so everyone can modify or update any of the articles, immaterial of who submitted it.
Hey @aneejego , I did, yes. After I add the constraints to match the article number to the number that is chosen in the dropdown, the THING TO CHANGE is still red with Search for Articles and it wants me to add something to it. It only seems happy if I add the first item or last item or random item.
Hey, thanks a ton. This solved it. I kept presuming that :first item will modify the first item of the database. After adding a constraint, it updated correctly. Thanks a bunch.
,
I am not sure of what your ultimate goal is. It would help to understand what you want your end result to be, but I will try my best to help.