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!
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, \"🟡\", \"⚪\")))))"
}
]```