I think I may not be correctly using this app, but I have a list of companies on a source board that trickles info down to the low-level boards but the item names are what I need to match to in the target boards (client names) and I am unable to do so… do I have to make the item name a short text in the target boards (without using a formula) ?

Hi @Yoggie

I was looking for a way to facilitate forms data entry for our users. But found out that integrations nor automations are applicable to forms.

So what I’m trying to do now is, when new item is created on a board, I want to lookup the name of the Requestor on the same board, and mirror Requestor’s phone number in the new item’s phone column.

Basically, if same Requestor’s name already on a board with phone number column value already available, I want to return this phone column’s value to a new row.

Is it possible to do that with your App?

I tried to do it but when I add a new item, once I enter Requestor name, the integration takes the null value from phone column of the new row, and updates phone of existing rows of the same Requestor to null.

I need it to do opposite thing. Take phone value from existing row and update new row with it.

How do I do it?

My current integration is:

Look Up a Value in Requestor in Test Summary, Requestor, Return Value from Phone and Mirror it to Phone

Thanks.

hi @Yoggie

Are you leaving the monday platform? Sorry to hear if that is the case.

Luckily users of your vLookApp can find an alternative here https://monday.com/marketplace/129

I’m sorry to see you go. I actually never got the recipe to work and could only use the mirror columns. I think Monday should add more excel like functions like your app.

@Yoggie why is that???

Hi @basdebruin

No I’m not leaving. But thanks for trying to help!

@hlopezvc - Monday reopened my account so everything’s cool.

You can keep using the app as usual.

Thats awesome!!! +1 for vlookup

Hi @Yoggie , is there a possibility to have the functionality to input values into the status column? (I’d like to trigger other automations based on Status changes once the vlookup is done). The vlookup right now only seems to work for Text columns.

Hi @Rohan-TAP

There’s a full version of the app that supports all column types.

Let me know if you want it, I’d let you in 🙂

Hello,

I am interested in the full version of the application.

Thanks

Hi @Jiri !

Please contact me at Yogev@Formrally.com

Also, check out other solutions:

Hi @yoggie I’m trying to use this to assign someone in a people column, matching to a people column in another board where the “Job #” text column matches between the 2 boards. It’s not working. Are people columns supported? I can’t figure out what I might be doing wrong, but Monday’s mirror columns are not sufficient for notifications/automations and I need a way to match/automate assigning a person in a new board based on other boards.

hi @kathonmonday

I can’t answer for @Yoggie but supporting all different column types requires serious work for the app developers. This app https://monday.com/marketplace/129 supports the People column (and a lot more) and is triggered on changes in the source value and changes in the key (“Job #”) in any of the two boards.

@basdebruin thanks! I looked into that but I’m trying to limit further third party integrations with $$ as I don’t have access to purchasing directly and have to make a really strong case for it. I just had our general caster upgraded, so I don’t think there’s a chance for that one. That app also looks like the cost is per lookup and I would need to employ it across several boards so I just see the costs going up and up.

I did figure out a workaround using general caster to cast the mirrored person to a dropdown column, and then creating an automation assigning a person based on the drop down column. It’s not as “dynamic” and requires an automation sequence per user, but it gets the job done for now.

hi @kathonmonday

Understood , that is probably the difference between free and paid apps 🙂

Hi @kathonmonday,

Yeah the free version doesn’t support all column types yet, you can use a formula to duplicate the user column as a work around.

I know it worked for other users.

Hi @Yoggie ,

vLookup is great, and seems to be solving a number of issues I’ve been having. One thing is still nagging though, and I may just be missing something. Am I able to use vLookup to pull data from multiple boards into one column? For instance, I have low-level-1 and low-level-2 boards with timelines. However when I try to create a high level and link lowl-level-1 and low-level-2’s timelines with a high level timeline, it appears that only one source board can feed into a particular column.

is that correct or am I missing an option to add multiple sources to a single column (the correct board being selected by the sourceid)?

Hi @lucidmattnj !

Actually I don’t think you missed anything, perhaps you need the apps’s full version that supports more complex use-cases.

Feel free to contact me here.

Cheers

Hi @Yoggie I have just tried to install this and use it but its saying its offline for Maintenance. Are you able to advise me please

Hi there, I tried to use this app and it says that it’s under maintenance. Any idea when it will be available to use again?

@silverberrytree

Try now

@Yoggie I’m having difficulty in using the integration.

I’m trialling it with Text columns only, and am not able to make anything work.

I can make it work within a board, but not across two boards?

Here is my current recipe:

Look Up a Value in Code in Target Board, Target Code, Return Value from Target Text and Mirror it to Text

Also - does this work for subitems, or items only?

Please advise, thank you.

Hi Yoggie, this app looks great.

I tried to use it, but when I go to Integration > Add to Board, it gives the error in the screenshot.

Hi!

@henri_qwm

The app is no longer free.

Contact me if you’re still interested.

Yogev@Formrally.com