PeterER8

Is it possible to rename the "Grid Edit" link text in tabular reports to something else, say "Mass Approve" ?

Having same issue as @Carlson

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

Thanks @GoodBoy !!!! I really like the virtual fields solution, thank you! Just about to try it out !

@TellMeWhy I think I need new glasses. Thank you!!!!

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

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.

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!

Thanks @JolliBeng

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

I just tired my expression with Null and that did not work Hmm

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)

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!!!

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!!!

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!!!