Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


TellMeWhy last won the day on January 27

TellMeWhy had the most liked content!

1 Follower

About TellMeWhy

  • Rank
    Advanced Member

Recent Profile Visitors

100 profile views
  1. Try this on your Details Page Footer basically, it listens if any change ( document.addEventListener('change', function (event)) in the page has been made, if there is, it will disable the button <script> document.addEventListener('DataPageReady', function (event) { document.addEventListener('change', function (event) { document.querySelector("input[id^='Mod0EditRecord']").disabled=true; }); }); </script>
  2. It should work as long as the special character is not included in the query string, since you're only passing an ID, it, most probably, does not have any special characters. This is a workaround, as this is technically not passing all those values, but getting it directly from the table while using the ID field as a reference
  3. You may create a Formula Field in your Table instead, concatenate the two field through that field, and use that for Display.
  4. Is this a Reports DataPage? You may use a Calculated Field and then use Datediff function assuming that the Deadline Date is on your Caspio Table, as well. For example: Datediff(day, GetUTCDate(), target.[@field:Deadline]) target means it will get the field Deadline of that specific row/record You may find more information in this HowTo Article under DATE AND TIME Function https://howto.caspio.com/function-reference/
  5. That's kind of a strange workflow, why receive an ID in a Submission Form? Is this just to connect the record to the main one? If that's so, trigger should be the best way to do this. If you want it displayed, it gets more complicated. You will need Cascading Form Elements. However, there's no Cascading Text Area, so, we will need a JavaScript for this Steps: 1. Just pass the ID of the Record on your Details Page. (<a href="https://c2aby549.caspio.com/dp/83ff8000b539c247760a46d6aa9b?Receive_ID=[@field:ID]" target="_blank">Pass Parameter</a>) 2. On your Submission F
  6. If I understood it correctly, you are passing an ID from REPORT1 which is connected to multiple records on REPORT 2 upon updated of REPORT1. REPORT2 is then filtered using this ID, however, Inline insert does not receive this specific ID, or does it? The only way you can receive an external parameter on Inline Insert is to set the field to hidden, and you will be able set its On Load value. If this ID is not inserted through the Inline Insert, then the added record will not have any relationship with that ID, and since REPORT2 is filtered using that ID, the added record will not be inclu
  7. That is strange. You did mention that no information is passed to the table, does that mean no record is being added on Table Level, and not just DataPage? You said it's a filtered one, so it may not show on the DataPage, but will be added on the Table itself. Are you using a Table as a DataSource or a View? Have you tried other browser? Clear cache? Additionally, have you checked if there's any triggered action on the Table that might prevent this new record from inserting?
  8. Instead of using {@field:field] have you tried the manual SELECT Statement? I believe if you used field parameters, it will abide by the rules of the DataPage, so, if it's filtered, it will only check the filtered. If you use SELECT Statement, it will take from the Table itself regardless of the filtered set in the DataPage
  9. Welcome to Caspio! It's great that you're enjoying it! You can ask for a project consultation here https://www.caspio.com/services/project-consultation/ . Caspio also has their own developers you can seek help from if you want to build a project with them. They're called the Professional Services and you can reach out to your assigned Account Manager (if you already have a paid account) for Project Consultation with them
  10. I'm not sure if that's possible with Caspio. You can type on the Dropdown field, and it will change the value according to what you typed, but you will not be able to see suggestions like in the Autocomplete fields If you mean you want to have different Field for Display and Field for Value, there is a workaround using Autocomplete if that's what you want to achieve. Step1. Use a virtual field for your autocomplete (Field for Display) Step2 . Use your actual field, set as Cascading Text Field, set its Parent Field as the Virtual Field in Step1, set Cascaded By to the f
  11. I just want to add Caspio's How-To Article Link here: https://howto.caspio.com/function-reference/ Case When is tackled in this article, in case anyone is looking for slightly more information
  12. Can I have a better look at your workflow? Sample Page, or screenshots? Are these fields calculating as soon as the DataPage load, or after you input some values on other fields? What values are you expecting for these fields to have, do they have a CONSTANT condition, like, they always have greater than 5 value, so you may use that for the condition on the JavaScript? Lastly, what are you using these virtual fields for? These do not get saved in the table, are you passing this as an On Exit parameter?
  13. I'm not sure of your exact workflow, but as I understand, you want to put the images you have to the Assets Table? As far as I know, there is no automatic way to do that, but to manually upload each image into the table. if you want to assign a certificate/asset to an Employee, you will need an additional field on your Employees Table, or Create a new one to store the assigned records, then just use a simple Submission Form DataPage You may also want to check this out to connect your tables https://howto.caspio.com/tables-and-views/relationships/
  14. That's good to hear @KweenYasmin! Those icons are not in the CSS, but in the class, you may notice that it has classes like class="fa fa-plus ..." for the Add New or class="fa fa-gavel ..." for the hammer looking one. Just change the fa-plus to any icon you want to. You should be able to see what class you should use for an icon in this website https://fontawesome.com/v4.7.0/icons/ . Try out plus or gavel, and you'll see the same
  15. The code for the Navigation menu is not on the HTML, but on the JavaScript files since it's the most efficient way to do, and you can just call it using one line on every HTML Page. 1. Go to JS folder of the Application 2. Right-click on the file named 'common' and edit it using your desired Text Editor 3. You may look for the line 'function load_user_sidenavbar(active_nav)' for user navigation menu and 'function load_admin_sidenavbar(active_nav)' for the admin navigation menu. You can use Ctrl + F if the application supports that function. Hope this helps!
  • Create New...