SunakoChan
-
Posts
140 -
Joined
-
Last visited
-
Days Won
8
Reputation Activity
-
SunakoChan got a reaction from jyll2113 in Make List Results Full Screen On PDF
Hi @kpcollier-Try this, just enable the source then paste it:
<div style="text-align: center;"><span style="font-size:14px;">Capital Glass, Inc.<br />
SM Bid / Work Order</span>
<hr /><span style="font-size:14px;"><br />
Job/Customer Name: _________________________________________ Phone #: _______________________<br />
Contact Name: ______________________________________________ Phone #: _______________________<br />
Fax Number: ______________________________________ E-Mail: __________________________________<br />
Job Address: ________________________________ City: __________________ St:________ Zip:__________<br />
Bill To (if different from above):_________________________________________________________________<br />
Billing Address: _____________________________ City:__________________ St:_________ Zip:__________<br />
PO #: ________________ Warranty:______________ Order Date:________ Estimator: _______________</span><br />
<center>
<table align="center" border="1" cellpadding="1" cellspacing="1" style="height:300px;width:700px;">
<tbody>
<tr>
<th scope="row">Quantity</th>
<td style="text-align: center;">Size</td>
<td style="text-align: center;">Description</td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<span style="font-size: 12pt;"></span></center>
<center style="text-align: left;">
<center style="text-align: justify;"><span style="font-size:12.0pt;"></span><span style="font-size:12.0pt;"></span><span style="font-size:12.0pt;"><span style="font-size:12.0pt;"><span style="font-size:12.0pt;"><span style="font-size:12.0pt;"></span></span></span></span></center>
<center><span style="font-size:12.0pt;"><span style="font-size:12.0pt;"><span style="font-size:12.0pt;"><span style="font-size:12.0pt;"><br />
Labor hours to be billed:</span>_______________________________________________ </span></span></span></center>
</center>
<center style="text-align: center;"><span style="font-size:12.0pt;"> </span></center>
<center style="text-align: justify;"></center>
<center style="text-align: center;"><span style="font-size:12.0pt;">Scope of work: <br />
______________________________________________________________________________<br />
______________________________________________________________________________</span><br />
<br />
<span style="font-size:12.0pt;">Comments: <br />
______________________________________________________________________________<br />
______________________________________________________________________________</span></center>
</div>
Here is the actual result in preview:
Here is the actual result in PDF:
-
SunakoChan got a reaction from researched in Date format
Hi @Telly,
I suppose that you are using Date/Time field. Since it is a Data/time field you have to convert the Field in to text after that use substring for the month, you may use this formula below:
CONVERT(VARCHAR, (SUBSTRING('JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC ', ((Datepart(month, [@field: DATEFIELD])) * 4) - 3, 3))) + ' -' + CONVERT(VARCHAR, (Datepart(day, [@field: DATEFIELD))) + ' - ' + CONVERT(VARCHAR, (Datepart(year, [@field: DATEFIELD])))
I hope this helps.
-
SunakoChan got a reaction from fischerrestore in Border color in the Results Page of the Tabular
Hi Team,
It is possible format the output result page fields to have a grid just like a table in Excel?
Thank you in advance
-
SunakoChan got a reaction from beptucongnghiep in How to hide "No records found" and Header
Hi - I want to hide the message 'No record found ' and the header of the DataPage.
-
SunakoChan got a reaction from vanderLeest in Date format
Hi @Telly,
I suppose that you are using Date/Time field. Since it is a Data/time field you have to convert the Field in to text after that use substring for the month, you may use this formula below:
CONVERT(VARCHAR, (SUBSTRING('JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC ', ((Datepart(month, [@field: DATEFIELD])) * 4) - 3, 3))) + ' -' + CONVERT(VARCHAR, (Datepart(day, [@field: DATEFIELD))) + ' - ' + CONVERT(VARCHAR, (Datepart(year, [@field: DATEFIELD])))
I hope this helps.
-
SunakoChan reacted to bertc in Accessing a field from differnt table than datasource
Thank you both. I went ahead and created the view joining schools & students tables. I had to change a few things as I was using the students tables for authentication but changed that to use the view. Caspio made it simple to update the needed datapages.
-
SunakoChan reacted to kpcollier in Letter-Style DataPage
Yes I did! I used it with just a few CSS tweaks and it worked perfectly for my needs. It is what I am currently using. I appreciate it, @SunakoChan!
-
SunakoChan got a reaction from kpcollier in Letter-Style DataPage
Hi @kpcollier, Have you tried the format that I have provided you on the other post, they are pretty the same:
-
SunakoChan got a reaction from kpcollier in Make List Results Full Screen On PDF
Hi @kpcollier-Try this, just enable the source then paste it:
<div style="text-align: center;"><span style="font-size:14px;">Capital Glass, Inc.<br />
SM Bid / Work Order</span>
<hr /><span style="font-size:14px;"><br />
Job/Customer Name: _________________________________________ Phone #: _______________________<br />
Contact Name: ______________________________________________ Phone #: _______________________<br />
Fax Number: ______________________________________ E-Mail: __________________________________<br />
Job Address: ________________________________ City: __________________ St:________ Zip:__________<br />
Bill To (if different from above):_________________________________________________________________<br />
Billing Address: _____________________________ City:__________________ St:_________ Zip:__________<br />
PO #: ________________ Warranty:______________ Order Date:________ Estimator: _______________</span><br />
<center>
<table align="center" border="1" cellpadding="1" cellspacing="1" style="height:300px;width:700px;">
<tbody>
<tr>
<th scope="row">Quantity</th>
<td style="text-align: center;">Size</td>
<td style="text-align: center;">Description</td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
<tr>
<th scope="row"></th>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<span style="font-size: 12pt;"></span></center>
<center style="text-align: left;">
<center style="text-align: justify;"><span style="font-size:12.0pt;"></span><span style="font-size:12.0pt;"></span><span style="font-size:12.0pt;"><span style="font-size:12.0pt;"><span style="font-size:12.0pt;"><span style="font-size:12.0pt;"></span></span></span></span></center>
<center><span style="font-size:12.0pt;"><span style="font-size:12.0pt;"><span style="font-size:12.0pt;"><span style="font-size:12.0pt;"><br />
Labor hours to be billed:</span>_______________________________________________ </span></span></span></center>
</center>
<center style="text-align: center;"><span style="font-size:12.0pt;"> </span></center>
<center style="text-align: justify;"></center>
<center style="text-align: center;"><span style="font-size:12.0pt;">Scope of work: <br />
______________________________________________________________________________<br />
______________________________________________________________________________</span><br />
<br />
<span style="font-size:12.0pt;">Comments: <br />
______________________________________________________________________________<br />
______________________________________________________________________________</span></center>
</div>
Here is the actual result in preview:
Here is the actual result in PDF:
-
SunakoChan got a reaction from Corpcatalog in Remind user to submit datapage if browser window is closed
Hi @Corpcatalog,
Add Header and Footer on your DataPage and paste the Script below (Make sure that you disable your HTML editor before pasting the code).
<script>
window.onbeforeunload = function (e) {
e = e || window.event;
if (e) {
e.returnValue = 'Sure?';
}
return 'Sure?';
};
</script>
Here the expected result:
I hope this helps.
-
.thumb.jpg.0bc926a67224361423876f4f188f9803.jpg)
SunakoChan got a reaction from JckDY in How to prevent a form to submit
Hi Telly,
You can try this:
<script type="text/javascript">
document.addEventListener('BeforeFormSubmit', function(event) {
if (condtion) {
//result if condition is met
} else {
event.preventDefault()
}
});
</script>
Also, check this helpful link: https://howto.caspio.com/datapages/ajax-loading/ -
SunakoChan got a reaction from kpcollier in Custom Link/Button - This Site Can't Be Reached
I think it would be better if you can create a test datapage and check if that will work. If the replicated page works, then there is something wrong with your URL in your original link. Re-deploy and re-paste the URL of the deployed DataPage. Hence, if the replicated Datapage still does not work, check your HTML code.
-
SunakoChan got a reaction from kpcollier in List Report Styling
Hi @kpcollier,
Could you provide us the Deployed DataPage URL, so that we can test it?
Could you try this CSS on your DataPage Header:
<style>
.cbFormLabelCell
{
padding: 9px 14px 0px 14px !Important;
}
.cbFormDataCellNumberDate {
padding: 7px 14px 7px 14px !Important;
}
</style>
I hope this helps.
-
SunakoChan got a reaction from Kurumi in Tooltip
Hi @telly,
This is doable, you just need to add <image src="IMAGEURL"> on your hint.
Sample Result Bellow:
-
SunakoChan reacted to Aether in Importing/Exporting spreadsheet with list-DataType
Hello @IamGroot,
Just wanted to inform you, I found a way to export/import a table/database with List-DataType value inside it.
1. Change the DataType to "Text(255) field" and Export it.
2. And in your Excel file, make sure that the value for the List-String field is comma separated like this: (Item1,Item2,Item3,Item4, etc.)
3. Proceed with the import as usual. After successfully importing your file. Go to your Table and to the Table Design.
4. Change the "Text(255) Field" (The one we changed in step 1) back to List-String DataType.
5. Then it will just return the way it was. If you want to export it (reapeat step(1)).
I hope this helps
~WatashiwaJin~
-
SunakoChan got a reaction from telly in Generate an expiration date
Hi @telly,
You may try this possible workaround.
1. On your Submission DataPage, go to Configure Fields and add a Header and Footer Element
2. Go to the Footer and disable the HTML editor by going to the Advanced tab and unchecking the box next to "Enable HTML editor".
3. Click the Standard tab.
4. Add the following code to add 2 years and always set it to the 1st day
JavaScript code:
<script>
//detect event onchange on the textfield of certificate date
document.getElementById('InsertRecordLast_InsertDate').onchange = function(event){
//place value of certificate date into a new Date class and put it in a variable
var InsertDate = new Date(document.getElementById('InsertRecordLast_InsertDate').value);
//get the first day of the same month but 2 years after
var lastDate = new Date(InsertDate.getFullYear() + 2, InsertDate.getMonth(), 1);
//date.getMonth() starts from 0, so add 1 then make sure it displays with 0 when lower than 10
if(lastDate.getMonth() < 9) {
var lastMonth = "0" + (lastDate.getMonth() + 1);
} else {
var lastMonth = (lastDate.getMonth() + 1);
}
//place the value to the expiration date textfield
document.getElementById('InsertRecordExpiration_Date').value = lastMonth + "/1/" + lastDate.getFullYear();
}
</script>
-
SunakoChan got a reaction from telly in I just want to know if there is a workaround on Redeploy.
Hi @telly,
Yes. In order to achieve that you may use the 'Replace' feature.
Below is the step by step:
1. Make sure select the new version of the DataPage: http://prntscr.com/lwnhkn
2. Click 'More' then select option 'Replace': http://prntscr.com/lwnhyj
3. Then select the DataPage that you want to replace with the new one: http://prntscr.com/lwnicg
4. After that refresh your page for you able to see the result.
Regards,
Sunako
-
SunakoChan got a reaction from telly in Tooltip
Hi @telly,
This is doable, you just need to add <image src="IMAGEURL"> on your hint.
Sample Result Bellow:
-
SunakoChan got a reaction from taylorswiftlover in Login Process
Hi @Watusi,
If you curious about the latest new features or previous versions of Caspio Bridge. You may want to read the release notes to learn about Caspio’s version upgrades, bug fixes, and platform enhancements. You may visit the release notes here.
Regards,
SunakoChan
-
SunakoChan reacted to JolliBeng in Change colors
Hi JckDY,
Yes, it is possible. You may try this solution:
-JolliBeng
.thumb.jpg.0bc926a67224361423876f4f188f9803.jpg)
