Jump to content


  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

279 profile views

mgredmond's Achievements

  1. Can someone point me to some clear understanding of the Logout Destination Timeout and redirection Login redirection on success parameters found in the Advanced Settings section of Authentications? They would appear to be intuitive, but they are not. I cannot find a clear understanding of these values or how and when to use them. And I am pretty sure they are causing me some problems. I have created a stand-alone Login page with guidance from the Caspio online help and use the following code: <script> if("[@authfield:tbl_Users_IAMgmt^]" == "Yes"){ window.location = "https://www.google.com"; } else if ("[@authfield:tbl_Users_CollegeRep^]" == "Yes"){ window.location = "https://www.yahoo.com"; } else{ window.location = "https://www.bbc.com/news"; } </script> Clearly, I have changed the destination URLs from my live site for security reasons, but the point is that different users go to different sites. But I think I am being hindered by the settings of the parameters above. When I changed the LOGIN REDIRECTION ON SUCCESS to CASPIO.COM, that's where I went regardless of who I logged in as. It was if the code above was simply ignored. And if you tell me WHAT to do, please at the same time tell me WHY to do it. Thank you in advance. Any assistance is appreciated.
  2. @Vitalikssssss, that worked perfectly. Thank you so much!
  3. I have a DataPage on which users enter Header information for a transaction. Depending on the transaction type (A or B) , I need to redirect to a different DataPage to enter the transaction details. Using information from this post, I was able to get the redirection that I need. No problem. But I also need to save the transaction type in the header record. I use a virtual field to perform the redirect and I have a field TrxnType that should save the value. I need the actual field so that I can use a view later on to join the headers with the appropriate detail records. How do I populate the actual field based on the value of the virtual field without having them both present on the DataPage?
  4. I have two tables: Header Information and Details Information. I have created a view to join these two tables. Everything works fine. I use a report to display the information. See the image below: Is there any way to get the text areas (Misapp Comments and Fraud Discussion) to print on a second and/or third line under the record to that it can utilize more of the space (be more wide than vertical) before going to the next record? Thanks in advance.
  5. @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?
  6. 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?
  7. 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.
  8. 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.
  9. 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.
  10. 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.
  11. 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.
  12. 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.
  13. @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.
  14. @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.
  15. 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...