copying value at bottom of table
How can I copy the value at the bottom of a table when I select concatenate on a certain column?
Reason: We have contacts and we have them in certain email lists, but sometimes we need to narrow that down and then quickly copy the emails to send. Filtering is easy and when I select concatenate on the email column, all the emails I want are there properly, but I cannot copy that value.
4 replies
-
A possible workaround is to place code in a formula field. A
wherecondition could be added to this select statement. Or you could export.let t := (select Table1);let e := concat(t.email);e -
But wouldn't I then have to change the formula every time I need a certain subset? I need this to be easy and quick for the employees.
I have a Table called "Email Lists" and it has a reference to contacts in a table for a particular event we host. Being able to quickly copy all those emails is easy, but sometimes emails need to be sent to a particular subset of that very quickly. Filtering in the referenced contacts table shows all the contacts it should go to and when I click concatenate for the emails, it lists all of them nicely, but I can't select that value to copy it. Is there an easy workaround for that besides exporting, which isn't super quick either.
-
You could create a new table with one record. Replace the default table view with a blank form view. Then add a button, plus a text field named "Filter" and a text (multiline) field named "Emails". Then add the following code to the button. Replace "Text" in line two with the name of the field that you filter:
let f := Filter;let t := (select 'Email Lists' where Text = f);let e := concat(t.Email);Emails := e -
Didn't need the new table, but got it to work, thank you!
Set another variable for the email list name so it filters the emails on in that list and with the entered filter and set it as a trigger so no need for a button.
Content aside
- 4 yrs agoLast active
- 4Replies
- 723Views