Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone!
I have such code:
Spreadsheet_List:
Load * Inline
[
Spreadsheet_ID, Spreadsheet_Key, Spreadsheet_Name
1, Test 1, Salesforce
2, Test_2, HR
];
For Each a in FieldValueList('Spreadsheet_ID')
trace Spreadsheet_ID $(a);
Let vSpreadsheet_Key = Peek('Spreadsheet_Key',$(a),'Spreadsheet_List');
Let vSpreadsheet_Name = Peek('Spreadsheet_Name',$(a),'Spreadsheet_List');
Trace Spreadsheet_Key $(vSpreadsheet_Key) Spreadsheet_Name $(vSpreadsheet_Name) ;
Next a
And for some reason this loop does not go through" Spreadsheet_List" table row by row. Instead it is simply jump into last row and omit first one. Ignoring "Salesforce" data and starting from "HR" data.
Could you please help to figure out what's wrong with this code? Why it does not goes all rows in a table?
@Peony when you use peek, record reference starts with 0. Here you are passing Id from 1, so in your variable subtract 1
Let vSpreadsheet_Key = Peek('Spreadsheet_Key',$(a)-1,'Spreadsheet_List');
Let vSpreadsheet_Name = Peek('Spreadsheet_Name',$(a)-1,'Spreadsheet_List');
@Peony when you use peek, record reference starts with 0. Here you are passing Id from 1, so in your variable subtract 1
Let vSpreadsheet_Key = Peek('Spreadsheet_Key',$(a)-1,'Spreadsheet_List');
Let vSpreadsheet_Name = Peek('Spreadsheet_Name',$(a)-1,'Spreadsheet_List');
Indeed! @Kushal_Chawda Thank you for help!