Thanks to this action, which will be added to the Xpoda forms, meeting requests can be sent to the desired e-mail addresses by specifying the desired content along with the start and end dates. With this action, meeting requests are made on the same screen without switching to a different platform.
Description : A description of the action is written. This description field is used to reference the developer.
Heading : Specifies its name in the action list when the form is added as an Action.
To Whom: The e-mail information of the person or persons to whom the meeting request will be sent is written. This field is required.
For example: SELECT Email FROM XPODA_CLIENT_USERS or SELECT 'firstname.lastname@example.org'
Subject: The title of the invitation mail to be sent is written.
Sender Mail: If mail will be sent to people with a different mail information that is not defined on the system, this field parameters must be filled in completely. Press the enter key after each parameter to continue from the bottom line. For example;
If left blank, the system will use the mail information in XPODA_GENERAL_SETTINGS to send mail.
Meeting Data: This field should contain the following fields, the order of which may be mixed. This field is required.
Organizer: Enter the name and surname of the person who organized the meeting. Empty text can be given to this field. For example; '' AS Organized
Name and surname of the organizer (can be given as empty text)
StartDate : The meeting start date and time information is entered. This field cannot be left blank or an invalid value cannot be entered.
EndDate: Enter the meeting end date and time. This field cannot be left blank or an invalid value cannot be entered.
Location : The meeting place is written. Empty text can be given to this field.
Description : Long texts containing details about the meeting are written. Empty text can be given to this field.
Run Condition: A condition can be specified for the action to run.
A button is added to the form page and a meeting invitation is sent when this button is clicked. For this, the Send Meeting Request action is defined on the button on the form page .
Since this meeting request is requested to be sent to all users in the IT department, the query that extracts the Mail values from the table where the information of the personnel is kept is written in the To Whom field.
'Determining the weekly program' is written as the subject.
The Sender Mail field is left blank. Since it is left blank, the mail information in the XPODA_GENERAL_SETTINGS table will be used.
Finally, the Meetin Data field is filled as follows and the action is recorded.
select 'XPODA IT DEPARTMENT' as Organizer,
GETDATE() as StartDate,
GETDATE() as EndDate,
fn_availableRoom(StartDate, EndDate) as Location,
'Enter a very long description for our meeting here' as Description
Go to the client screen and click the button.
An e-mail as below will be sent to all e-mail addresses returned from the query entered in the To Whom field.