Jump to content

PeterER8

Members
  • Posts

    16
  • Joined

  • Last visited

Everything posted by PeterER8

  1. Is it possible to rename the "Grid Edit" link text in tabular reports to something else, say "Mass Approve" ?
  2. Just tried it @GoodBoy Works on numbers but does not work on text strings which I suppose makes sense as one cannot calculate strings - correction it does work on everything
  3. Thanks @GoodBoy !!!! I really like the virtual fields solution, thank you! Just about to try it out !
  4. @TellMeWhy I think I need new glasses. Thank you!!!!
  5. Hi @autonumber Thanks for the feed back - not that is not it - what you are referring to are my poor redacting skills this is the actual code - so worst case scenario I should end up on google ... but nothing happens
  6. Hi @Meekeee Thanks for that, unfortunately that is not what I am after (the cascading element was the first one I learned See where it says "Shift Time" - ideally I would make the label text say "Shift start 06:00" or "Shift start 14:00" depending on the shift I select. In other words, this is not about data entry. This is about dynamic information change on the page for labels that explain data entry fields to the user.
  7. Hi All! I am following the "How to Build an Expense Reporting Application With Caspio / Part 4 of 5" tutorial on youtube and trying to make the authentication and redirect work. However, rather than using html pages I am using wordpress and a login page I created for this. I have created the login page in WP (and other pages as per the tutorial) and successfully embedded the Caspio code. The login screen is there when I go to the login page and I can log in. However, once I log in I would expect the "login Screen" datapage to redirect me to the page in the code. That does not happen. What happens instead is that I am still on the same WP page (the page where the Caspio login is embedded) but now logged in into Caspio. It does not redirect me. this is the code I am using in the HTML DtaPage <script> if("[@authfield:Users_Role]" == "Admin"){ window.location = ""https://mypage.com/Admin/"; } else if if("[@authfield:Users_Role]" == "Regional Director"){ window.location = "https://mypage.com/dashboard-regional-director/"; } else if if("[@authfield:Users_Role]" == "Local Director"){ window.location = "https://"https://mypage.com/dashboard-local-director/"; } else if if("[@authfield:Users_Role]" == "Site Manager"){ window.location = "https://"https://mypage.com/dashboard-site-manager/"; } else { window.location = "https://google.com/"; } </script> What am I missing here? Other than using WP I am following the tutorial to the letter. I even tried to use google as destination for the operator role (last else) with no luck. I also tried to embed the code and to use the caspio plugin - no difference. I am currently using the free Caspio account for testing and learning. I am using page Builder by siteOrigine and Astra Theme All help highly appreciated!
  8. Thanks @telly The automatic population is easy with cascading elements (one of the first things I tested while playing with Caspio) It is the multiple record insertion from a single datapage that is more important. Would one use virtual fields for that? I will be testing triggered actions shortly and will see how I can use that functionality. Peter
  9. I just tired my expression with Null and that did not work Hmm
  10. Thank you JolliBeng! This is perfect t! I assume this can also be used with null in the logical expression, for example in a case where the Reason_1 field is empty : (CASE WHEN [@field:Reason_1] = NULL THEN 1 ELSE 0 END)
  11. Hi Apologies upfront if my questions have been asked before (I could not find the answer). In my defence I am new to Caspio, started testing it last week and now have lots of questions. This one is regarding dynamically selecting data labels on submission datapage based on a field. Assume I have a shift field and in that field I can select “morning” or “afternoon”. Based on that selection I would want the labels for the next 4 fields to either say “08:00” , “10:00”, “12:00”, “14:00” or, if it is afternoon, “16:00”, “18:00”, “20:00”, “22:00” The exact times can be stored in a table called Shift_times that would look like this Shift_name, Period_1, Period_2, Period_3, Period_4 morning, “08:00” , “10:00”, “12:00”, “14:00” afternoon, “16:00”, “18:00”, “20:00”, “22:00” Depending on what I select on the submission form I would want the labels to pick the time labels from the Shift_times. Can this be done and if yes how ? I really appreciate any help you can give me!!!
  12. Hi Apologies upfront if my questions have been asked before (I could not find the answer). In my defence I am new to Caspio, started testing it last week and now have lots of questions. This one is regarding generating more than one table entry from a single submission form. Assume I have a DataPage where I list items that I own and the colour of each item. First, I enter a name (Max) in the name field, then in the item field I enter “ball”, then in colour I enter “white. On the next line in the item field I enter “toy soldier” and a colour I enter “green”. The table itself would look like this: Table: Name, Item, Colour. Row 1: Max, ball, white Row 2:Max, toy soldier, green If I would be doing this normally I would have to fill in my name each time I add a new line, press submit every time etc. But what if I want to do 5 entries at a time without having to repeat my name five times and without having to press “submit” five times. I really appreciate any help you can give me!!!
  13. Hi Apologies upfront if my questions have been asked before (I could not find the answer). In my defence I am new to Caspio, started testing it last week and now have lots of questions. This one is regarding hidden sections on a submission form and entering data in the fields there. So I have created a DataPage that depending on a Dropdown (either morning or afternoon) shows different sections (with the help of rules). If I select “morning” I get following cells that I need to fill with data from a dropdown ( [ ] signify the data entry cell on the form), the remaining fields remain hidden: 09:00 Result [ ] 10:00 Result [ ] 11:00 Result [ ] 12:00 Result [ ] If I select “afternoon” I get following cells that I need to fill with data from a dropdown ( [ ] signify the data entry cell on the form), now the "morning" cells are hidden: 15:00 Result [ ] 16:00 Result [ ] 17:00 Result [ ] 18:00 Result [ ] The table behind is as follows Table: Shift, Result09, Result10, Result11, Result12, Result15, Result16, Result17, Result18 The way this is setup is that automatic value in the Result fields will always be 0 at the start. However, the hidden section ends up empty at submission. When I then look in the corresponding table I get the following result: Table: Shift, Result09, Result10, Result11, Result12, Result15, Result16, Result17, Result18 Values: morning,0,10,11,0, , , , , The values of the fields that were hidden on the datapage are null/empty And the opposite happens if I select afternoon. Is there a way to fill these fields with the basic "0" rather than null if the section is hidden? Or, is there a way to use the same fields in both sections but with different data Labels (which also would reduce the number of fields). I really appreciate any help you can give me!!!
  14. Hi Apologies upfront if my questions have been asked before (I could not find the answer). In my defense I am new to Caspio, started testing it last week and now have lots of questions. This one is regarding DataType formula in tables and specifically trying to count the number of occurrences of a specific text string in that data row. Easy thing to do in excel (yes, I am damaged by too much excel usage). Basically I am after “count cells that contain x”. I understand the aspect that this only works for the row in which the formula field is present and that is perfectly fine. Example: I have the following table with the Counted_Field_Green field being a formula field and the values in each field below that. Table Fields: Date, Name, Reason_1, Reason_2, Reason_3, Reason_4, Test, Counted_Field_Green Table contents: 01/05/2021, Peter Max, Green, Yellow, Green, White, Yes, 2 This is what happens here, the formula in Counted_Field_green takes a look at the at the 4 Reason fields and counts the number of times that the entry “Green” shows up as a value. Kind of how countif works in excel or at least, I am after same functionality. Is there a way to make this happen in a Caspio table? If not is there a way to make it happen and populate a predefined field in a DataPage that calculates the presence of x in the entry fields? I really appreciate any help you can give me!!!
×
×
  • Create New...