Clean Up Data After Events
From Andrew O'Dell on the Planning Center Slack #custom-reports channel After reading the article “Clean Up Database After Event” https://pcopeople.zendesk.com/hc/en-us/articles/360009391314-Clean-Up-Database-After-Event , I wrote this little report to generate a pdf for our children’s minister to be able to quickly identify which students are ours and which should be marked as Inactive (i.e. who are members of other churches, out-of-town grandchildren, etc) Thanks Andrew!
Preview
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
<!DOCTYPE html>
<html lang="en">
<head>
<title>Post-Event Audit</title>
<style>
@media print {
body { margin: 0; padding: 0; }
}
@media screen {
body { margin-top: 0.5in; margin-right: 0in; margin-bottom: 0in; margin-left: 0in; }
}
@page { margin-top: 0.5in; margin-right: 0in; margin-bottom: 0in; margin-left: 0in; size: US-Letter; }
ul { margin: 0; padding: 0; }
ul.labels li {
margin: 0 0.1in 0 0;
padding: 0;
float: left;
width: 2.625in;
height: 1.25in !important;
display: block;
font-family: "Lato", Arial, Helvetica, sans-serif;
font-size: 11pt;
}
ul.labels li:nth-of-type(31n+31) { page-break-inside: avoid;}
ul.labels li div.address {
border:1px solid black;
margin-left: 0.25in;
margin-top: 0.1in;
width: 91%;
}
.avatar {
width: 50px;
height: 50px;
border-radius: 25px 25px 25px 25px;
-moz-border-radius: 25px 25px 25px 25px;
-webkit-border-radius: 25px 25px 25px 25px;
}
</style>
</head>
<body>
<ul class="labels">
{% for person in people %}
<li>
<div class="address">
<img class="avatar" src="{{ person.photo_url }}" />
{{ person.name }} <br />
<span style="color:blue">▢ Active</span><br />
<span style="color:orange">▢ Prospect</span><br />
<span style="color:red">▢ Make Inactive</span><br />
</div>
</li>
{% endfor %}
</ul>
</body>
</html>