newbie here… I’ve just imported a bunch of items into my monday.com board. One of my fields isn’t mapping correctly and actually pulled in two (potentially 3) separate fields. Ive attempted to separate the fields using both TRIM, left and right functions and even a REGEX function and no avail… can someone help me?
Basically i want to delete the first “server location:” and extract the end “client name” from the text string located in my column “Server location”
Tagging @JCorrell (your video on secret excel functions has helped A LOT)
Current:
Server Location (this is a text field):
Server Location:Z:\example text\example folder\example fileClient Name - first name last name (Client Company)
Hey Jim!
No, i’ll need the fix to massage the way the data has come in. I have about 5k items i’m trying to update. and the reimporting of that data isnt possible.
I’m very familiar with excel and had originally thought that the format in monday would mimic my excel formulas, but alas, i’m stuck.
@JTruppa, currently there is no way to use monday formulas to change column values. You use the General Caster app in the marketplace to do that. The formulas will be more complicated than in Excel because they don’t support the new Excel text functions.
I won’t have time to create the formulas until Thursday. Maybe someone else can jump in with the General Caster formulas or another way to do it.
GCavin
(Gilles Cavin - Reinventing Formulas in monday.com)
5
Hi Jennifer,
You may want to look at the Advanced Formula Booster, the 3rd-party app that reinvents formulas in monday.
In this particular case, it is so much more powerful, because AFB not only allows you to create formulas that read and update columns in the same row (item), but it can update all the rows of a group or a board at the same time. You’ll notice that its syntax editor can accomodate multiple lines of codes and that within one formula, you can update multiple columns in multiple items.
Take a look at this video. I tried to reproduce your use case, but I am not 100% sure of your syntax. I thought you were missing a slash between example file and Client name. In any case, if I got it wrong, the formula could be adjusted pretty easily.
As you can see in the screen at the top left of the video, you can execute the formula directly from the editor without having to create any automation, considering it is a one-time thing.
Here is the syntax of the formula. I used Reg Ex since you are familiar with them.
Notice the use of the BoardItems. prefix in all the column placeholders. This means that it retrieves all the column values for the whole board and when it is on the left of the equal signs, it means all the items are modified by this one line of code.
It may not work for 5k items at once. Never tested it and would be interested in testing it with you. Let me know.
Hello @JCorrell@GCavin I have a lot of datas in my monday.com boards, Is there is way or formula to know if i repeated the same item number within the board?
GCavin
(Gilles Cavin - Reinventing Formulas in monday.com)
9
Hi Israel,
With the Advanced Formula Booster, yes. One question though: you have your item number in a column (is it a column or the item name?). Where would you want the result of that calculation to be written to?
@Izzy, If Giles solution will work for you, I’d go that way. If not, the only way to do that I am aware of to do that would be to use something like Make to do that.
Alright, Thank you so much
So as is it now, Can I send an email campaigns on monday which will include contents Images?
And how can I track a customer reply go this email on monday.com?
Like if a customer reply is to the email, is there a features that let me know on monday.com?
