Jump to content


  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

534 profile views

NarayanJr's Achievements


Newbie (1/14)



  1. I am using PHP to add a value to a table. This table has a Client Name, ClientID, and Display field. The Client Name is just a string entered by the user, and the Client ID is an auto number. The display field is "Client Name - ClientID". Is there anyway to do this in one call? Right now the only way I can think of doing this is to 1. InsertData to add the client 2. SelectData to get the Client ID 3. UpdateData to add the Display field. Is there anyway to do this in less calls? Can the Autonumber field be used like how it is used in the forms, with [@InsertRecordClientID] being parsed to the number on insert? Thank You, Adam
  2. Thanks for the suggestion I have actually looked into it have have switched over to using the API instead to provide different features and style things the exact way I desire. Thanks for the help.
  3. Thanks for the reply, I was unaware of these settings and if I was using straight images this would work fine but my buttons are styled with css and involve style changes on hover and click which I cant replicate with a static image. But for most people this will probably be the right way to do this. I have switched to using the API to bypass the authentication and use my custom designs across the site. If anyone does know why, I would like to know why the Caspio facebook button works the way it does with tracking backwards through calls to find where the call initiated and loading that page instead of the page the authentication was meant for. But as I believe you answered the question with what is probably the best solution for someone not as picky as I am I will accept that as the solution. Thanks.
  4. I currently have my own button designed which flows with my site and I want to use my buttons instead of the buttons provided by Caspio. I have it setup where the Caspio page is hidden and when the User clicks my Facebook Login button, it executes code, $('#hiddenForm').contents.find('[title="Sign in with Facebook"]').click(); This looks into the iFrame which holds the Caspio Login button and simulates a click on the button. This then loads the popup Facebook auth window. After the user agrees and the popup closes, the iFrame reloads. But instead of it loading to my Facebook registration it loads the main registration page into the iFrame then in that the facebook registration page. This is only an issue when the Caspio facebook button is not clicked by the user and the click is not initiate from the same location. It seems to to load up the url of the page the initiated the call that clicked the Caspio Button. If i set my code to run on load from within the authentication footer, it properly clicks the link and loads the page as expected. It only causes issue if I use my code to go from one page to an iframe embedded in the page. So when I should end up with, My main registration page with an iframe containing my facebook registration page, I end up with, My main registration page with an iFrame containing my main registration page containing an iframe containing my facebook registration page. Attached is a picture of what happens when my code runs and the break up of what is an iframe and what is my page. Thanks for any help, Adam
  5. Is there any way to login via Facebook and Capsio ID without using the buttons/forms generated by Caspio directly? I am having trouble getting my authentication page to look and feel like it belongs on the website. Is it possible to use HTML/JS/Something else and use these resources to login to Caspio via Facebook or Caspio ID? Such as hiding the Capsio datapage in the background and passing it values? I have tried calling the method that Caspio's facebook button calls on click, but it generates errors when I call it manually and not onclick via the button. Thanks, Adam
  6. Java script can easily handle changing the field as needed. Here is an example, Place that in your footer, or at least that is where I use it. This is assuming it is a Submission form. If it is an update form change InsertRecord with EditRecord. This is also assuming your field is called "Weight". But you can easily change those to match what your fields are called. Note I have not run this so their may be some syntax errors but I believe it is all correct. <script> function modify() { //Find elemeny by name as Caspio likes to assign ids that change. Store the value in the field to weight. var weight = document.getElementsByName("InsertRecordWeight")[0].value; //Take a substring of weight and store it back into weight. weight = weight.substring(4,13); //Set the value of the weight field in the form to the new substring document.getElementsByName("InsertRecordWeight")[0].value = weight; //the new value in the field is what is submitted. } //When the form is submitted called method modify. document.getElementById("caspioform").onsubmit=modify; </script>
  7. I know with the new update to 8.0 we now have the ability do use Facebook and a few others as ID sources, but is there anyway to use LinkedIn as an Authentication source? If there is no native supported yet has anyone created a work around to use LinkedIn as a form of Authentication. Or does anyone know when LinkedIn will be added? Thanks, Adam
  8. I dont know a whole lot about encoding URLs but I did recently work through my own issue using javascript's encodeURI and and looking at the encoded url that is correct. "%26cbResetParam%3D1%26TPSampleID%3D" %26 = "&" %3D = "=" It looks like it is encoding it correctly. If you want it to look like this "culex.ca/client-portal/administration-login/forms-and-reports/adult-and-species-id-form&cbResetParam=1&TPSampleID=" when it gets to your page, you may have to use the decode function which should replace all the %26 and %3D back to & and =. This is javascript based though and it looks like "URLEncoder.encode" is part of Java, but there should be a similar answer for straight Java. You may just receive the encoded url and use code on the website to decode it and pull the passed parameters that way. http://www.w3schools.com/jsref/jsref_decodeuri.asp http://www.w3schools.com/tags/ref_urlencode.asp
  9. After working with Caspio's support team this problem has been solved. The issue is believed to be caused by my naming of parameters. It seems the parameter prefix, InsertRecord, causes some unexpected results possibly because that prefix is meant for AutoNumber fields. So this code: <a href="JavaScript:newPopup('http://b6.caspio.com/dp.asp?AppKey=1e433000d01e2568bfe147aeb429&InsertRecordClient=[@field:Client]&InsertRecordClient_ID=[@field:Client_ID]');">Claim</a> was changed to this: <a href="JavaScript:newPopup('http://b6.caspio.com/dp.asp?AppKey=1e433000d01e2568bfe147aeb429&Client=[@field:Client]& Client_ID=[@field:Client_ID]');">Claim</a> This change fixed the issue. Hopefully if anyone else has this problem this helps.
  10. From a search and report page I supply a link which accesses a submission page and passes parameters using string query. The values Client and ClientID are passed to the submission page and received correctly. When I view them on the submission page they are prefilled in the forms as they appeared in the calling link. However when I hit submit then go look at the table they show up wrong. If I submit this: Orange Street, Phase I and II CSO Correction Projects, City of New Haven I get this: Orange Street, Phase I and II CSO Correction Projects, City of New Haven||cb||Orange Street, Phase I and II CSO Correction Projects, City of New Haven This is only an issue it seems when the Client has a comma in their name. So I click this link: javascript:newPopup('http://b6.caspio.com/dp.asp?AppKey=1e433000d01e2568bfe147aeb429&InsertRecordClient=Orange Street, Phase I and II CSO Correction Projects, City of New Haven&InsertRecordClient_ID=6724'); and it fills in the fields on that data page correctly, but it does not submit them to the table the same way they are entered. I noticed that If I manually edit the fields once they are filled then I will get this result RandomTextIEnteredOnSubForm||cb||Orange Street, Phase I and II CSO Correction Projects, City of New Haven It will submit what I typed, then attach the ||cb||... to the end of that. If I delete what is in the field then hit submit, then it errors because the field is required, then I type in the correct information even with the comma it submits it correctly without adding the extra ||cb||... stuff after. I believe what it is doing is taking the value found in the Client input box and combining it with the parameter passed in as Client then submitting that to the table. However I feel like that is not how it should function especially since it only seems to happen when a Comma is in the Client name. Is this an error on Caspio's part or am I just doing something wrong? Also if the Client name happens to have & in the name then it only read the client name up to that point then skips the rest of the name and continues onto the next parameter. Is there a way around it? I am assuming this is an issue because & is what is use to separate different param/value pairs. Thank You, Adam
  11. Thank you very much MayMsuic, I didnt even realize that the string query really starts with appkey.
  12. I am having trouble using String Query parameter passing. I am embedding html into the results of an Search and Report datapage. This html <a href="JavaScript:newPopup('http://b6.caspio.com/dp.asp?AppKey=1e433000d19de0725b604d9ea93d?Client=[@field:Client]&Client_ID=[@field:Client_ID]');">[@field:Client]</a> This way a user can click on the Client Name hyperlink which calls Add_Relationship data page and maps the logged in users name to the sent Client and Client ID. However every time I try and use this link I get, Undefined AppKey. (Caspio Bridge error) (60011). I also have another data page, Add_Client, that adds a client to a data table then on exit loads the Add_Relationship data page and passes all the required parameters. When I go from data page to data page it works fine, the only issue I have is when I try and use string query parameter passing. If I remove everything after ? the data page loads fine, obviously without the parameters but that defeats the purpose. All three data pages are enabled and have both, Advanced and Parameters, check boxes marked. The Add_Relationship data page has has 3 fields, the Username is set for, OnLoad receive an Authentication field, and Client and Client_ID which both receive external parameters, [@Client] and [@Client_ID]. This is my first attempt using string query so I dont know what I am doing wrong. I have gone over the Receiving Parameters How To, and the String Query How To pages, but it Looks like I have everything set the way it should be. Any help is appreciated, Thank You.
  13. Thanks for the information delegate. I took your advice and added it to the IdeaBox, hopefully it will become a feature in the future.
  14. I am trying to make it so a user cannot submit the same exact information twice. I have a data page that accepts a, Name, Country, State, and City and is added to a table. However you can resubmit the same info over and over again filling the table with redundant information. I thought about setting the table fields to Unique but that doesn't really do what I want. I need to be able to enter very similar data as different entries, but not allow identical data. So an entry of, Remote Diagnostics, USA, New Jersey, and Toms River, can not be entered twice but allow that entry and Remote Diagnostics, USA, Georgia, and Toms River. What I need is a Unique entry and not just a Unique field. I tried searching for this but was unable to find anything. If anyone has an answer or can link me to something I missed it would be much appreciated. Thank You
  • Create New...