I need to link two tables in this way:
I have a table that collect some things called “actions”, every action is a row.
I have also a table that collect the events, every events must be linked with one or much more actions.
So, I tryed to create one more table, like a relation table, where I can collect the relation between an event and one or more then one actions. A simple Table with two columns (Events and Actions). When I am into an Event I show a list of Actions where the action on click is add a new row where I put on the Actions column the ID of the Action. But I don’t know how I can put on the Event column the Events ID.
Please help me.
so you made the following
tbl actions tbl events tbl act/events onclick write onclick;write read onclick/read
first of all why you didnt make it simpler like this
tbl actions tbl events onclick write ; onclick read ; onclick
then you can relate those via the ONCLICK action
if you agree with this then we may check else
I agree with your strategy and I was trying also that, but probably in a the wrong way.
Can you explain your strategy?
Thank’s a lot!
nessuna strategia, semplicemente crei una tabella con le azioni ed una tabella con gli eventi e le metti in relazione.
per fare una cosa fatta bene dovresti creare le tabella in questo modo:
ROW ID (chiave primaria)
ROW ID (chiave primaria)
Quindi in GLIDE devi creare una chiave multipla tra Azioni ed eventi
Cioe’ la RELATION COLUMN tra le 2 tabelle (AZIONI\ROWID = EVENTI\ID AZIONE)
cosi facendo per ogni azione (ad esempio CLICK) corrispondono piu eventi
Cosi otterrai un ARRAY di eventi possibili da scegliere.
Ovviamente bisogna vedere cosa devi farci.
spero ti possa aiutare.
Mi sa che non ho capito.
Ti posto l’app. https://novel-sidewalk-0938.glideapp.io/
Sulla tab Eventi ho inserito all’interno di ogni singolo evento l’elenco di tutte le Azioni (appartenenti alla Tab Azioni).
Io vorrei che, cliccando su un’azione, si attribuisca una relazione tra l’azione e l’evento in modo tale da poter visualizzare che all’interno di un evento si svolgono tutta una serie di Azioni.
Spero di essere stato chiaro.
Grazie per la pazienza.
The easiest way is to have a form button on your event details screen. Then in the form you add a column value component that passes the event ID through to the form to the action table. That way, every action will have the associated event ID included when the action is created. Then all you need to do is create a relation in the events table to link the event ID to the event ID in the actions table.
Ok, I’m near to the solution.
How can I pass a value from a list (in this case the Actions) through the form?
It’s just a component in the form screen that you add like any other components. The only difference is that you won’t actually see anything new on the app screen because it passes that value behind the scenes when the form is submitted. This documentation is showing an old version of glide, but the concept is the same.
Like I said earlier, the form button should be on your event screen. Then you will be able to pass any value from that specific event to the actions table when the form is submitted.
Vedo di riprodurre la casistica in un mio progetto adhoc, domani però.
Cerca comunque di seguire il tutorial che ha indicato Jeff
Sono italiano ma vivo in Giappone, per cui i nostri tempi non coincidono.
Cercherò di aiutarti per quel che posso.
Grazie mille, gentilissimo. Mi metto a studiare.
Ok, I understood how it works, but I didn’t understand how I can choose some values from a list to send through the form.
Sorry, I’m a novice of Glide
Here… while on the Form screen, click + for adding components and you will see some new options:
Sorry if I misunderstood your question.
Thank’s a lot for helps.
Glide have a great community.
I solved my problem with a multiple choice. With the choice I can select the Action’s ID and with the column value I can send the Event ID to a Relation Table, then I can display the relation column like a list.
Thank’s to everybody.
Just to add, what we have been describing above doesn’t require you to have a separate relation table. You should only need your Events table and Actions table. The relation column is created on the Events table and relates directly to the actions in the Actions table, with a matching event ID, as long as you also have a column to store the Event ID in the Actions table.
But maybe I’ve misunderstood as well, and the list of actions don’t change. In that case, I think you can have your multiple choice component directly update a column in the the Events table with your list of selected actions. Then you can use a Split column to split those multiple choices into an array. The you can create a Relation column that links the split array to your Actions table.
In either case, I don’t think you need a separate relation table, unless I’m still not following.
In fact my solution doesn’t work
I want to follow your advise, but I don’t know how can I update the column to store the Event ID in the action table from the Events TAB.
Hey, @Luca_Pellegrini is there a chance to show us a screenshot of your Form screen when + (from components list) is pressed?
It might give us a clearer picture of how your data is related (or not).