Connected columns

Platform discussions
1

Hi,
i need to connect columns, to be clear in my process i add a new item and fill all the information including “start value” and “end value”, and then i stop working on this item, i add a new one i need to refill start value from the previous items end value. “start value” and “end value” for me are columns

2

Hi @lizi ,

This is solvable albeit with a few tweaks. You can automatically pull the previous item’s “End Value” into your new item’s “Start Value” column. However, you’d have to use third party integration tools. Here is the best approach I could think of:

  1. Set Up Your Board:
    • Add an “Item ID” column that auto-generates unique IDs (e.g., SID-001, SID-002).
    • Add a “Last Item ID” column (text) where users can reference the previous item (e.g., SID-001 → SID-002 links to SID-001).
  2. Automate with Make .com (Formerly Integromat)
    • Trigger: New item created in your board.
    • Action:
      1. Use the “Last Item ID” to fetch the previous item’s “End Value.”
      2. Update the new item’s “Start Value” with the previous “End Value.”
  3. Example Flow:
    • Item SID-004 has “End Value” = 100.
    • When SID-005 is created with “Last Item ID” = SID-004, Make.com pulls 100 and sets it as SID-005’s “Start Value.”

Why This Works:

  • No Manual Entry: Eliminates copying values between items.
  • Scalable: Works for any number of items.
  • Flexible: Adjustable for other column types (dates, numbers, etc.).

Need Help?
If you have any questions or need further assistance, feel free to reach out to me via email at mail@creativebits.us or Contact Creative Bits. We’d be happy to help!

3

Add a “Last Item ID” column (text) where users can reference the previous item (e.g., SID-001 → SID-002 links to SID-001) - what does this part means and how can i set this up?

4

Hi @lizi ,

I’ve attached images for your reference.

image
image1592×748 80.3 KB

This is how you set up a custom key, add a column called “Item ID” click the (…) dots on the column > choose “Settings” > select “Customize Item ID column”. This brings you here. Here you can customize your ID however you want eg. “SID-001”

image
image1601×859 115 KB

Next is an AI column, Monday.com has been making some improvements on their AI. Add a text column called “Prev. Item ID” or “Last Item ID” as I had stated in my previous post. Click the (…) dots on the column again > choose “Autofill with AI” > Under “AI Action” choose “Custom Action” then insert your prompt as you can see in the image attached. This helps you get the Item ID of the item before it.

image
image1608×763 66.1 KB

As for the Make.com third party integration. Create a scenario that pulls the “End Value” of a previous item and inserts it as the “Start Value” of the New Item created.

If you want further help Contact Creative Bits. I’d be happy to help!

Cheers.

1 Like
5

Eric, thank you so so much for this detailed information. this is really helpful for me.
i have one more problem in using Make. i dont have an experience in Make so its a bit confusing for me.
Action:
1. Use the “Last Item ID” to fetch the previous item’s “End Value.”
** 2. Update the new item’s “Start Value” with the previous “End Value.” - please if you can give an instructions how can i do it technically in Make i would be so grateful of you.
thank you so much for your time and help