Database systems and related multichannel communication methods
View Patent ↗Computing systems, database systems, and related methods are provided for managing data pertaining to electronic messages. A database system includes a database including a first object having a plurality of content fields corresponding to a first instance of an electronic message configured for a first communication channel and a server coupled to the database and a network to create a second database object corresponding to a second instance of the electronic message configured for a different communication channel, create a multichannel data structure in the database maintaining an association between the first and second objects, automatically populate a subset of content fields of the second object with values copied from the first object based on a mapping between the two communication channels, and thereafter use the second object to generate a version of the electronic message to be communicated to a recipient using the second communication channel.
1 . A method of managing data in a database system, the method comprising:
providing a graphical user interface (GUI) within a client application, the GUI including a graphical representation of a first electronic message having metadata for one or more content fields in a first data format associated with a first communication channel and a GUI element for obtaining user indication of a second communication channel different from the first communication channel;
obtaining, via the GUI element, the user indication of the second communication channel to convert the first electronic message to a second data format for the second communication channel, the second data format being different from the first data format;
identifying the one or more content fields of the first electronic message configured for the first communication channel that logically map to a subset of content fields of a new message configured for the second communication channel;
automatically populating the subset of content fields of the new message using the metadata for the one or more content fields mapped to the subset of content fields of the second data format corresponding to the one or more content fields of the first electronic message having the first data format; and
providing, via the GUI, a graphical representation of the new message having the second data format configured to be delivered via the second communication channel using the subset of content fields of the new message, wherein the graphical representation of the new message comprises at least some content the same as the first electronic message having the first data format associated with the first communication channel.
2 . The method of claim 1 , wherein obtaining the user indication comprises obtaining user input selecting a destination messaging communication channel for the first electronic message from within the GUI.
3 . The method of claim 2 , wherein the destination messaging communication channel comprises email.
4 . The method of claim 3 , wherein the GUI comprises a second GUI element to edit a subject field of the new message.
5 . The method of claim 4 , wherein the first communication channel comprises an application-based messaging channel.
6 . The method of claim 1 , wherein providing the graphical representation comprises providing the graphical representation of the new message within the GUI for review by a user prior to transmitting the new message via the second communication channel.
7 . The method of claim 6 , wherein the graphical representation of the new message within the GUI depicts the new message as it would be presented upon receipt via the second communication channel.
8 . The method of claim 7 , wherein the GUI comprises one or more GUI elements for at least one of modifications, additions and edits to the subset of content fields of the new message.
9 . The method of claim 1 , wherein automatically populating the subset of content fields comprises automatically mapping common metadata for the one or more content fields in the first data format to the subset of content fields of the new message.
10 . The method of claim 1 , wherein the graphical representation of the new message comprises the same content as the first electronic message having the first data format associated with the first communication channel.
11 . The method of claim 1 , wherein the GUI comprises one or more GUI elements that allow a user to define the metadata for the one or more content fields in the first data format associated with the first communication channel.
12 . The method of claim 11 , further comprising providing a second GUI element within the GUI that allows the user to select the first communication channel as a desired messaging communication channel.
13 . The method of claim 1 , further comprising retrieving the first electronic message comprising an existing message in a database of the database system prior to automatically populating the subset of content fields of the new message using the metadata for the one or more content fields of the existing message in the database of the database system.
14 . At least one non-transitory computer-readable medium having instructions stored thereon that, when executed, are configurable to cause at least one processing system to:
provide a graphical user interface (GUI) within a client application, the GUI including a graphical representation of a first electronic message having metadata for one or more content fields in a first data format associated with a first communication channel and a GUI element for obtaining user indication of a second communication channel different from the first communication channel;
obtain, via the GUI element, the user indication of the second communication channel to convert the first electronic message to a second data format for the second communication channel, the second data format being different from the first data format;
identify the one or more content fields of the first electronic message configured for the first communication channel that logically map to a subset of content fields of a new message configured for the second communication channel;
automatically populate the subset of content fields of the new message using the metadata for the one or more content fields mapped to the subset of content fields of the second data format corresponding to the one or more content fields of the first electronic message having the first data format; and
provide, via the GUI, a graphical representation of the new message having the second data format configured to be delivered via the second communication channel using the subset of content fields of the new message, wherein the graphical representation of the new message comprises at least some content the same as the first electronic message having the first data format associated with the first communication channel.
15 . The at least one non-transitory computer-readable medium of claim 14 , wherein obtaining the user indication comprises obtaining user input selecting a destination messaging communication channel for the first electronic message from within the GUI at the client application.
16 . The at least one non-transitory computer-readable medium of claim 15 , wherein the destination messaging communication channel comprises email.
17 . The at least one non-transitory computer-readable medium of claim 16 , wherein the GUI comprises a second GUI element to edit a subject field of the new message.
18 . The at least one non-transitory computer-readable medium of claim 17 , wherein the first communication channel comprises an application-based messaging channel.
19 . The at least one non-transitory computer-readable medium of claim 14 , wherein the instructions are configurable to cause the at least one processing system to provide the graphical representation of the new message within the GUI for review by a user prior to transmitting the new message via the second communication channel.
20 . At least one non-transitory computer-readable medium having instructions stored thereon that, when executed, are configurable to cause at least one processing system to:
obtain metadata for a first plurality of content fields for a first message corresponding to a first instance of an electronic message having a first data format associated with a first communication channel;
identify a second communication channel for the electronic message, the second communication channel being different from the first communication channel and having associated therewith a second data format different from the first data format, the second data format including a second plurality of content fields defining messages for the second communication channel that are different from the first plurality of content fields;
automatically map a subset of the metadata of the first plurality of content fields of the first message having the first data format to a corresponding subset of a second plurality of content fields of a second message having the second data format;
thereafter create the second message corresponding to a second instance of the electronic message in the second data format associated with the second communication channel by automatically populating the corresponding subset of the second plurality of content fields of the second message using copied metadata formatted in accordance with the second data format in association with the second communication channel; and
present a graphical representation corresponding to receipt of the second instance of the electronic message via the second communication channel using the subset of the second plurality of content fields of the second message, wherein the graphical representation comprises the same content as the first instance of the electronic message having the first data format associated with the first communication channel.