Jump to content

mgredmond

Members
  • Content Count

    11
  • Joined

  • Last visited

About mgredmond

  • Rank
    Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. @Vitalikssssss, it does help. But not in a good way. Basically, you are telling me that the field width settings are meaningless, since they are overridden by the width of the DataPage. Then why have them? I notice that on the Video Clip in the support area, it shows a CHARACTERS choice in the Field Size setting along with Percent and Pixels, but that has already been taken away in the actual product. Another peeve of mine: In the screen shot above, not only is the Date Field wider than it needs to be, it is also taller than all the other fields. That presents an ugly look to the user. Why can't there be consistency?
  2. Thank you, @Vitalikssssss. The article is very informative, but let me add a couple of additional notes and make sure I understand. The website on which the Datapage is deployed is a Joomla CMS site and the display area is defined in the Joomla template I am using. I guess one alternative would be to try to figure out how to widen the template. But it would be much easier just to restrict the width of the field in question. Is that not the purpose of the Field Size (Pixel or %) setting? If I am mistaken, what is the purpose of this setting? How is it used?
  3. How do I change the size of a data field? When I leave everything on AUTO, the datapage displays as seen below: The size of the Purchase Date field is way bigger than it needs to be for a date and results in the record pushing beyond the edge of the display area.I have tried changing the field size to a Percent (various) and to Pixels (various), but the field size never changes. Any help is appreciated.
  4. I have a DataPage in which a header record is created. Upon SUBMIT, another DataPage is called in which child records can be created. Everything is working fine. I use the following: Now, I have added selection field such that if one type of transaction is selected the existing Child DataPage is called, but if an alternate transaction is selected, a different DataPage is to be called. I am assuming some kind of JavaScript If...Then...Else statement needs to be developed, but how would I implement that here? Thanks in advance.
  5. I figured this out. I was not quite accurate when I said I was loading the code into the Joomla article. The code was actually loaded into a custom module and the module was loaded into the article. There must be some failure in the interaction between the article and the module., because when I instead loaded the code directly into the article, everything worked as desired. Problem solved.
  6. I have a DataPage that I am embedding in a Joomla article. I use Joomla ACLs, so I am not using Caspio's authentication. But I still want to get the user's Name and ID (from Joomla) to load into the Caspio database to track who created/updated the records. I uses a PHP snippet of code to get the user's information and put it into a variable. This works because I can echo it to the screen. I then want to pass the variable to the Caspio DataPage by modifying the embed code generated for the DataPage as follows: As generated by Caspio: <script type="text/javascript" src="https://c1abs817.caspio.com/dp/ec1d70004e69797b8ed24ca4ade4/emb"></script> <div class="cxkg"><a href="https://c1abs817.caspio.com/dp/ec1d70004e69797b8ed24ca4ade4">Click here</a> to load this Caspio <a href="http://www.caspio.com" target="_blank" title="Cloud Database">Cloud Database</a></div> <div id="cbec1d70004e69797b8ed24ca4ade4"><a href="https://www.caspio.com" target="_blank">Cloud Database</a> by Caspio</div> As modified by me: <script type="text/javascript" src="https://c1abs817.caspio.com/dp/ec1d70004e69797b8ed24ca4ade4/emb?joomuser=<?php echo $username; ?>"></script> <div class="cxkg"><a href="https://c1abs817.caspio.com/dp/ec1d70004e69797b8ed24ca4ade4?joomuser=<?php echo $username; ?>">Click here</a> to load this Caspio <a href="http://www.caspio.com" target="_blank" title="Cloud Database">Cloud Database</a></div> <div id="cbec1d70004e69797b8ed24ca4ade4><a href="https://www.caspio.com" target="_blank">Cloud Database</a> by Caspio</div> Notice that I have put my modification " ?joomuser=<?php echo $username; ?>" into the script in two places. Not really sure if it's needed in both places, but not knowing, I put it in both. When I press the SUBMIT button on the DataPage, the record ( a transaction header record) is written to the database and then a details DataPage is loaded. The record is written as expected and the 2nd DataPage is presented, but when I check the record written, the user name from JOOMUSER is not recorded. Here is a screenshot of how I have the field set up on the datapage: Clearly, I am doing something wrong or missing a step. Any help would be greatly appreciated.
  7. I actually figured this one out on my own. I had the code embedded into an article in Joomla and the 1st page came up fine. But I was attempting to call the 2nd page directly from Caspio, but Joomla was treating it like I was calling another article, which it couldn't find. The solution was to also embed the code for the 2nd page into an article and to change URL code for the SUBMIT button on the 1st page to the URL for the 2nd Joomla page. Of course I also had to pass the necessary parameters. Still have other issues, but this was a big hurdle.
  8. I have one Caspio DataPage that calls another DataPage. It works fine when called using the URL deployment method. I have embedded the code into a Joomla page and the first page comes up fine, but when I press the SELECT button on the first page, the second page is not called. Instead I get UNDEFINED. Any ideas on how to get the 2nd page to load? Thanks.
  9. @DefinitelyNot3133, thank you for comments. Regarding your comment #1, I do have the correct settings for that. And I do see the parameter being passed, because I display it in a HEADER section of the form just to verify that it passed. Regarding comment #2, I know that is my issue, but I don't know how to fix it. That is the reason I am using a left outer join, because I know I have a header record, but may not have a child record. I want to go to the new form to add the child record. If I filtered the view on the hdrid on a regular join, I would not get the header or the child because there would be no match in the child table.
  10. @MayMusic, I have a SUBMISSION datapage to create the parent file, with a GUID as the Primary Key. Upon submission, the child file is called via URL with the Primary Key passed as a parameter. In the TABULAR REPORT child datapage, I receive the parameter as a filter using the Parent Primary Key portion of the View. The URL shows that the correct value is being passed and eve received, but I don't know how to get the received value into the foreign key portion of the View. This is the relationship between the files I hope this makes sense.
  11. I have two files: A parent file and a child file in a one-to-many relationship. Like a Purchase Order that has a header (parent file) and the individual lines of the Purchase Order (child file). I am using a left outer join (all records in Parent file and matching records in Child file), filtered on Parent File ID. I use this because I want to be able to display even those records with no detail so that I can add the details. I pass the Parent File ID in the URL to the Child File and everything comes up the way I expect it to, except the Foreign Key does not get populated with the passed parameter. I am clearly missing something in the process. I am new to Caspio but not new to databases. Can someone point me in the right direction?
×
×
  • Create New...