Jump to content

astroboy

Caspio Guru
  • Posts

    143
  • Joined

  • Last visited

  • Days Won

    2

astroboy last won the day on September 25 2020

astroboy had the most liked content!

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

astroboy's Achievements

  1. Hello again, I found this interesting solution using a different approach while browsing the forum page and you may want to check it out as well:
  2. Hello, it seems that the workflow for this HowTo article is similar to what you are trying to achieve: https://howto.caspio.com/tech-tips-and-articles/common-customizations/dynamic-redirects-after-form-submission/ I hope this helps. Cheers!
  3. If it helps, you may also reduce the number of visible options in dropdown fields by enabling the Record Level Security feature on the form element configuration. Here's a HowTo article for more information: https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/record-level-security/
  4. astroboy

    Dropdown List

    Hi, if you want to know more about list data types, I suggest checking this video tutorial:
  5. Hi, if you are still in the process of building your application, I suggest checking this presentation from Caspio regarding the best practices in establishing your table. It was also mentioned in the presentation that numeric values that are never used as numbers such as phone number, social security number, zip code, etc. should always use text (255). You may check the article through this link: https://howto.caspio.com/tables-and-views/table-and-database-design/
  6. To add on this, you may also reduce the number of visible options in dropdown fields by enabling the 'Record Level Security' feature. Here's a HowTo article for more information: https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/record-level-security/
  7. Hi, if it helps, I found this HowTo article about PDF download that seems to cover this topic: https://howto.caspio.com/datapages/pdf-download/pdf-download/
  8. Hello there, I encountered a similar workflow in the past but instead of doing it on the table level, I created mine on the DataPage level. This is possible using calculated fields with the help of SELECT and CASE WHEN statements. The only downside of this solution is that the output is not being saved in the table. For reference, you may check this HowTo article: https://howto.caspio.com/function-reference/
  9. As for the calculation, you may check the function reference article to see the list of available functions that you can use to achieve your ideal output: https://howto.caspio.com/function-reference/
  10. Hello there, since these records are coming from different tables with a relationship established between them, I would recommend creating a view to join these tables and merge the matching records. Here's a HowTo article for reference: https://howto.caspio.com/tables-and-views/what-are-views/views/
  11. Hello there, I also read in one of the HowTo documentations that numeric values that are not used as numbers such as ZIP codes, phone numbers, and social security numbers should always use Text (255) as the data type. For more information, you may check this link.
  12. Hello there, since your workflow seems to have many tables with related records, I suggest joining those tables to your Triggered Action as seen on the example provided above. Also, you may try playing around CASE WHEN blocks if you have any conditional scenarios that you need to prompt using triggers. For more information, you may check this HowTo article: https://howto.caspio.com/tables-and-views/triggered-actions/
  13. astroboy

    John

    For starters, I highly suggest watching these three video tutorials that really helped me a lot in understand most features in Caspio: - Basic Training with Caspio - Introduction to Application Building - I hope you find these videos helpful as much as I did. Cheers!
  14. If your goal is to be able to submit on both tables, you may also try creating a dummy table that you can use as the data source of the submission form and temporary storage for the records and then transfer them to their respective tables using Triggered Actions. Here's a HowTo article about Triggered Actions for more information: https://howto.caspio.com/tables-and-views/triggered-actions/
  15. Just to add on this, I believe you can also place the code inside an App Parameter and use that for your labels inside your DataPage. Here's a HowTo article for more information: https://howto.caspio.com/apps/app-parameters/using-app-parameters/
×
×
  • Create New...