I've got 3 tables - 1) Athlete, 2) Athlete Races and 3) Athlete Weekly Training Score. 1 is linked to 2 and 3, but 2 and 3 aren't linked. 3 is updated every week, with a new entry (score) per athlete each week.For any relevant entries in 2) (i.e. whe...
I've got an interface showing a list of all customers who we are awaiting information from.How would I go about sending those customers an email, when I click a button to do so in an interface? I don't want to do it automatically when they enter a vi...
Hi! So I have fieldA that contains a string of numbers & separators, rolled up from another table (e.g. "10|15|22").I then have fieldB that contains an integer.I need to be able to split the string, compare each number to that in fieldB and add the n...
I have a customer (athlete) table that is one row per customer. And a comms table, that logs when each customer posts something in our community (circle) via Zapier.Then, in the customer table I use a rollup to display the date of each customer's las...
I have a 'customer' table (one row per customer - name, email etc), and I have a 'contact' table that records the date of every instance of a customer contacting us (customer ID, date of contact etc). How would I pull in 'date of contact' into the cu...
Thanks Jody, sorry - I should have been clearer - it's not always 3 entries in the string I'm splitting. Technically it could be anything from 0 upwards. Also, once the string has been split, will its parts be treated as integers?
