Forum Discussion
BrianSeymour
2 years agoQrew Assistant Captain
Depending on the use case, you may want to consider making a Rich Text Formula field (which allows HTML) to house the Badge in the Employee's table itself. Then, just have a report that lists all Employees with the Badge field.
I'd look out for potential security risks too. Consider leveraging QB Permissions to only grant Badge view access where the logged in User matches their respective Employee record.
Or, instead of a report, you could create a separate minimal Employee Badge Form that only includes the Badge field, then an Employees::View Badge Formula URL button displayed on the main Employee Form could point to the new Employee Badge form (using the &dfid=[The ID of your Form]). Likely that'll be ID 10.
For example,
------------------------------
Brian
------------------------------
I'd look out for potential security risks too. Consider leveraging QB Permissions to only grant Badge view access where the logged in User matches their respective Employee record.
Or, instead of a report, you could create a separate minimal Employee Badge Form that only includes the Badge field, then an Employees::View Badge Formula URL button displayed on the main Employee Form could point to the new Employee Badge form (using the &dfid=[The ID of your Form]). Likely that'll be ID 10.
For example,
// Employees::View Badge (Formula URL)
URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & URLEncode ([Record ID#]) & "&dfid=10"
Alternatively, there are some some nice third-party plugins to generate .pdf files, although, that may not be necessary here! For example, Juiced Technologies - Exact Forms Plus.------------------------------
Brian
------------------------------