I’m a little nervous that we’re not going to have enough time to go over every detail on how this ridiculously powerful communications base works. So i’ve been building it on the side and documenting my work on YouTube. 

Here’s the first video:

I plan to do another one tomorrow and then be ready to build it again with you all on Wednesday - cooking show style.

Thanks so much for joining us today for the first ever Media & Entertainment user group meeting. What a fantastic group!

Here’s the replay (embedded below as well).

And here’s a YouTube playlist with a running list of videos explaining how tools from these meetings are built.

Screenshot of the database schema:

Let me know if anyone wants that Omni prompt. You know which one i’m talking about 😉

Hey Max! Thanks for a great tutorial. this can be incredibly powerful for our Artist Relations and Partnerships department. Can you please send me the prompt?

Thanks so much for watching, Jamie. Here it is. Note: you must create the base first and enter the prompt into the left side Omni chat area. This won't work if you try it in the "Build an app with Omni" area. The first video on the youtube playlist explains this as well: https://www.youtube.com/watch?v=1kaLEjlpCNM&list=PLjgcJf_mEkcq4jFa4eo2JK_QtmJLdoiUa

Let me know how it goes!

Please create the following Tables and corresponding Fields. The list of fields below is formatted as: 

'Field Name' [Field Type]: Additional clarifying information

Do not add any lookup or rollup fields until after all the tables and other non-lookup and non-rollup fields have been added. Then and only then should you go back and add all the lookup and rollup fields to their corresponding tables. 

Please generate each field exactly as described. Do not create any additional fields that are not listed below. Feel free to ask me clarifying question before you begin.

Table: Projects
- 'Name' [Formula, primary field]: Title & " - " & Status
- 'Date' [Date]
- 'Title' [Single line text]
- 'Status' [Single select]: New, In Progress, Complete

Table: Messages
- 'Name' [Formula, primary field]: Subject
- 'Summary' [Rollup]: of "Details" field from Project Messages table using arrayjoin(values,"\n\n")
- 'Body' [Long text]
- 'Last sent' [Rollup]: of "Sent on" field from Organization Messages table using max(values)
- 'Subject' [Single line text]
- 'Date' [Date]

Table: Contacts
- 'Organization' [Link to Organizations, allow one]
- 'Name' [Formula]: First&" "&Last
- 'First' [Single line text]
- 'Last' [Single line text]
- 'Email' [Email]

Table: Organizations
- 'Name' [Single line text, primary field]
- 'Email (from Contacts)' [Lookup]: of the Email field from all linked Contacts
- 'Tags' [Multiple select]: Print, Digital, Other

Table: Project Messages
- 'Name' [Formula, primary field]: Project& " - " &Message
- 'Message' [Link to Messages, allow one]
- 'Project' [Link to Projects, allow one]
- 'Title (from Project)' [Lookup]: of the Title field from all linked Project
- 'Status (from Project)' [Lookup]: of the Status field from all linked Project
- 'Date (from Project)' [Lookup]: of the Date field from all linked Project
- 'Details' [Long text]

Table: Organization Messages
- 'Name' [Formula, primary field]: Organization& " - " &Message
- 'Organization' [Link to Organizations, allow one]
- 'Message' [Link to Messages, allow one]
- 'Email (from Contacts) (From Organization)' [Lookup]: of the 'Email (from Contacts)' field from all linked Organizations
- 'Name (from Organization)' [Lookup]: of the 'Name' field from the Organizations table
- 'Customization' [Single line text]
- 'Status' [Single select]: Staged, Ready, Sent
- 'Sent on' [Date]
- 'Ready to send' [Checkbox]