Forum Discussion
MarkShnier__You
Qrew Legend
3 years agonp
The combined text summary field will summarize any text field. When you have a situation where you need to roll up words from a field that is not actually a text field just make a Mirror field like [email (text format)]
with the trivial formula of just
[email]
you can just roll up that text field in the upper direction and of course in the down direction you can just use a look up. Note also that if you need to get a combined text summary field rolled up from a grandchild to a parent then up to a grandparent, the other field type that can be used in a combined text summary field is actually a combined text summary field.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
IvanWeiss
3 years agoQrew Captain
Thanks Mark! Do I need to do anything to insert a comma or semi colon to have it work with emails in the future or can just make it a combined text summary?
------------------------------
Ivan Weiss
------------------------------
------------------------------
Ivan Weiss
------------------------------
- MarkShnier__You3 years ago
Qrew Legend
I need to understand what you intend to do with that list of emails and if these are users to just random emails.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- IvanWeiss3 years agoQrew CaptainNot users, I want to create a mailto button so that it will draft a new email with those emails repopulated
------------------------------
Ivan Weiss
------------------------------- MarkShnier__You3 years ago
Qrew Legend
I think that if you just convert the combined text field to text
ToText([my combined text field])
you will end up with a semi colon delimited string which the mail to command will accept OK. Not sure if you will need the formula to remove spaces as well as the separator is actually space semi space.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------