# I want to put in relation two tables **URL:** \ **Category:** Ask for Help\ **Created:** [November 23, 2021, 11:52pm UTC](https://community.glideapps.com/t/i-want-to-put-in-relation-two-tables/34984 "2021-11-23T23:52:13Z")\ **Posts on this page:** 15\ **Page:** 2
**Author:** ![Mozza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mozza/32/34362_2.png) [@Mozza](https://community.glideapps.com/u/Mozza)\ **Post date:** [November 24, 2021, 11:19pm UTC](https://community.glideapps.com/t/i-want-to-put-in-relation-two-tables/34984/21 "2021-11-24T23:19:43Z")
Ok. Correct me if I’m wrong: The first image is your Events (Evento) list and the other is showing the Action(Azione) list for each Event (when you click on some of the Events). Not quite sure what are you trying to do. If you are trying to add new Actions for each Event through your app (something like a form for a user), just enable “Allow users to edit” checkbox in “Edit Form” tab in the upper right part of the editor. Everything you add there, will be connected with the given Event since you are editing (adding) items for a specific Event. Does this make any sense to you? ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 25, 2021, 2:21am UTC](https://community.glideapps.com/t/i-want-to-put-in-relation-two-tables/34984/22 "2021-11-25T02:21:38Z")
ti ho fatto un video in italiano per spiegare come raggiungere il risultato ovviamente ci sono vari modi https://player.vimeo.com/video/649759569?h=066cee4aab&app_id=122963 ---
**Author:** ![Luca\_Pellegrini](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luca_pellegrini/32/16485_2.png) [@Luca\_Pellegrini](https://community.glideapps.com/u/Luca_Pellegrini)\ **Post date:** [November 25, 2021, 6:31am UTC](https://community.glideapps.com/t/i-want-to-put-in-relation-two-tables/34984/23 "2021-11-25T06:31:16Z")
Grazie mille Mikahel. Sei stato gentilissimo. Provo e ti faccio sapere. 🙏 ---
**Author:** ![Luca\_Pellegrini](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luca_pellegrini/32/16485_2.png) [@Luca\_Pellegrini](https://community.glideapps.com/u/Luca_Pellegrini)\ **Post date:** [November 25, 2021, 6:38am UTC](https://community.glideapps.com/t/i-want-to-put-in-relation-two-tables/34984/24 "2021-11-25T06:38:43Z")
This video contain two solutions of my single problem. Thank’s a lot to everybody. ---
**Author:** ![Luca\_Pellegrini](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luca_pellegrini/32/16485_2.png) [@Luca\_Pellegrini](https://community.glideapps.com/u/Luca_Pellegrini)\ **Post date:** [November 25, 2021, 8:05am UTC](https://community.glideapps.com/t/i-want-to-put-in-relation-two-tables/34984/25 "2021-11-25T08:05:17Z")
Scusa Mikahel, un’ultima cosa. Una volta che ho selezionato riempito tramite choice la colonna action code attraverso una selection multipla, mi mette i valori separati da virgole. Poi io come faccio a usare i dati delle singole actions, esempio visualizzandoli tramite un’inline list? ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 25, 2021, 9:28am UTC](https://community.glideapps.com/t/i-want-to-put-in-relation-two-tables/34984/26 "2021-11-25T09:28:48Z")
Allora @Luca_Pellegrini, perche` vuoi gestire in una inline list le actions che sono sotto gli events? mi spiego, le actions da gestire in dettaglio sono quelle sotto la tabella action (per cui hai gia una inline list di queste), mentre negli events sono dei riferimenti a queste. Ad esempio Evento “X” Azione “Mangia”, Azione “Bevi” in questo caso e` una informazione che puoi userai per fare calcoli o dare indicazioni ulteriori, quindi perche` metterle in un elenco separato? Ti chiedo questo perche` ovviamente a seconda di cio che ti serve si puo adottare una soluzione o meno. Detto questo: quello e` un array di informazioni, percui per prendere le informazioni seprata puoi fare una split e poi con l`aiuto di un indice fai una FLAT (cioe` le metti in una colonna), ma a che pro? Se guardi column type Array, trovi una serie di funzionalita per fare questo. L`applicazione del video l`ho resa disponibile, puoi copiarla ho fatto delle modifiche simili a cio che ti ho scritto sopra, dagli un occhio. ciao > **[trisixnine's Project](https://lucap.glideapp.io/)** ---
**Author:** ![Luca\_Pellegrini](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luca_pellegrini/32/16485_2.png) [@Luca\_Pellegrini](https://community.glideapps.com/u/Luca_Pellegrini)\ **Post date:** [November 25, 2021, 10:08am UTC](https://community.glideapps.com/t/i-want-to-put-in-relation-two-tables/34984/27 "2021-11-25T10:08:17Z")
Ti spiego a cosa serve: é un app per la manutenzione di un parco. Le azioni sono degli interventi da fare (esempio un albero nel fiume da rimuovere o un prato da sfalciare). Gli organizzatori della manutenzione creano un evento per fare delle manutenzioni (esempio per sfalciare il prato e rimuovere l’albero). Io vorrei che se un manutentore che vede un evento possa vedere le scheda dell’intervento da effettuare (esempio vedere dov’è l’albero da rimuovere). Per questo mi serve poter aprire la scheda delle azioni collegate all’evento. ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 25, 2021, 11:26am UTC](https://community.glideapps.com/t/i-want-to-put-in-relation-two-tables/34984/28 "2021-11-25T11:26:18Z")
Ok, ti serve un dettaglio delle singole azioni per quel preciso evento. per cui devi creare una gerarchia degli eventi TAB EVENTO (macro tabella) dove le azioni possibili li puoi aggiungere come stai facendo adesso ma sono soltanto un indicazione di quello che puoi fare dentro quell’evento. quindi ora devi creare un`altra tabella TAB EVENTIAZIONI la chiave sara EVENTO+Azione riepilogo ```auto TAB AZIONI TAB EVENTI TAB EVENTAZIONI FALCIARE PULIZIA PARCO PULIZIA PARCO FALCIARE PULIRE DEFOGLIAZIONE PULIZIA PARCO PULIRE SRADICARE PULIZIA PARCO SRADICARE ``` Quindi devi mettere in relazione le 3 tabelle in modo opprtuno Ora pero devo chiederti una cosa, quanta esperienza hai di informatica? ---
**Author:** ![Luca\_Pellegrini](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luca_pellegrini/32/16485_2.png) [@Luca\_Pellegrini](https://community.glideapps.com/u/Luca_Pellegrini)\ **Post date:** [November 25, 2021, 1:54pm UTC](https://community.glideapps.com/t/i-want-to-put-in-relation-two-tables/34984/29 "2021-11-25T13:54:20Z")
Alla fine non ero tanto lontano creando una tabella di relazione tra eventi e azioni. Non sono uno sviluppatore professionista: sono autodidatta, ma ne ho mangiato tanto di php+html+mysql. Saprei farlo con questi strumenti, ma in glide non so dove sono le funzioni e che funzioni ci sono. Grazie mille per la consulenza e per la pazienza. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 25, 2021, 3:41pm UTC](https://community.glideapps.com/t/i-want-to-put-in-relation-two-tables/34984/30 "2021-11-25T15:41:35Z")
> [@Luca\_Pellegrini](#): > > it puts the values ​​separated by commas. Then how can I use the data of the single actions If I’m understanding correctly, all you need to do is create a Split Text column that points to that comma delimited list of actions. This will split the selected actions into an array. Then you can create a relation that links that split array colomn to your actions table. Then simply add an inline list on your event screen that uses that relation. I still don’t think you need a third table to accomplish this. ---
**Author:** ![Luca\_Pellegrini](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luca_pellegrini/32/16485_2.png) [@Luca\_Pellegrini](https://community.glideapps.com/u/Luca_Pellegrini)\ **Post date:** [November 25, 2021, 3:59pm UTC](https://community.glideapps.com/t/i-want-to-put-in-relation-two-tables/34984/31 "2021-11-25T15:59:20Z")
Perfect. It’s running very well! Thank’s a lot. ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 25, 2021, 5:22pm UTC](https://community.glideapps.com/t/i-want-to-put-in-relation-two-tables/34984/32 "2021-11-25T17:22:15Z")
You are right, he can avoid it or better he can skip the second TABLE, but for clearness and to have a rounded structure it is better to have. in any case the second table will be used as a guidance for the third ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 25, 2021, 5:25pm UTC](https://community.glideapps.com/t/i-want-to-put-in-relation-two-tables/34984/33 "2021-11-25T17:25:58Z")
si era giusto, te lo chiedevo perche` ovviamente e` basilare partire dalla strutturazione dell`architettura tabellare. io questo errore l'ho fatto spesso, cioe` quello di partire con lo sviluppo a bomba senza prima disegnarmi le relazioni. cosi ci si mette il doppio del tempo alla fine e si ritorna piu volte. comunque scusami non avevo intenzione di sottostimarti. ciao ---
**Author:** ![Luca\_Pellegrini](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luca_pellegrini/32/16485_2.png) [@Luca\_Pellegrini](https://community.glideapps.com/u/Luca_Pellegrini)\ **Post date:** [November 25, 2021, 5:33pm UTC](https://community.glideapps.com/t/i-want-to-put-in-relation-two-tables/34984/34 "2021-11-25T17:33:58Z")
Non mi sono offeso. Dopotutto sono autodidatta e non faccio il programmatore. Sono un architetto. Mi pareva che la tabella di relazione fosse una cosa più solida dal punto di vista architettonico, ma va benissimo come abbiamo fatto. Grazie mille dei preziosi consigli. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [November 26, 2021, 5:34pm UTC](https://community.glideapps.com/t/i-want-to-put-in-relation-two-tables/34984/35 "2021-11-26T17:34:53Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed. [Previous page](https://community.glideapps.com/t/i-want-to-put-in-relation-two-tables/34984.md?page=1)