-
Content Count
345 -
Joined
-
Last visited
-
Days Won
7
NailDyanC last won the day on November 26 2020
NailDyanC had the most liked content!
About NailDyanC
-
Rank
Advanced Member
Recent Profile Visitors
773 profile views
-
Hi, it seems that you have submitted twice your question, I answered that here: CASEWHEN [@field:Lucy]= 'TRUE' AND [@field:Stack] = 'TRUE' AND [@field:Edward] = 'TRUE' AND [@field:Sebby] = 'TRUE' AND [@field:Maria] = 'TRUE' THEN 'Account Manager' ELSECASEWHEN [@field:Lucy]= 'TRUE' THEN 'LUCY' ELSE ' 'END + ' ' + CASEWHEN [@field:Stack]= 'TRUE' THEN 'STACK' ELSE ' 'END + ' ' +CASEWHEN [@field:Edward]= 'TRUE' THEN 'EDWARD' ELSE ' 'END + ' ' + CASEWHEN [@field:Sebby]= 'TRUE' THEN 'SEBBY' ELSE ' 'END + ' ' + CASEWHEN [@field:Maria]= 'TRUE' THEN 'MARIA' ELSE ' 'ENDEND
-
Concatenate two text fields to have a Date/Time value
NailDyanC replied to KAPITYAN's question in Calculations and aggregations
Hi, You may try the formula below: CONVERT(varchar, [@field:Date], 101) +' '+ CONVERT(varchar, [@field:Time], 108) The two fields that I am using are text fields(text255). I hope that helps. -
Show Virtual Field Calculated Values on PDFs
NailDyanC replied to kpcollier's question in General Questions
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. -
Tables and records automation
NailDyanC replied to GUSTAVO's question in Tables, Views and Relationships
Just to add in the previous comments above, you may also check this post: -
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.
-
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 wanted to add in the previous comments above, there is a new short version of the Platform Overview video that might be helpful! You can visit/watch it here
-
Create a certificate like report for printing
NailDyanC replied to Speedracer350's question in General Questions
Just to add in the previous comment above, with the release 25.0, Caspio has released a Youtube tutorial on how to generate PDF files. Hope this helps. -
Data collection before building an application
NailDyanC replied to TeamVilla's question in General Questions
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 -
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:
-
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:
-
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:
-
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:
-
Hi, just to update this post, here's the updated link for conditional forms or creating rules: https://howto.caspio.com/datapages/forms/conditional-forms/