Leaderboard

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!

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.