Jump to content
  • 0
Sign in to follow this  
Jorozcorosado

Next Field Record for html block?

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

Share this post


Link to post
Share on other sites

5 answers to this question

Recommended Posts

  • 1

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.

Share this post


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/

Share this post


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>

Share this post


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.

Share this post


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...
Sign in to follow this  

×
×
  • Create New...