Help! connecting Database


Will really appreciate the help as I can’t move forward at the moment (can’t move forward without sorting this out first) :pensive:

I rebuilt the question and similar database structure in a new app to be able to share it, here it is
(you are able to edit)

So question is, I want users to be able to pick who the want to register as (so I did a dropdown with 3 options - business, charity or volunteer)


Then I do a workflow, looks like this /attaching screenshots as well for a quick peak

Is it incorrect?

It does populate fields. Question is - am I doing it the right way?
It would really ruin my app if I do it wrong so will really appreciate the help

I will need to have Volunteering Listings and have Charity and User attached to it?

**So how would I link them all up later (providing that so far it is set up right)? **
What does and doesn’t need linking?

How would I attach volunteering listing to a charity, not user? Or do I need to do both?
What’s the best way?

Please point me in the right direction

Like, for a listing, who will be the creator? is just user enough? or I need both

ok it seems like i made it work… but is it correct? lol

Hey @aneejego :wave:,

Databases can be confusing at first. You aren’t alone. :blush: 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:


  • entityType = (business, charity) as an option set.
  • entityName = text
  • about = text
  • logo = image


  • 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.

Hope that helps! :blush:


For All Your No-Code Education Needs:

  • One-on-One Tutoring
  • eLearning Hub
  • Video Tutorials

thank you! it all seems to be working for now, but if i run into an issue again is it ok to pop you a message?

thank you so much!

Sure, sounds good. :blush:

1 Like

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.

What am I missing?

Thanks a ton.

did you do a do a search for with constraints?

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.

Any ideas?

can you show screenshot or share app

When you do a search you’ll get a list of items from the database (even if there’s only 1 item on that list).

So you need to add :first item to turn the list into a single item that you can use as your data source for your article page or group etc.

1 Like

Here goes.


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.