Create Table

Hello @hheyhey568

You should generate the table as part of the equation and visualize it in another field, like an “HTML Content” field.

For example, assuming you have the equation (fieldname1+fieldname3)*fieldname2, and you want to generate a table by increasing the fieldname2 value from 1 to 10:

1. Insert an “HTML Content” field in the form with a div tag as its content where display the table:

<div class="table-here"></div>

2. Edit the equation as follows:

(function(){
    var table = '<table><thead><tr><th>Field Value</th><th>Result</th></tr></thead>';
        table += '<tbody>';
    for(var i = 1; i <= 10; i++)
    {
        table += '<tr><td>'+(fieldname2+i)+'</td><td>'+((fieldname1+fieldname3)*(fieldname2+i))+'</td></tr>';
    }
    table += '</tbody></table>';
    jQuery('.table-here').html(table);
    return table;
})()

Best regards.

Hello,

Continuing with the previous example, the equation can be edited as follows:

(function(){
    var table = '<table><thead><tr><th>PipeID</th><th>OutputS</th></tr></thead>';
        table += '<tbody>';
    
    for(var i = 0; i < 10; i++)
    {    
        var PipeID;
        PipeID=(fieldname14+i)*25.4/1000;

        var PipeOD;
        PipeOD=fieldname62*25.4/1000;

        var CSArea;
        CSArea=Math.PI/4*PipeID*PipeID;

        var FlowRate;
        if(fieldname65=="m3/hr") FlowRate=fieldname64;
        if(fieldname65=="US GPM") FlowRate=fieldname64*0.22712470704;

        var Velocity;
        Velocity=(FlowRate/3600)/CSArea;

        var FroudeN;
        FroudeN=Velocity/POW(9.81*PipeID,0.5);

        var Submerge;
        Submerge=PipeOD*(1+2.3*FroudeN);

        getField(68).setVal(PREC(Submerge,2));

        var OutputS;

        if(fieldname66=="m") OutputS=Submerge;
        if(fieldname66=="ft") OutputS=Submerge*3.28084;
        if(fieldname66=="inch") OutputS=Submerge*3.28084*12;

        OutputS = PREC(OutputS,2);
        table += '<tr><td>'+PipeID+'</td><td>'+OutputS+'</td></tr>';
    }   
    table += '</tbody></table>';
    jQuery('.table-here').html(table);
    return table;
})()

Please, note I’m increasing the value of the fieldname14 field when generating the PipeID, PipeID=(fieldname14+i)*25.4/1000;

It is only an example. You should increase the values as you want.

Best regards.

Hello @hheyhey568

In this case, you should create an array with the values and walk through this array.

The piece of code to vary would be:

    var values = [0.5,0.8,1.5];
    for(var i in values)
    {    
        var PipeID;
        PipeID=(fieldname14+values[i])*25.4/1000;

I’m sorry, but the support service does not cover the implementation of user projects (forms or formulas). If you need us to implement your project, you can contact us through our website: Custom Coding Service

Best regards.

Hello @hheyhey568

Yes, that’s possible. You must use the CFFCHART operation to generate the chart. The “PipeID” list would be used for labels and “OutputS” for the dataset data list.

More information by reading the following blog post:

https://cff.dwbooster.com/blog/2019/05/27/charts

Best regards.