Leaderboard

Hello! Caspio releases another new enhancement to the WebHooks feature, refer below: Caspio Webhooks allows your applications to communicate with third-party systems in real time when changes to data occur. In this release, we introduced the following updates: In non-HIPAA/Compliance accounts, webhooks logs now show the information sent and received. All accounts, including HIPAA/Compliance, now can: Send webhooks based on table events initiated by triggered actions and tasks. Configure webhooks for tables with triggered actions enabled for the same event as the webhook. A single REST API call can be used to activate or deactivate all events for a selected webhook. Source: https://howto.caspio.com/release-notes/caspio-47-0/#:~:text=Enhancements to Caspio Webhooks

I am afraid that here we shift in conceptual point of views. The detail you added shows a table (the one I used and that is a tipical concept of DBMS) that should bheave like a sheet (that is a tipical concepts of spreadsheets software). While spreadsheets easly refer data as-you-see and have primitives able to handle the previous-next concept or allow you to refer data by-cell, DBMS can have a likewise functionality implementing indexes. So the prev-next record is non necessary the prev-next record you see displayed but the one according the index you are referring to.... Speaking SQL, we can obtain the result you want in this way: SELECT index_key, order_nu, order_date, order_item, dollar_value, sum ( dollar_value ) over ( order by index_key rows unbounded preceding ) sum_of_dollar_value FROM Test_ordes; but I am afraid this is not possible to use in CASPIO. The workaround you could use is to add one more colum to the table that make the index of your table The change the task in this way: When you run it you get: ATTENTION: I think this is not a solution. It can be used as workaround if you consider: Values are not updated in realtime when you add a record, but only after the task runs We do not know what is the limits or constrains that could be arise when the table has a lot of records (perfomance? timeout?) The first to SET statements is the only way I found to initialize the variable. If you omit the first one the variable is instantiated as an integer and all decimals are lost The For statement cannot be done on the table, but on the SELECT result because you need to consider the ORDER BY The WHERE specification is needed otherwise you get the result of the last sum on all records..... I say again low-code bring an encapsulation of the below infrastructure and some capabilities you have using it directly are hided. Mark this as solved if you like.

Thanks @CoopperBackpack it works for my case. I'll insert data from #inserted table Rgds,

Hi @khale, Based on your workflow, it seems that a parent-child (one-to-many) table relationship is a better approach to having multiple dates on a calendar. I believe it will resolve the issue of the date being overwritten by a new date. The parent table could contain your clients' information, while the child table contains the dates of appointments. Here are also some article and video I found regarding the parent-child relationship: Creating a One to Many Relational DataPage Creating a One-to-Many Relationship — Child Forms and Child Reports in Caspio I hope this helps!

Hi @cianelectric, I don't think there are alternatives for cases like this. I remember I tried using a single-record update form and planned to just make my user remember this very unique ID so they can use it to look up their account, then change the password in the form but it requires the current password so they can create a new one. Looks like the password recovery form is the only way. You can try checking if the email and domain you use for sending the verification is verified to lessen the chance of your users not receiving the email: https://howto.caspio.com/notifications/email-notifications/verifying-email-and-domain/ Hope this helps you. I'll also follow this thread in case someone has other ideas

Hello Brian, I might not be understanding you, but you can configure the field to achieve that behaviour. When the checkbox is checked, then it will only show records that have the field empty, otherwise the report will show all the records.

Hi - Just another addition to this using the great syntax suggested by @Kurumi, if you ever need to do something with each word in a text field or string, you can use the following: CASE WHEN LEN('[@field:YourTextField]')>0 THEN STUFF((SELECT ' '+ UPPER(LEFT(value,1))+LOWER(SUBSTRING(value,2,LEN(value))) FROM STRING_SPLIT('[@field:YourTextField]',' ') FOR XML PATH ('')), 1, 1, '') ELSE NULL END In the above, the STRING_SPLIT function is used to separate each word in a string (using space (' ') as the separator) in separate rows instead of Selecting multiple rows from a Table. Once we have each word in a row, Upper/Lower/Substring functions are used to capitalize only the first letter. Then we "merge" every row back into one with the STUFF/FOR XML PATH functions. The CASE/WHEN was added because for some reason, if the field is blank the formula would output the whitespace hex code in a Calculated Value/Field. Input text: 'hi, this is a test' Result: 'Hi, This Is A Test' See this article STRING_SPLIT (Transact-SQL) - SQL Server for reference and an example. Hope this helps someone!

Thank you @ParkLoey and @imJihyo! That's very helpful.

Hi @ClayG! This seems to be a pretty simple app. Here's my suggestion: create a table where you will put all the booth locations create a table where the system will record who picked what booth create a submission form where vendors will choose a booth and submit a record vendors can choose a booth using a dropdown field which gets the options from the table where you put all booth locations Now, the thing you need to do to make the booth unavailable when a vendor has already chosen it is to use triggered actions. Make the trigger delete the booth on the booth table after it has already been chosen. Here's a sample of the trigger Hope this gives you an idea.

Hello, There is an option to set the Y Axis range manually: To change the chart using JavaScript, I found this article that shows some options: https://howto.caspio.com/tech-tips-and-articles/customize-caspio-chart-datapages/ I tried to change that code and I was able to make the Chart to always start from 0 on the YAxis and it seems to work for some Charts. Maybe there is someone else that knows a better approach: <script> document.addEventListener('DataPageReady', function() { var cleaner = function(interv) { clearInterval(interv); } let interv = setInterval(() => { if(typeof Highcharts == "undefined" || !Highcharts.charts.length) return; var seriesLength = Highcharts.charts[0].series.length; var getInsideValue = Highcharts.charts[0].series[0].userOptions.data.length; cleaner(interv); Highcharts.charts[0].yAxis[0].min = 0 Highcharts.charts[0].redraw(); }) }); </script>

Hello @bookish, As far as I understood you need to stamp the time when the specific field is updated. The basic approach to track the changes is: 1) To join the Table and the #inserted table on the unique field. This is needed to identify the record that is being updated. 2) To compare the previous value and the new(updated) value. If they are not equal, this means that the value was updated. For example, the 'Update_Date' field will be updated when the 'Name' field is changed. Could you clarify this part 'but not when non-payment fields are updated'? In my understanding, the field you are interested in can be updated along with the other fields. So, if you only need to track the change in the specific field regardless of the other fields, the example on the screenshot should work. Feel free to ask questions if you need further assistance on this.

Hello @ForeGolfer, The methods listed in Swagger UI are the available methods. So, as for the object creation, it is only possible to create a Table. All the other objects should be created manually in the account. As for the Triggers, they only work with the existing tables and fields of these Tables.

Thank you for the fast and great answer! After reviewing your answer, I was thinking I can also just do a virtual field that is the sum of those two prices. I could also hide those 2 fields. Then I'll see if the normal aggregation allows me to reference the virtual field.

For #2 and #3, The common workaround we do is that, have the DataPage where the user can generate the PDF be accessible to the target receiver as well. For example, include the URL of the DataPage in the email so the user can just go there an download the PDF on their own since we cannot attach them on the email.

For #2, do you mean like automatically save the PDF in the Caspio Bridge account as a record? If that's the case, I don't think we have that yet as well. PDFs are generated on the user level only to be downloaded, and it does not have any function to have them saved automatically as new record.

Hello, I'm not sure about the #2, but the #3 is not possible. Triggered Action cannot send an email with attachments. The only email function that has that is the notification email in DataPage level.

Hi Aleksandra, I'm not sure exactly what you need but if you want to only display the task/projects that are assigned to you you can use RLS(Record Level Security) for reference you may check: https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/restrict-access-to-data-by-user-or-role/ . If that's not the case perhaps you can elaborate more?

Hi Emmanuel Katto, CRM is Customer Relationship Management . It helps to manage customer data. Businesses generate vast amount of data everyday. To manage this enormous amount of data, companies need CRM systems. A CRM system essentially provides a central place where businesses can store customer and prospect data, track customer interactions, and share this information with colleagues. It allows businesses to manage relationships with customers, helping the business to grow. Thanks!

@kpcollier, thanks for your suggestion above. While I wasn't able to use your exact selector to get rid of the "flashing regular tabular report before grid edit," you gave me the idea and I was able to make it work with a different class selector. The CSS that I am using is shown below. Also, @oliverk, this may help you. I simply placed this CSS Style as the very first item in the header (to make sure it runs and hides the tabular report before anything else runs) and so far so good. When I open the datapage, there is a very short delay before the grid edit mode shows up, but fortunately only a blank white screen is now showing during that delay. <style> .cbResultSetTable { display: none !important; } <style>

Hello @ClayG, I agree that it is better to avoid using the List data type in more or less complex workflows. This data type has a number of restrictions, e.g. it is impossible to use it in Charts, Pivot Tables, Grouping, Aggregations, Formula Fields, and Calculated Fields. I would like to share some points regarding List data types and REST API for future reference. 1) Syntax example to add a field with List data type to the Table. { "Name": "Cities", "Type": "List-String", "Unique": false, "DisplayOrder": 0, "ListField":["London", "Paris", "New York"] } 2) As far as I know, the list of values in the List data type field is the subtable. Values are stored in this subtable in the format: "Cities": { "1": "London", "2": "New York", "3": "Paris" } If this field was added to the Table via REST API, the values are sorted in ascending order and indexes corresponding to the ordinal number are applied. 3) To insert(POST) or update(PUT) this field within the record one needs to refer to the value by referring to its index. Example: The same logic can be used for this PUT method: 4) However, we cannot reference the values that are stored in the subtable (we can reference them by index, but not by value). Therefore, it is impossible to use the List data type field in the WHERE clause (for example, I need to search for the records where the city has 'New' in the name: New Delhi, New York, New Orleans, etc.) It is impossible to use the following syntax: So, in the GET requests the List data type field just can be used in the list of fields to select from the Table.

Hi @vinebath, You can add a Glyph icon with the additional CSS styles and bootstrap library: 1. Open "Search and Report Wizard - Configure Search Fields" screen, where should be at least one field. Create a Header and Footer element and two HTML blocks, where the HTML editor should be disabled. Please look at the screenshot below to see the structure of the DataPage elements: 2. Move to the Header and put the following code there: <link href="//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css" rel="stylesheet"> <style> .cbFormTextField { padding-left: 25px; } .inner-addon { position: relative; } /* style glyph */ .inner-addon .glyphicon { position: absolute; padding: 10px; pointer-events: none; } .glyphicon { top: 11px !important; } /* align glyph */ .left-addon .glyphicon { left: 95px; } /* add padding */ .left-addon input { padding-left: 30px; } </style> 3. Put the following code into the first HTML block: <div class="inner-addon left-addon"> <i class="glyphicon glyphicon-search"></i> 4. Put the code below to the second HTML block: </div> 5. The result is the following:

Hi, just to add to the previous comment. Yes, Caspio has a disclaimer that says : "This is a Caspio free app. Do not submit passwords or other sensitive data. Report Abuse" this is to ensure that the page is not used as a phishing site since this is a Free account. I also suggest to upgrade your plan and I recommend to review Caspio new pricing plan's resources to ensure the needs of your application. You can visit the newest pricing plan at these sites and for you to not worry about the disclaimer. For Standard Plan:https://www.caspio.com/pricing/standard-edition-plans-features/ For Premium Plan: https://www.caspio.com/pricing/premium-edition-plans-features/