FAQ
FAQ
When customizing email templates, you may need to use custom email template variables. One useful variable, {{RECORD_ID}}, is applicable in which scenarios?
First, let’s understand what RECORD_ID is. The URL of each record in Ragic is: www.ragic.com/AccountName/TabPathParameter/SheetPathParameter/RECORD_ID. Each record within the same sheet will have a unique RECORD_ID.
If your sheet has Multiple Versions, the RECORD_ID for the same record across different sheet versions will be the same.
In such cases, if you want to include a link to the corresponding record in another version of the sheet in an email, you can use the {{RECORD_ID}} variable.
Example:
The "Applicant Interview Record" sheet has Multiple Versions: one for guest users to fill in resume details and another for internal use, which includes confidential information like evaluations and hiring decisions that applicants should not see.
In the internal "Applicant Interview Record" sheet, you may want to send an 'Interview Invitation' email using the Send Custom E-mail button, including a link to the Applicant Resume sheet for confirmation. In this case, the sheet used to send the email and the sheet containing the Applicant Resume link are different versions. This prevents applicants from accessing internal evaluation information. However, since the two multiple-version sheets correspond to the same data, their RECORD_IDs will be identical. Therefore, you can include a link in the email as: the URL of the other version of the sheet/{{RECORD_ID}}.
Please refer to the following example:
1. Set up the Send Custom E-mail button in the "Applicant Interview Record" sheet used internally.
2. In the email template, include the URL of the "Applicant Resume" sheet/{{RECORD_ID}} as the resume link.
3. Clicking the resume link in the "Interview Invitation" email will lead to the corresponding record in the "Applicant Resume" sheet.
