Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by NiceDuck

  1. The answer is, use a date diff day function. kindof like this: Hope it helps, Quack.
  2. Just sharing again. On triggered action or task, there are certain cases where you need a condition if the current date is equal to the date value on the field. However, when you just use compare the date field into a timestamp using the "equal" operator, the results is always false due to "Timestamp" having a time values unlike the one on your current date.
  3. It appears to be doable but we have to make sure that your tables are normalized. for the 1 and 2, you can make a trigger like this to add or delete records from one table to another table. I am still checking on the other conditions you have when I have free time. I really think it is doable, you just really need to make sure that your tables are normalized
  4. Do you have a predefined data for this tables? I mean, Do you have an already existing data for this and you only want to display them or you also have a problem on how are you going to collect the data and save them in that pattern?
  5. I would like to help but Im am confused on your desired workflow. Please elaborate further.
  6. Hello Leon, On this case, we will need an indicator if a user is currently logged in or not. You may want to check this workflow discussed here: I hope it helps. quack
  7. If the table data source used in team a is related by a unique on the table data source of team b, perhaps we can make a view to join them then use that view as a data source for the team b?
  8. I first tried using a formula field on that but I noticed that the DatePart "weekday" function is not usable on the formula field, thus I have to use a trigger instead. Just sharing again, no problem here. feel free to comment if you have better suggestions. quack
  9. Hello again, I just want to share this workflow. In my tabular report, I want my records to be grouped by week but when I select the week rollup, it displays the weeknumber, (ex. week 1, week 2) instead of an actual date. Since I wanted to make it display the date of the first date of that week (ex, date of every sunday), I have made this workflow: First, I created an extra date field, then, I created a triggered action/task to process the data. This is the pattern I used: Then I used the extra field weekdate to group my records instead of using the "week rollup" function.
  10. May I ask for why not create two links the use the rules to hide or show the proper link depending on which value the virtual field has?
  11. I just want to share this workflow with you, this trigger block is what I used to convert my seperated time values into a single date value. There is no convert function on the trigger so I used this equation: I cant get rid of the time value of the timestamp but it gets the date!
  12. Just an update, You can also just use a non 'text' field without setting them to unique. On this case you just have to set them to calculated value then give it an invalid value if the condition you want is not met.
  13. We still dont have Union Join on views but we can use an extra table to contain a value from the tables you wanted to join as Union. First, the extra table should have an extra text255 field to handle the Id of its parent record besides its own. Then use task to copy the already existing records on both tables to the extra tables. Then Triggered action to copy the new records and update updated records on both tables.
  14. If you want to be selective where you want your users to decide to whether they want to retain the form's values or not. we can also create a workflow for that but it would be more difficult to set-up. 1st) create a virtual field and set it to checkbox. 2nd) create another virtual field and set it calculated values. Create a select statement that will check if the checkbox is checked. If yes, make it return a string of all your parameters and parameter names 3rd) on the action after submit, instead of setting it to "same page", set it to "new page" Enter the submission forms own URL, a question mark "?" and the virtual field which we set to calculated value.
  15. Yes there is, this is the basic way, assuming that your datapage is set to "same page" after submission
  16. Is there an option to the to the submission forms to make the field retain their values upon submission?
  17. As for the formula, you may refer to this one: Case when [@authfield:Role] = "paid" then"URL for report page" When (Select count (Id) from "extra_table_for_subform" where DateDiff(month, date, SysDateTime())) = 0) < 10 then "URL for report page" else "URL for notification message about limit" end LAstly, on your destination after submit, select the "Go to a new page" then use the virtual field as value along with the parameter I hope the idea helps.
  18. I have an Idea for this one but Its a bit tricky to set-up first, you will have to create a set-up where you are going to use a seperate search form results form. Please refer to this article: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-separate-search-page-and-results-page-into-two-different-webpages/ You will also need an extra table with similar design to your main table. Use that as the data source of your submision(search form). You will also need an authentication for this workflow. Even if your users are non paying, they should still have an account first before being able to access the forms. You will need to have an extra field on your users table which will mark which is paying and which is not. (preferably a text 255 which says "paid" or "free") Also, on your submission form, create an extra virtual field, set it to a calculation value that will check if the current users are paid users or not. If it determined that the users are non paying, it will count how many searches are conducted within the month. It can be done by using a conditional statement that returns the URL of the report page if the conditions are met properly. Otherwise, redirect the users to a different page which has a message that they have exceeded their limit search for the month.
  19. Please Note that the first block is just for inserting the values on my table, it is not actually necessary for the workflow.
  20. Hello I just want to share this workflow. This is a triggered action I made for converting Time to different timezone Hope it helps. Quack
  21. The other method I found is by placing an identifier on each datapage to check the status of the current user. This will require the following. 1) an extra field on the user accounts table (the table which your authentication uses as data source). Preferably, you can use a text 255. If you are using a view as a data source for your authentication, make sure to include the extra field on your view. 2)On every datapage you have, create an HTML block and insert the following script (you may want to try using the header instead) ******************** <script> if("[@authfield:extra_field]" == "Ban"){ window.location = "your_logout_URL"; } </script> **************************************** On this workflow, all the admin had to do is go to the user table and edit the "extra_field" value to "Ban". I prefer that you create a datapage for this instead and also, if you are using a view as an authentication data source, add a criteria on it to filter out records which "extra_field" is equal to "Ban" so they cant login again. The problem with this workflow is, your user will not be logout immediately. They will only be logout if they refreshed the page or go to a new page (given that all of your datapage has this code) I am still looking for other workaround but I hope this helps anyone. quack
  22. The first thing I did to achieve this is I created a dummy datapage with the same authentication as the one being used by the datapage your target user is using. If you have checked the "Only one session per user" you can log in using your target users credential and thus it will log them out on their end. This however, requires for the admin to know the password of the target user. Overall this will work but has some security and trust issues.
  23. Any Ideas for how on admin side can force logout a user of their application?
  24. @Shiro That will still depends on what is the calculation they are doing. There are chances that their formula is cannot be converted into triggered action. In my experience, TA is not that good on handling decimal values. They automatically round them off.
  • Create New...