Jump to content

All Activity

This stream auto-updates     

  1. Today
  2. My application has a provider table that contains name, email, phone, etc., which is linked to an address table so that the provider can have more than one physical address on file. Everything works fine, but I want to allow admins to delete addresses BUT require at least one address for each provider, so if there is more than one address they can delete, but when there is only one address they cannot delete anymore. The address table has a pointer to the ProviderID so that I know what addresses go with each provider, but I don't know if there is a query or a trigger that I can use with Caspio so that I can check that there is more than one address for a provider before I let an address be deleted. I hope this makes sense. Thanks in advance for any ideas.
  3. HeezyMeezy

    Add Comment Field with Prefilled Date

    Hello there. This is a very common question asked. This URLshould help you with your time stamp https://howto.caspio.com/tech-tips-and-articles/common-customizations/stamp-the-time-url-or-ip-address-to-new-and-updated-records/
  4. Hello @maverick, Since Caspio releases 12.0, you can choose between Plain Text and HTML for the emails. This can be done through Triggered Actions.
  5. LunaLovegood

    Multiple user login?

    Hello @JeanPierre, You can do that by enabling RLS (Record Level Security) on your DataPage setup. You may want to check these articles for your reference: https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/ https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/restrict-access-to-data-by-user-or-role/
  6. Hi, I want to make an application where multiple customers of me can login. If they login, they should only becable to see their own customers details and not customer details from other customers of me. Example; customer 1 logs in and sees the data of his customers. He can addnew customers, change and delete existing customers. Customer 2 logs in and sees the data of only customers of customer 2. How should i go about this? thanks in advance, Jean-Pierre
  7. It means, essentially, what it says; that 'this is important, ignore subsequent rules, and any usual specificity issues, apply this rule!' In normal use, a rule defined in an external stylesheet is overruled by a style defined in the head of document, which, in turn, is overruled by an in-line style within the element itself (assuming equal specificity of the selectors). Defining a rule with the !important 'attribute' (?) discards the normal concerns as regards the 'later' rule overriding the 'earlier' ones. Also, ordinarily, a more specific rule will override a less-specific rule. So: a { /* css */ } Is normally overruled by: body div #elementID ul li a { /* css */ } As the latter selector is more specific (and it doesn't, normally, matter where the more-specific selector is found (in the head or the external stylesheet) it will still override the less-specific selector (inline style attributes will always override the 'more-', or the 'less-', specific selector as it's always more specific. If, however, you add !important to the less-specific selector's CSS declaration, it will have priority. Using !important has its purposes (though I struggle to think of them), but it's much like using a nuclear explosion to stop the foxes killing your chickens; yes, the foxes will be killed, but so will the chickens. And the neighborhood. It also makes debugging your CSS a nightmare (from personal, empirical, experience).
  8. Franchiser

    Perma login

    Hi Webtalking, Will recommend using one authentication for the whole app to avoid multiple logins or create a standalone login screen regards, -Franchiser-
  9. Franchiser

    Responsive Chart DataPage

    Hi HeezyMeezy, Use this URL to check if the chart datapage is responsive by design. -Franchiser-
  10. Hi Bre, Can you try the INNER JOIN instead of a WHERE clause? I have this problem before and it works using an inner join. -Franchiser-
  11. Yesterday
  12. gsgriffin

    Chrome login loop

    No, That would bring up the Caspio error when the form first loads that states that the person must have cookies enabled. The person loads the auth form and submits it only to be immediately returned to the blank auth form and no error. This happening with different people only on Chrome and only within the past few weeks.
  13. Hi roattw, I'm afraid the answer for that is yes. You need to put !important if you will be using an external or internal css because if you don't that might cause conflict on other css code with the same class/id name.
  14. The fields in the Details page are addressed as 'EditRecordFIELDNAME' with field name being the actual name of the field as it is in the table. Please refer to this article for help on how to address different Caspio form elements in JavaScript code. By just changing the field name as per the above format in the code from the other forum article should get you the desired results. I hope this helps.
  15. If possible, could a member please assist with the above? Thanks!
  16. HeezyMeezy

    Responsive Chart DataPage

    Hello Franchiser, The URL does not have the code for chart DataPage but I got to know that chart DataPages are responsive by native. Thanks though.
  17. BaySunshine

    Convert Scientific Notation to Numeric

    Is one of those fields a formula field by itself? To troubleshoot the error, I suggest you to try one case...when at a time. Make a duplicate of your table or add a test record to your existing table and test it out. This way you can narrow down to see which particular field/condition is causing this error. I hope that helps.
  18. Hello humidor, Yes, you can do this by following the steps below: 1. Make the formula field as 'display only'. 2. Add a virtual field of checkbox type. 3. Use 'Rules' to hide the separate field based on the value of a checkbox. 4. If the user chooses to change the date, they enable the checkbox and the separate field shows up. 5. User can enter the data and hit 'Submit'. Hope this helps. Regards,
  19. BaySunshine

    Triggered Action to join 3 tables.

    Hi Magnum, The value 'true' for MngrNotesChk may not be inserted as the light pink true field is just like a placeholder. Click on the Logic or Data button on the left and drag a 'true' field and place it in here. It should then work. Apart from this, I don't see any other issue with the trigger. A full screenshot of the trigger will help us in reviewing it better. Regards,
  20. Vitalikssssss

    Chrome login loop

    Hi @gsgriffin, This behavior makes me think that some users disabled third-party cookies in their browser settings. Hope this helps. Regards, vitalikssssss
  21. Hello LynnR! There is a way to implement such workflow. You will need some adjustments to your datapage and a little snippets of code to insert. Find document with printscreens attached. The logic of current datapage is: A Virtual field will be hidden (we will cover it with two HTML fields and will set as "display:none"). A value from this field will be taken when it will be changed. Then this value will be passed to div in HTML block. You can adjust CSS for this field as you want. The only thing you will need to customize in JS code (find this code as a 4-th part in document) is to find and insert the Class name of your Virtual field. By default, the name of virtual field is “cbParamVirtualX”, where X is a number of field (Virtual1, Virtual2 etc). Or you can do it use the developer tools of browser to find it. Let me know if you have any questions regarding your issue. Print_Screen_&_Code.docx
  22. Some users have recently been reporting that they can no longer log in using Chrome on all of their devices. Works with other browsers, but something is being blocked or not passed or at least shared between their computer, tablet and phone while trying to use Chrome. It does not produce an error. It just sends the person back to the login form with no error are submitting. The solution to this is not to try to have every person change their Chrome settings....most are clueless as to how. Need to have a solution on our end that gets around this. Any ideas on the cause?
  23. This is a remarkable reason. Enjoyable in turn remain it portion. _____________________________ Turquoise Bedding
  24. Last week
  25. Hullo, I am very new to Caspio so please do bear that in mind when responding! I am trying to add a comments field to my records that when filled in will store the information with a data stamp for each entry. So for example Joe enters a comment in record A on Monday and then Frank enters a comment in the same record on Tuesday, I'd like that data to be present with a date stamp in the record that everyone who enters the record will be able to see. Would I be able to get some help with this please? Thanks!
  26. I have a pretty basic submission form with a dropdown menu with different job types. These job types are defined in a lookup table with "JobTypeID", "JobType" and "JobDescription" When choosing the different job types I would like the job description to be displayed right under the dropdown menu. So far so good. Easy enought just using a virtual field and cascading elements to display the job description. But how can i use this cascading "JobDescription" info in an HTML block and use my own html/css styling? I cannot use static info in the html block because of "Record level security" on the job type field.
  27. I have a combined chart and report datapage that I use to display a list of jobs and their status. I would like the list and chart to have dynamic colours according to their status. This is quite easily accomplished, and in fact I have already completed it. My issue comes in place with AJAX. I cannot disable AJAX on a combined chart/report datapage, therefore when I do a bulk edit on my report, the chart reverts back to the default colours. I am guessing this is because the chart loads without running the javascript in the datapage. Is there a way to execute javascript in a datapage not only on load, but also on an AJAX call? Thanks,
  28. Vitalikssssss

    SELECT COUNT() possible?

    Hi @AndrewCHughes, It is possible to specify COUNT function in REST API query which will return a count of matched records. Here is a simple example: Hope this helps. Regards, vitalikssssss
  1. Load more activity