Hello!
Hope you all are well! (basic question)
Ive been referring mainly to this forum post, but I just wanted to triple check I’m understanding correctly.
In bubble, you can create a relationship on a table, where one row, can reference multiple other rows, for example.
Invoice’ references an array of ‘invoice items’ (I assumed bubble was doing it like this, [uuid1, uuid2, uuid3 and so on]
But if I’m understanding correctly, its actually a junction table for one-to-many and many-to-many relationships, where there is two fk for tables, example the ‘invoice’ and ‘invoice item’ table.
So in wappler if I want a one-to-many, I should use the multi-reference in wappler.
Correct?
Few more sub-questions:
If I wanted example to remove a relation, (sometimes I have to do it manually in bubble), I was to remove a relation, example removing an invoice item from an invoice. I would need to find all rows in the junction table of the relationships I’m talking about, and then delete the relation I don’t want right? As the relations will be completely handled by the junction table and not on the tables directly.
Another question, regarding arrays, just for strings. I noticed there isn’t an option to say this should be an array or something. Guessing its similar above, where bubble was just displaying it in easier way to understand, where when storing the string/text, I should format it as a list like this/similar:
[value1, value2, value 3]
Then when I want to use it as a list, id need to format by delimiting or something?
Or using the json array data field? (that way its like auto formatted into a list when its queried, is that correct?)
Also finally, storing an array of dates, instead of using a date field, I would store it in list of strings or the json array? With the only downside to that is, I won’t be able to filter with the dates in that array. Where the date field is more specific for filtering/querying?
Sorry for these basic questions, I need to understand these sort of basic things before I can even move properly. I have a million small questions but trying my best to use what is available
Cheers, Haydn