GoodBoy
-
Posts
239 -
Joined
-
Last visited
-
Days Won
19
Community Answers
-
GoodBoy's post in calculation in a rule was marked as the answer
You can use the DatePart function in a formula field to have this format for your date values. For example:
DatePart(month, [@field:DateField]) + '/' + DatePart(year, [@field:DateField])
-
GoodBoy's post in When will you update the WordPress Plugin? It causes critical issues on my site was marked as the answer
Hello! I assume that they will no longer update their WordPress plugin since the WordPress deployment will be deprecated this year based on this recent article.
- https://howto.caspio.com/deprecations/deprecation-of-wordpress-deployment-for-datapages/
Thus, they suggest to use their normal embed deployment code as replacement to WordPress code.
-
GoodBoy's post in Opening Hyperlink in DataPage Deployed in iFrame Site was marked as the answer
Hello! You may try to use this format in creating the hyperlink in your HTML block. The 'window.top.location.href' will open your link outside the iFrame.
<a href="javascript:window.top.location.href='Your_URL';">Link</a>
-
GoodBoy's post in Calculated Field based on Date Range was marked as the answer
Hola! Yes, this is possible. First, you need to edit the On Exit field of your Criteria 1 & 2 into [@from] and [@to] respectively.
Then, your formula should be like this. You need to add the condition that will scan the values of the date range you entered. Make sure to replace the 'Date' with the name of your Date field.
SELECT SUM(Total) FROM Tbl1 WHERE ID = target.[@field:ID] AND Date >= CAST('[@from]' AS datetime) AND Date <= CAST('[@to]' AS datetime) Cheers!
-
GoodBoy's post in Passing parameters containing an ampersand was marked as the answer
Hi!
Just to add on this, I have found a documentation containing the list of URL encoded characters that you can use as a reference: URL Encoded Characters (degraeve.com)
-
GoodBoy's post in Page Break By Group was marked as the answer
I believe this is possible by using some JavaScript. You may try the codes below.
Header:
<script src=https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js> </script> Footer:
<script> $( "<div style='clear:both!important;'/></div><div style='page-break-after:always'></div><div style='clear:both!important;'/> </div>").insertBefore( ".cbResultSetGroup1Row:not(:first)" ); </script>
-
GoodBoy's post in Formula Field as Lookup Value was marked as the answer
Yes. Convert first your formula into VARCHAR. For example:
CONVERT(VARCHAR(255), [@field:Field1] + ' ' + [@field:Field2])
-
GoodBoy's post in Table Formatting in Task was marked as the answer
Hey!
You may try to include this code in your email body:
<head> <style> table, th, td { border: 1px solid black !important; } th { text-align: center !important; } td { text-align: left !important; } </style> </head> [@variable:TableName] Don't forget to set the body to HTML first, then click the source button and paste the code. Please note that the <head> tag may be removed or be gone once you re-edit the email body, so you need to put it again if that happens.
This works on me. Hope this helps!
-
GoodBoy's post in Header Color Change was marked as the answer
Hello @pmcfarlain,
This forum thread might help you to achieve that:
-
GoodBoy's post in HTML tags in Tabular Report was marked as the answer
Hi! This can be easily resolved by configuring your results page. Select your text area field and change the "Render value as" into HTML. You can also enable all HTML tags, however, there will be a warning about certain HTML tags that can be used maliciously to harm your data and application. I hope this helps!
-
GoodBoy's post in External account users edit DataPage access permission was marked as the answer
I also experienced this issue a last month. What I did is that I also allow or checked the 'Read App' for the application where my DataPage belongs and it is now permitting my external users to access the DataPage.
