Jump to content

NailDyanC

Caspio Rockstar
  • Posts

    409
  • Joined

  • Last visited

  • Days Won

    11

Posts posted by NailDyanC

  1. Just want to add, in the recent release of Caspio  there are new features you may find useful and as part of our ongoing improvements to PDF report generation, the following layout and customization capabilities are now available.

    • Page Breaks – Page breaks can be inserted after any field.
    • Parameters in Header and Footer – In addition to existing system parameters, now data source fields can also be inserted in the header and footer of PDF files generated from details pages.
    • Watermarks – Text or image watermarks can be added to PDF reports.

    Learn more about PDF Download.

  2. On 2/6/2021 at 8:45 AM, NailDyanC said:

    Just to add to the previous comments above, a new PDF download option is available for the details pages of Reports, Calendars, Combined Chart and Reports, Details and Pivot Table DataPages. The PDF configuration for details pages is similar to the existing options available on results pages.

    Learn more about PDF reports generation.

    Just want to add, in the recent release of Caspio  there are new features you may find useful and as part of our ongoing improvements to PDF report generation, the following layout and customization capabilities are now available.

    • Page Breaks – Page breaks can be inserted after any field.
    • Parameters in Header and Footer – In addition to existing system parameters, now data source fields can also be inserted in the header and footer of PDF files generated from details pages.
    • Watermarks – Text or image watermarks can be added to PDF reports.

    Learn more about PDF Download.

  3. Hi Just to add to the previous comment above, you may also find these video tutorials useful:

     

    And just an update, you can now add the Calculated Value form element to Update Forms and Details Pages to generate dynamic calculations as users interact with your forms. Previously, this feature was only available in Submission Forms. You may check this link: https://howto.caspio.com/release-notes/caspio-bridge-17-0/

  4. Hi, it seems that you have submitted twice your question, I answered that here:

    CASE
    WHEN [@field:Lucy]= 'TRUE' AND [@field:Stack] = 'TRUE' AND [@field:Edward] = 'TRUE' AND [@field:Sebby] = 'TRUE' AND [@field:Maria] = 'TRUE' THEN 'Account Manager' ELSE
    CASE
    WHEN [@field:Lucy]= 'TRUE' THEN 'LUCY' ELSE ' '
    END + ' ' + CASE
    WHEN [@field:Stack]= 'TRUE' THEN 'STACK' ELSE ' '
    END + ' ' +
    CASE
    WHEN [@field:Edward]= 'TRUE' THEN 'EDWARD' ELSE ' '
    END + ' ' + CASE
    WHEN [@field:Sebby]= 'TRUE' THEN 'SEBBY' ELSE ' '
    END + ' ' + CASE
    WHEN [@field:Maria]= 'TRUE' THEN 'MARIA' ELSE ' '
    END
    END

     

  5. Hi, I have the same issue as well. I can't view or see the value of a virtual field(calculated values) on PDFs. One workaround that I have done is use a calculated field instead since it seems that calculated values is being read by the system as virtual display only. Also, you may try to add another field in your table then use that field to hold the value of your calculations(change the form element of it as a calculated value) and see if that works.

  6. Hi @smsnyus1, this is a very good workflow. What I would like to suggest is to create a submission form, then your choices should be a radio button(you can simply use a text(255) field). Then in creating reports, you may use a formula field in your table or a calculated field in your DataPage/s with CASE WHEN  condition. For example:

    CASE WHEN [@field:Answer1] = 'A' THEN 'CORRECT'

    WHEN [@field:Answer2] = 'B' THEN 'CORRECT'

    WHEN [@field:Answer3] = 'C' THEN 'CORRECT'

    ELSE 'WRONG'

    END

    You may try that in your end if that works for you.

  7. In order to be able to successfully achieve the goal of your application, below is a simple project outline to help you plan your application. 

    1. Define what is the goal of your application 

    -It is recommended to Scope these key areas to scope prior to beginning: 

    • What users and roles will be needed to access this application. 
    • What type of interfaces (forms or reports) will be needed for each users.
    • What are the records and information each users can access 

     

    2. Determine how are you going to start your App in Caspio Bridge 

    a. Start by importing data – Use if you have data to use as basis for new application. 
    b. Start with blank app to create an app from scratch. 

    Note: During your development phase, these areas will likely change as you refine the project. Initial planning allows you to organize your thoughts and plan the development. 

    Also, I would like to provide you the following video tutorials to help you get started in the platform. 

      

    As we all know, The first step in creating a web-based application is to build a normalized table. I just like to make sure that the tables are well-architected accordingly to the needs of your application. You can click the link below to view the presentation  

    1. Introduction to Table and Table Design  

    2. Data Normalization: https://www.youtube.com/watch?v=oexOYUUyQik   

    3. One-to-Many Relationships: https://www.youtube.com/watch?v=IstAk982ntA  

    4. Many-to-Many Relationships: https://www.youtube.com/watch?v=7D8u6Lb2BKU  

  8. On 12/12/2020 at 11:28 AM, NailDyanC said:

    A new PDF download option is available for the details pages of Reports, Calendars, Combined Chart and Reports, Details and Pivot Table DataPages. The PDF configuration for details pages is similar to the existing options available on results pages.

    Learn more about PDF reports generation.

    Just to add here as well, here's the new video link on how to implement PDF download option in the current release version of Caspio:

     

×
×
  • Create New...