When I sync a table to another database a comma is added in the target field if the source field was a rollup or a formula.
Why is this happening and what do I do to fix it?
How do I remove a comma from in front of an email that has been extracted from a rollup. I am very new to this formula writing.
I have a rollup field that has two emails in it. I have extracted the first email by itself. However, the second email ...
This may have been covered, but I cannot find it. I have a field that has several emails in it. It is a lookup field I need to extract the first email in the list. Can someone help me with the formula?
This seems simple but I am not sure how to accomplish this. I have my educators complete a form that requires them to enter their course start dates in ISO. This format is important for some concatenate fields and dropdown menus in other tables and...
Brilliant. I am doing the happy dance. Thank you. Those REGEX thingies are like martian speak to me.
:kiss: .
For anyone looking over our shoulders, this was the final formula: REGEX_EXTRACT({One email}, “[^,]*”)
Where, {One email} was my referenc...
Thank you; however, that returned all of the multiples. To be clear, I used the second formula and the error message was removed but the extraction of only one email part of the formula gave me multiple emails again. Basically, the second formula w...
Hi Zack,
Thank you for your prompt response.
Works great for all fields except where I only have one email and then I get an error message. Is there a way to fix this?
