Next Field Record for html block?

[Jorozcorosado]

So I built a custom table using multiple html blocks and list datapage, however now I'm wondering if I could include more than just [@field:fieldname] on the table it would be more useful to have the following record on the table as another column.... I tried [@field:fieldname+1] hahah which obviously did not work

 

The reason I did the custom Table was because I could not transpose the tablular report :/

 

Thanks,

Jonathan

[DefinitelyNot31337]

If you have a timestamp field on your table, you can use a Calculated Field to do so. The syntax is as follows:

SELECT fieldname
FROM yourTable
WHERE timestampfield > target.[@field:timestampfield]

 

It should get the value of the next record on your table. Note that using a criteria to filter the DataPage does not affect the SQL query, it still returns the next record FROM THE TABLE, however, you may add criteria to the WHERE clause of your SQL Statement.

===

Also if by transpose you mean in terms of X and Y,  I believe that would be impossible in Caspio since we cannot dynamically generate columns on a Tabular Report, and you can have as many rows as you want.

[SunakoChan]

Hi @Jorozcorosado,

As I understand that you wanted to add another field in the table, that is possible. You just need to go table >table design > below of the field that you have you can add another field just type character or name of the field, then choose DataType beside of the name of the field. Here is a helpful Howto article: https://howto.caspio.com/tables-and-views/creating-and-modifying-a-table/

[Jorozcorosado]

13 minutes ago, SunakoChan said:

Hi @Jorozcorosado,

As I understand that you wanted to add another field in the table, that is possible. You just need to go table >table design > below of the field that you have you can add another field just type character or name of the field, then choose DataType beside of the name of the field. Here is a helpful Howto article: https://howto.caspio.com/tables-and-views/creating-and-modifying-a-table/

I don't think you got my question, so here... this a row in my table I created using html... However it only shows the fields for that record... I want it to show the following record on the table as well.

 <tr id="row83">
            <td>Blah Blah Blah Blah Blah</td>
            <td>[@field:fieldname1]</td>
            <td>[@field:fieldname2]</td>        
      ***<td>[@field:fieldname1](NEXT RECORD)</td>***  --- Wanting to do
      ***<td>[@field:fieldname2](NEXT RECORD)</td>*** --- Wanting to do
        </tr>

[JolliBeng]

Hi @Jorozcorosado,

Can you provide some screenshots of your expected output?

 

~JolliBeng

[SunakoChan]

Hi @Jorozcorosado, I understand that  you wanted to pull the another record for that field.For you to be able to achieve that you need to use a calculate field or value and use select statement to get the specific record. 

For reference you may check this links:
- https://howto.caspio.com/function-reference/
- https://howto.caspio.com/datapages/datapage-components/calculated-values/

I hope this helps.