HiI have a formula that compares a rollup to a text field and then returns any new additions to the rollup. However it seems to be returning an extra character, could anyone help me figure it out please?From this:'Nelson Dance Festival- 2024, Royal T...
Hello. I have a lookup field which lists the age groups that are related to all the linked records. I have a formula field which I’d like to show ‘Senior’ if the lookup field contains Senior, ‘Intermediate’ if it contains Intermediate (but not Senior...
Hi. I would appreciate help with the following:
I have the fields Country (required field), Region and Title. I need to concatenate these fields in different ways depending on which fields are filled.
-If just Region is filled then Region, Country
-I...
Hello. I am trying to automate linking one record in one table to several records in another table.
I have one table called ‘Payments’ and another called ‘Entries’. Each payment is for several entries. Once a record is created in Payments I need that...
Hello.
Is it possible to create an automation that, when triggered, will update all records linked to a common record?
Example:
3 tables- Customers, Entries, Payments
In Entries there will be several records linked to a customer. When a customer make...
Thank you so much for your help! With an extra ')' it worked perfectly!IF(LEN(ARRAYJOIN({Rollup Festivals Entered},", "))-LEN({Static Festivals Entered})>0, REPLACE(ARRAYJOIN({Rollup Festivals Entered},', '), 1, 2+LEN({Static Festivals Entered}),'')...
This looks great! It would be even better if the Allow users to edit and create records were separate. I'd like for my users to edit records but not create new ones.
Hi @Kamille_Parks I’ve managed to do it now. I found the records in Entries but then updated the record in Payments by adding the list of found records. Phew! Thank you anyway!
