Trying to increment each key item by 1

I’m trying to increment the Key value of “Row” by 1 per item, but when I run the function, it increments all rows by 1 resulting in all rows having the same value of 2. Instead, I need it to increment based on the previous number (ie. 1,2,3,4, etc).

As per the workflow below, I am stating a default value of 1 in row in Set FSA. After running the function, the result of row all become 2 instead of incremental. Can anyone help me with this?

Thanks! :smiley:

Please share the workflow

Share the output returned by the last node

  {
    "prop_id": "78892192453168",
    "city_id": 5,
    "status": "Owned",
    "centerlat": "36.723596746979261",
    "centerlng": "-119.81462389159415",
    "labels": {
      "fsa_allow": true
    },
    "neighborhood": {
      "id": 269,
      "name": "EDISON"
    },
    "area": 82,
    "city": {
      "id": 5,
      "name": "Fresno"
    },
    "feature": null,
    "full_address": "210 W VALENCIA AVE",
    "mint_price": 902,
    "ownership_changed_at": "2022-02-13T06:40:47.796Z",
    "yield_per_hour": 0.015153599879704409,
    "last_purchased_price": 902,
    "owner": "lo2uvsqbpm25",
    "owner_username": "clevelandian",
    "price": 902,
    "collection": {
      "id": 57,
      "name": "The Fresno",
      "description": "Collection",
      "category": 1,
      "yield_boost": 1.2
    },
    "time": "02/13/2022 01:40:47",
    "c_id": 1,
    "row": 2,
    "FSA": true,
    "City": "Fresno",
    "YPH": "=ROUND(0.015153599879704409,4)",
    "last_price": 902,
    "c_name": "The Fresno",
    "col": "=IF(O2 = 1,\"🔵\", IF(O2 = 2, \"🟣\", IF(O2 = 3, \"🟠\", IF(O2 = 4, \"🔴\", IF(O2 = 5, \"🟡\", \"⚪\")))))"
  },
  {
    "prop_id": "78479893379879",
    "city_id": 16,
    "status": "Owned",
    "centerlat": "36.061143411997122",
    "centerlng": "-86.652492696542765",
    "labels": {
      "fsa_allow": true
    },
    "neighborhood": {
      "id": 1290,
      "name": "PRIEST LAKE"
    },
    "area": 8,
    "city": {
      "id": 16,
      "name": "Nashville"
    },
    "feature": null,
    "full_address": "738 PIPPIN DR",
    "mint_price": 1096,
    "yield_per_hour": 0.01841279985383152,
    "ownership_changed_at": "2022-09-19T18:39:37.500Z",
    "last_purchased_price": 3040,
    "owner": "lo2uvsqbpm25",
    "owner_username": "clevelandian",
    "price": 3040,
    "collection": {
      "id": 217,
      "name": "Nashville",
      "description": "Collection",
      "category": 1,
      "yield_boost": 1.25
    },
    "time": "09/19/2022 14:39:37",
    "c_id": 1,
    "row": 2,
    "FSA": true,
    "City": "Nashville",
    "YPH": "=ROUND(0.01841279985383152,4)",
    "last_price": 3040,
    "c_name": "Nashville",
    "col": "=IF(O2 = 1,\"🔵\", IF(O2 = 2, \"🟣\", IF(O2 = 3, \"🟠\", IF(O2 = 4, \"🔴\", IF(O2 = 5, \"🟡\", \"⚪\")))))"
  },
  {
    "prop_id": "77159324253440",
    "city_id": 32,
    "status": "For sale",
    "full_address": "10603 S MAIN ST",
    "neighborhood": {
      "id": 1395,
      "name": "BROADWAY-MANCHESTER"
    },
    "labels": {
      "fsa_allow": true
    },
    "area": 26,
    "centerlat": "33.939927709960571",
    "centerlng": "-118.27420811894403",
    "city": {
      "id": 32,
      "name": "Los Angeles"
    },
    "feature": null,
    "last_purchased_price": 7400,
    "mint_price": 2756,
    "owner": "lo2uvsqbpm25",
    "owner_username": "clevelandian",
    "ownership_changed_at": "2022-09-18T20:01:12.000Z",
    "price": 8600,
    "yield_per_hour": 0.046300799632444954,
    "on_market": {
      "token": "8600.00 UPX",
      "fiat": "0.00 FIAT",
      "allow_fiat_offers": false,
      "allow_token_offers": true,
      "allow_prop_offers": true,
      "currency": "UPX",
      "markup": 312
    },
    "collection": {
      "id": 21,
      "name": "City Pro",
      "description": "Limited Collection",
      "category": 2,
      "yield_boost": 1.4
    },
    "time": "09/18/2022 16:01:12",
    "c_id": 2,
    "row": 2,
    "FSA": true,
    "City": "Los Angeles",
    "YPH": "=ROUND(0.046300799632444954,4)",
    "last_price": 7400,
    "c_name": "City Pro",
    "col": "=IF(O2 = 1,\"🔵\", IF(O2 = 2, \"🟣\", IF(O2 = 3, \"🟠\", IF(O2 = 4, \"🔴\", IF(O2 = 5, \"🟡\", \"⚪\")))))"
  },
  {
    "prop_id": "81655839134751",
    "city_id": 37,
    "status": "Owned",
    "centerlat": "41.162611429261432",
    "centerlng": "-8.6141858797369935",
    "labels": {
      "fsa_allow": true
    },
    "neighborhood": {
      "id": 1926,
      "name": "CEDOFEITA"
    },
    "area": 11,
    "city": {
      "id": 37,
      "name": "Porto"
    },
    "feature": null,
    "full_address": "RUA DO MONTE PEDRAL 8B",
    "mint_price": 3135,
    "ownership_changed_at": "2022-08-31T15:33:32.534Z",
    "yield_per_hour": 0.05266799958189947,
    "last_purchased_price": 3135,
    "owner": "lo2uvsqbpm25",
    "owner_username": "clevelandian",
    "price": 3135,
    "collection": {
      "id": 343,
      "name": "Cedofeita",
      "description": "Collection",
      "category": 2,
      "yield_boost": 1.64
    },
    "time": "08/31/2022 11:33:32",
    "c_id": 2,
    "row": 2,
    "FSA": true,
    "City": "Porto",
    "YPH": "=ROUND(0.05266799958189947,4)",
    "last_price": 3135,
    "c_name": "Cedofeita",
    "col": "=IF(O2 = 1,\"🔵\", IF(O2 = 2, \"🟣\", IF(O2 = 3, \"🟠\", IF(O2 = 4, \"🔴\", IF(O2 = 5, \"🟡\", \"⚪\")))))"
  },
  {
    "prop_id": "81654480180076",
    "city_id": 37,
    "status": "Owned",
    "centerlat": "41.160513725032381",
    "centerlng": "-8.6206270872911883",
    "labels": {
      "fsa_allow": true
    },
    "neighborhood": {
      "id": 1926,
      "name": "CEDOFEITA"
    },
    "area": 12,
    "city": {
      "id": 37,
      "name": "Porto"
    },
    "feature": null,
    "full_address": "RUA DOS BURGAES 379B",
    "mint_price": 3420,
    "ownership_changed_at": "2022-09-01T10:04:08.832Z",
    "yield_per_hour": 0.05745599954389033,
    "last_purchased_price": 3420,
    "owner": "lo2uvsqbpm25",
    "owner_username": "clevelandian",
    "price": 3420,
    "collection": {
      "id": 343,
      "name": "Cedofeita",
      "description": "Collection",
      "category": 2,
      "yield_boost": 1.64
    },
    "time": "09/01/2022 06:04:08",
    "c_id": 2,
    "row": 2,
    "FSA": true,
    "City": "Porto",
    "YPH": "=ROUND(0.05745599954389033,4)",
    "last_price": 3420,
    "c_name": "Cedofeita",
    "col": "=IF(O2 = 1,\"🔵\", IF(O2 = 2, \"🟣\", IF(O2 = 3, \"🟠\", IF(O2 = 4, \"🔴\", IF(O2 = 5, \"🟡\", \"⚪\")))))"
  },
  {
    "prop_id": "81654429848687",
    "city_id": 37,
    "status": "Owned",
    "centerlat": "41.160368922543306",
    "centerlng": "-8.6114768766175676",
    "labels": {
      "fsa_allow": true
    },
    "neighborhood": {
      "id": 1926,
      "name": "CEDOFEITA"
    },
    "area": 11,
    "city": {
      "id": 37,
      "name": "Porto"
    },
    "feature": null,
    "full_address": "RUA DE ANTERO DE QUENTAL 252",
    "mint_price": 3135,
    "ownership_changed_at": "2022-08-31T10:35:04.659Z",
    "yield_per_hour": 0.05266799958189947,
    "last_purchased_price": 3135,
    "owner": "lo2uvsqbpm25",
    "owner_username": "clevelandian",
    "price": 3135,
    "collection": {
      "id": 343,
      "name": "Cedofeita",
      "description": "Collection",
      "category": 2,
      "yield_boost": 1.64
    },
    "time": "08/31/2022 06:35:04",
    "c_id": 2,
    "row": 2,
    "FSA": true,
    "City": "Porto",
    "YPH": "=ROUND(0.05266799958189947,4)",
    "last_price": 3135,
    "c_name": "Cedofeita",
    "col": "=IF(O2 = 1,\"🔵\", IF(O2 = 2, \"🟣\", IF(O2 = 3, \"🟠\", IF(O2 = 4, \"🔴\", IF(O2 = 5, \"🟡\", \"⚪\")))))"
  },
  {
    "prop_id": "81656879322022",
    "city_id": 37,
    "status": "Owned",
    "centerlat": "41.164350518193508",
    "centerlng": "-8.6185681060083628",
    "labels": {
      "fsa_allow": true
    },
    "neighborhood": {
      "id": 1926,
      "name": "CEDOFEITA"
    },
    "area": 14,
    "city": {
      "id": 37,
      "name": "Porto"
    },
    "feature": null,
    "full_address": "RUA DO QUANZA 104A",
    "mint_price": 3990,
    "ownership_changed_at": "2022-09-01T10:06:32.454Z",
    "yield_per_hour": 0.06703199946787206,
    "last_purchased_price": 3990,
    "owner": "lo2uvsqbpm25",
    "owner_username": "clevelandian",
    "price": 3990,
    "collection": {
      "id": 343,
      "name": "Cedofeita",
      "description": "Collection",
      "category": 2,
      "yield_boost": 1.64
    },
    "time": "09/01/2022 06:06:32",
    "c_id": 2,
    "row": 2,
    "FSA": true,
    "City": "Porto",
    "YPH": "=ROUND(0.06703199946787206,4)",
    "last_price": 3990,
    "c_name": "Cedofeita",
    "col": "=IF(O2 = 1,\"🔵\", IF(O2 = 2, \"🟣\", IF(O2 = 3, \"🟠\", IF(O2 = 4, \"🔴\", IF(O2 = 5, \"🟡\", \"⚪\")))))"
  },
  {
    "prop_id": "81654748615794",
    "city_id": 37,
    "status": "Owned",
    "centerlat": "41.160887200817754",
    "centerlng": "-8.6113718931185144",
    "labels": {
      "fsa_allow": true
    },
    "neighborhood": {
      "id": 1926,
      "name": "CEDOFEITA"
    },
    "area": 15,
    "city": {
      "id": 37,
      "name": "Porto"
    },
    "feature": null,
    "full_address": "RUA DE ANTERO DE QUENTAL 312",
    "mint_price": 4275,
    "ownership_changed_at": "2022-09-01T07:33:27.842Z",
    "yield_per_hour": 0.07181999942986292,
    "last_purchased_price": 4275,
    "owner": "lo2uvsqbpm25",
    "owner_username": "clevelandian",
    "price": 4275,
    "collection": {
      "id": 343,
      "name": "Cedofeita",
      "description": "Collection",
      "category": 2,
      "yield_boost": 1.64
    },
    "time": "09/01/2022 03:33:27",
    "c_id": 2,
    "row": 2,
    "FSA": true,
    "City": "Porto",
    "YPH": "=ROUND(0.07181999942986292,4)",
    "last_price": 4275,
    "c_name": "Cedofeita",
    "col": "=IF(O2 = 1,\"🔵\", IF(O2 = 2, \"🟣\", IF(O2 = 3, \"🟠\", IF(O2 = 4, \"🔴\", IF(O2 = 5, \"🟡\", \"⚪\")))))"
  },
  {
    "prop_id": "81657281975064",
    "city_id": 37,
    "status": "Owned",
    "centerlat": "41.164939701456298",
    "centerlng": "-8.6237234390419051",
    "labels": {
      "fsa_allow": true
    },
    "neighborhood": {
      "id": 1926,
      "name": "CEDOFEITA"
    },
    "area": 14,
    "city": {
      "id": 37,
      "name": "Porto"
    },
    "feature": null,
    "full_address": "RUA FREIRE DE ANDRADE 22C",
    "mint_price": 3990,
    "ownership_changed_at": "2022-09-01T08:34:05.007Z",
    "yield_per_hour": 0.06703199946787206,
    "last_purchased_price": 3990,
    "owner": "lo2uvsqbpm25",
    "owner_username": "clevelandian",
    "price": 3990,
    "collection": {
      "id": 343,
      "name": "Cedofeita",
      "description": "Collection",
      "category": 2,
      "yield_boost": 1.64
    },
    "time": "09/01/2022 04:34:05",
    "c_id": 2,
    "row": 2,
    "FSA": true,
    "City": "Porto",
    "YPH": "=ROUND(0.06703199946787206,4)",
    "last_price": 3990,
    "c_name": "Cedofeita",
    "col": "=IF(O2 = 1,\"🔵\", IF(O2 = 2, \"🟣\", IF(O2 = 3, \"🟠\", IF(O2 = 4, \"🔴\", IF(O2 = 5, \"🟡\", \"⚪\")))))"
  },
  {
    "prop_id": "81655553921919",
    "city_id": 37,
    "status": "Owned",
    "centerlat": "41.162277961807725",
    "centerlng": "-8.6200485006899292",
    "labels": {
      "fsa_allow": false
    },
    "neighborhood": {
      "id": 1926,
      "name": "CEDOFEITA"
    },
    "area": 23,
    "city": {
      "id": 37,
      "name": "Porto"
    },
    "feature": null,
    "full_address": "RUA DE MARRACUENE 104",
    "last_purchased_price": 15000,
    "mint_price": 6555,
    "owner": "lo2uvsqbpm25",
    "owner_username": "clevelandian",
    "ownership_changed_at": "2022-08-29T16:35:06.000Z",
    "price": 15000,
    "yield_per_hour": 0.1101239991257898,
    "collection": {
      "id": 343,
      "name": "Cedofeita",
      "description": "Collection",
      "category": 2,
      "yield_boost": 1.64
    },
    "time": "08/29/2022 12:35:06",
    "c_id": 2,
    "row": 2,
    "FSA": false,
    "City": "Porto",
    "YPH": "=ROUND(0.1101239991257898,4)",
    "last_price": 15000,
    "c_name": "Cedofeita",
    "col": "=IF(O2 = 1,\"🔵\", IF(O2 = 2, \"🟣\", IF(O2 = 3, \"🟠\", IF(O2 = 4, \"🔴\", IF(O2 = 5, \"🟡\", \"⚪\")))))"
  },
  {
    "prop_id": "81655453258625",
    "city_id": 37,
    "status": "Owned",
    "centerlat": "41.162032250586343",
    "centerlng": "-8.6199352128847035",
    "labels": {
      "fsa_allow": true
    },
    "neighborhood": {
      "id": 1926,
      "name": "CEDOFEITA"
    },
    "area": 11,
    "city": {
      "id": 37,
      "name": "Porto"
    },
    "feature": null,
    "full_address": "RUA DE BRITO CAPELO 132",
    "mint_price": 3135,
    "ownership_changed_at": "2022-09-01T11:04:29.620Z",
    "yield_per_hour": 0.05266799958189947,
    "last_purchased_price": 3135,
    "owner": "lo2uvsqbpm25",
    "owner_username": "clevelandian",
    "price": 3135,
    "collection": {
      "id": 343,
      "name": "Cedofeita",
      "description": "Collection",
      "category": 2,
      "yield_boost": 1.64
    },
    "time": "09/01/2022 07:04:29",
    "c_id": 2,
    "row": 2,
    "FSA": true,
    "City": "Porto",
    "YPH": "=ROUND(0.05266799958189947,4)",
    "last_price": 3135,
    "c_name": "Cedofeita",
    "col": "=IF(O2 = 1,\"🔵\", IF(O2 = 2, \"🟣\", IF(O2 = 3, \"🟠\", IF(O2 = 4, \"🔴\", IF(O2 = 5, \"🟡\", \"⚪\")))))"
  },
  {
    "prop_id": "81656342451281",
    "city_id": 37,
    "status": "Owned",
    "centerlat": "41.163423800441862",
    "centerlng": "-8.6123011704045123",
    "labels": {
      "fsa_allow": true
    },
    "neighborhood": {
      "id": 1926,
      "name": "CEDOFEITA"
    },
    "area": 23,
    "city": {
      "id": 37,
      "name": "Porto"
    },
    "feature": null,
    "full_address": "RUA DE CUNHA JUNIOR 30",
    "mint_price": 6555,
    "ownership_changed_at": "2022-09-05T10:35:14.088Z",
    "yield_per_hour": 0.1101239991257898,
    "last_purchased_price": 6555,
    "owner": "lo2uvsqbpm25",
    "owner_username": "clevelandian",
    "price": 6555,
    "collection": {
      "id": 343,
      "name": "Cedofeita",
      "description": "Collection",
      "category": 2,
      "yield_boost": 1.64
    },
    "time": "09/05/2022 06:35:14",
    "c_id": 2,
    "row": 2,
    "FSA": true,
    "City": "Porto",
    "YPH": "=ROUND(0.1101239991257898,4)",
    "last_price": 6555,
    "c_name": "Cedofeita",
    "col": "=IF(O2 = 1,\"🔵\", IF(O2 = 2, \"🟣\", IF(O2 = 3, \"🟠\", IF(O2 = 4, \"🔴\", IF(O2 = 5, \"🟡\", \"⚪\")))))"
  },
  {
    "prop_id": "81631646391200",
    "city_id": 37,
    "status": "Owned",
    "centerlat": "41.123818873763646",
    "centerlng": "-8.5455167208989042",
    "labels": {
      "fsa_allow": true
    },
    "neighborhood": {
      "id": 1941,
      "name": "GONDOMAR (SAO COSME)"
    },
    "area": 45,
    "city": {
      "id": 37,
      "name": "Porto"
    },
    "feature": null,
    "full_address": "RUA DOURO A VISTA 50",
    "last_purchased_price": 7245,
    "mint_price": 7245,
    "owner": "lo2uvsqbpm25",
    "owner_username": "clevelandian",
    "ownership_changed_at": "2022-09-12T15:03:44.855Z",
    "price": 7245,
    "yield_per_hour": 0.12171599903376767,
    "collection": {
      "id": 350,
      "name": "Porto",
      "description": "Collection",
      "category": 1,
      "yield_boost": 1.25
    },
    "time": "09/12/2022 11:03:44",
    "c_id": 1,
    "row": 2,
    "FSA": true,
    "City": "Porto",
    "YPH": "=ROUND(0.12171599903376767,4)",
    "last_price": 7245,
    "c_name": "Porto",
    "col": "=IF(O2 = 1,\"🔵\", IF(O2 = 2, \"🟣\", IF(O2 = 3, \"🟠\", IF(O2 = 4, \"🔴\", IF(O2 = 5, \"🟡\", \"⚪\")))))"
  },
  {
    "prop_id": "81631310846885",
    "city_id": 37,
    "status": "Owned",
    "centerlat": "41.123332600800538",
    "centerlng": "-8.5453452065038924",
    "labels": {
      "fsa_allow": false
    },
    "neighborhood": {
      "id": 1941,
      "name": "GONDOMAR (SAO COSME)"
    },
    "area": 57,
    "city": {
      "id": 37,
      "name": "Porto"
    },
    "feature": null,
    "full_address": "TRAVESSA CLUBE DE CACADORES 258",
    "last_purchased_price": 9177,
    "mint_price": 9177,
    "owner": "lo2uvsqbpm25",
    "owner_username": "clevelandian",
    "ownership_changed_at": "2022-09-12T15:09:32.101Z",
    "price": 9177,
    "yield_per_hour": 0.15417359877610573,
    "collection": {
      "id": 350,
      "name": "Porto",
      "description": "Collection",
      "category": 1,
      "yield_boost": 1.25
    },
    "time": "09/12/2022 11:09:32",
    "c_id": 1,
    "row": 2,
    "FSA": false,
    "City": "Porto",
    "YPH": "=ROUND(0.15417359877610573,4)",
    "last_price": 9177,
    "c_name": "Porto",
    "col": "=IF(O2 = 1,\"🔵\", IF(O2 = 2, \"🟣\", IF(O2 = 3, \"🟠\", IF(O2 = 4, \"🔴\", IF(O2 = 5, \"🟡\", \"⚪\")))))"
  },
  {
    "prop_id": "81631075965849",
    "city_id": 37,
    "status": "Owned",
    "centerlat": "41.122874966980142",
    "centerlng": "-8.545600833534353",
    "labels": {
      "fsa_allow": true
    },
    "neighborhood": {
      "id": 1941,
      "name": "GONDOMAR (SAO COSME)"
    },
    "area": 23,
    "city": {
      "id": 37,
      "name": "Porto"
    },
    "feature": null,
    "full_address": "TRAVESSA CLUBE DE CACADORES 255",
    "last_purchased_price": 3703,
    "mint_price": 3703,
    "owner": "lo2uvsqbpm25",
    "owner_username": "clevelandian",
    "ownership_changed_at": "2022-09-12T15:04:14.534Z",
    "price": 3703,
    "yield_per_hour": 0.06221039950614792,
    "collection": {
      "id": 350,
      "name": "Porto",
      "description": "Collection",
      "category": 1,
      "yield_boost": 1.25
    },
    "time": "09/12/2022 11:04:14",
    "c_id": 1,
    "row": 2,
    "FSA": true,
    "City": "Porto",
    "YPH": "=ROUND(0.06221039950614792,4)",
    "last_price": 3703,
    "c_name": "Porto",
    "col": "=IF(O2 = 1,\"🔵\", IF(O2 = 2, \"🟣\", IF(O2 = 3, \"🟠\", IF(O2 = 4, \"🔴\", IF(O2 = 5, \"🟡\", \"⚪\")))))"
  },
  {
    "prop_id": "81636092352996",
    "city_id": 37,
    "status": "For sale",
    "centerlat": "41.13102345679701",
    "centerlng": "-8.5614926130147424",
    "labels": {
      "fsa_allow": false
    },
    "neighborhood": {
      "id": 1950,
      "name": "VALBOM"
    },
    "area": 136,
    "city": {
      "id": 37,
      "name": "Porto"
    },
    "feature": null,
    "full_address": "AVENIDA MIGUEL BOMBARDA 128",
    "last_purchased_price": 21896,
    "mint_price": 21896,
    "owner": "lo2uvsqbpm25",
    "owner_username": "clevelandian",
    "ownership_changed_at": "2022-09-12T16:13:48.430Z",
    "price": 20500,
    "yield_per_hour": 0.3678527970798312,
    "on_market": {
      "token": "20500.00 UPX",
      "fiat": "0.00 FIAT",
      "allow_fiat_offers": false,
      "allow_token_offers": true,
      "allow_prop_offers": true,
      "currency": "UPX",
      "markup": 94
    },
    "collection": {
      "id": 350,
      "name": "Porto",
      "description": "Collection",
      "category": 1,
      "yield_boost": 1.25
    },
    "time": "09/12/2022 12:13:48",
    "c_id": 1,
    "row": 2,
    "FSA": false,
    "City": "Porto",
    "YPH": "=ROUND(0.3678527970798312,4)",
    "last_price": 21896,
    "c_name": "Porto",
    "col": "=IF(O2 = 1,\"🔵\", IF(O2 = 2, \"🟣\", IF(O2 = 3, \"🟠\", IF(O2 = 4, \"🔴\", IF(O2 = 5, \"🟡\", \"⚪\")))))"
  }
]```

Hi @TheSmilez, if you just want to set a unique number for each row you could consider using an expression of {{ $position }} (if you want the first value to be 0) or {{ $position + 1 }} (if you want the first value to be one):

Check out this example workflow:

1 Like

Wow, I can’t believe I overlooked that expression.
Ended up adding +2 instead of 1 since the row started on the 2nd in sheets.
Did the trick, many thanks! :smiley:

1 Like

Tbh, it’s pretty well hidden (here), so not exactly obvious :smiley:

Anyway, glad to hear this worked for you!

1 Like

Awesome! That page is a huge help. Thanks again!