I am trying to create a custom quoting system and because all of the items I sell are custom and have varying prices, I have come up with a way to create the quotes using 2 tables. But I want to know if there is away to automatically add several reco...
I would like to omit the semi-colon when a field is blank, and I know it can be done using IF, however my brain cannot wrap around how to pull it together! Can anyone help?
Here’s my example:
The current Formula I am using:
Much appreciated :sligh...
Hello Community!
I am struggling with writing a formula for naming the main field in a table.
I would like the formula to name the field {Company} if the field {Company} is not blank and name the field {Last Name} - {First Name} if the {Company} fie...
I am trying to create a button to link to a client’s address and am getting a “about:blank#blocked” url when I click on it.
What am I missing?
The URL Formula I am using is:
ENCODE_URL_COM (“https://google.com/map/place/”& {address})
Or is there a be...
The challenge I have gotten myself into is this:
On the “Quoting” Table I have a drop down to select which quote - or ‘option’ - each line item falls under, so that I can create several quotes for one deal. Which I have set up to go from the “Quotes”...
Thank you, I will check this out in greater detail as it sounds very interesting. I did manage to get it to work with a standard set of automation rules. But I would like to start to learn more about how to use scripts.
Hi Adam; It does make sense. I actually managed to figure it out after I posted this by doing Create Record, Find Records & Update Record, but maybe next time I will try that way as it sounds simpler.
Follow up question, is there a way to make it so ...
So, I got it to work after retyping it several times! Must have been doing something weird. But I am not able to omit the first ; if Manufacturer is empty.
