Jump to content
  • 0

Next Field Record for html block?


Go to solution Solved by DefinitelyNot31337,

Question

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

Link to post
Share on other sites

5 answers to this question

Recommended Posts

  • 1
  • Solution

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.

Link to post
Share on other sites
  • 0

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/

Link to post
Share on other sites
  • 0
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>

Link to post
Share on other sites
  • 0

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.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...