vanderLeest
-
Content Count
59 -
Joined
-
Last visited
-
Days Won
2
-
Alternative to Single Sign On.
vanderLeest posted a question in Security, Authentications, Roles, SAML
I have setup 2FA for external users. To enable an extra level of security (for malicious hackers) as well as an already trusted user interface/landing page for internal users, my idea is to route internal users through another application named PALMS, which they are already familiar with. As they log into PALMS, their login instance receives a unique token (picked from a table with 1 Million predetermined tokens). My Caspio app will have an identical table of with the same 1M tokens. The link from a PALMS page to the Caspio App will have the following structure: <a href="URL -
vanderLeest reacted to an answer to a question:
Comparing Dates on trigger.
-
Change a header of a Submission DataPage based on a value on the page
vanderLeest replied to vanderLeest's question in DataPages
Hi again, CoopperBackpack, I changed the page's source from a View to a Table, and the two virtual fields are now calculated values based on a select statement, drawing information from a View. Now the JS script no longer works. Do you have any ideas why, and for a workaround? Uncaught TypeError: Cannot read property 'value' of null at HTMLDocument.<anonymous> (8777500065adaf522f0942fca682?ID=414:935) at f_dataPageReadyEvent.dispatchEvent (8777500065adaf522f0942fca682?ID=414:2473) at f_dataPageReadyEvent.init (8777500065adaf522f0942fca682?ID=414:2473) -
Two factor authentication for end users
vanderLeest replied to Shuchi's question in Security, Authentications, Roles, SAML
Starting with LittleMsGinger's workaround (and using her validation trick based on virtual fields ), Dmytro from the helpdesk and I came up with the following routine, which also works for a Direct Deploy URL (NB. Testing is best done via an incognito window of your browser, and by having a log-out page open.) Two-Factor Authentication – Two Tables, Two DataPages --> An auto-submit Submission DataPage ‘Log_Auto_Form’ for tracking log-in records in the T_Log table. On entering an email and a standard password via a User Authentication, the Log_Auto_Form page emails a One-Time -
I would love to have a bit more detailed advice from NiceDuck too. I'm stuck at the same point.
-
Two factor authentication for end users
vanderLeest replied to Shuchi's question in Security, Authentications, Roles, SAML
Thanks so much LittleMsGinger, Three questions: 1. Can you describe the whole process, and how these DataPages each play a roll? 2. What are the DataPages you point to as the value for window.location in the javascripts, for both the Acknowledgement Email and Standalone Login Screen? 3. How did you finish the Details Page (at step 6) ? Does direct to the original/intended destination page? Floris -
vanderLeest reacted to an answer to a question:
Change a header of a Submission DataPage based on a value on the page
-
Change a header of a Submission DataPage based on a value on the page
vanderLeest replied to vanderLeest's question in DataPages
Thanks CoopperBackpack, your solution worked (almost perfectly). I put your JavaScript in the header of the DataPage, and changed the option around, as title == title1, the innerHTML of the H4 header should read "Add your Invoice and Financial Statement Report". Floris -
Change a header of a Submission DataPage based on a value on the page
vanderLeest replied to vanderLeest's question in DataPages
Hi CoopperBackpack, I will definitively give your suggestion a go (next week) and let you know how I go. Floris -
Change a header of a Submission DataPage based on a value on the page
vanderLeest posted a question in DataPages
I want to change a header of submission datapage based on a comparison between two virtual fields on the page. The virtual fields are fixed values for the record drawn from an underlying query, using dropdown values. If Virtual 2 <> Virtual 3 a section with a submission field for the Financial Statement Report is hidden (via Rule 1) , and if Virtual 2 = Virtual 3 the same field is set to be required (via Rule 2). I did not create the header, but it looks currently like this: <div class="container mt-3 mb-3"> <div class="row"> <div class="co -
vanderLeest reacted to an answer to a question:
Using Table Variables in Triggered Actions
-
The issue resides within an incorrect table name in the join statement in both select queries: The join is pictured with the (alias name of the) T_PA_SubAwards_1 table, it should be with (the original) T_PA_SubAwards. To me this is counter-intuitive (as the line above 'defines' T_PA_SubAwards as T_PA_SubAwards_1), that said, somehow it makes more sense too. ;-) The pictured task will update the SA_Last_MS field in the table T_PA_SubAwards with the Max value of the field PeriodNo in the subsidiary T_PA_Milestones table, but only if that MAx value is different than the current valu
-
I want to update the SA_Last_MS field in the table T_PA_SubAwards with the Max value of the field PeriodNo in the subsidiary T_PA_Milestones table. The two tables are linked via the fields SA_RecNo and MS_SA_ID. The task pictured runs but gives a value of 2 for all SubAwards with Milestones, and that is correct for most of them, although two SubAwards have 4 and 5 milestones, and these are erroneously set to 2 too. Can someone tell me what is going on?
-
Align field names and field values in an auto-email as in a table
vanderLeest replied to vanderLeest's question in Styles and Localizations
Thank you both LittleMsGinger and CoopperBackpack so much Once you know these options, it is easy. Sadly enough, I did not find them myself intuitively. -
vanderLeest reacted to an answer to a question:
Align field names and field values in an auto-email as in a table
-
vanderLeest reacted to an answer to a question:
Align field names and field values in an auto-email as in a table
-
Leon13 reacted to a question:
Align field names and field values in an auto-email as in a table
-
I would like to format the auto-email on submit of an update form as neatly aligned table Vendor Number [@SA_Vendor_ID] Invoice Number [@MS_InvNo] Current Date [@Date()] Total Amount [@MS_InvAmount] Currency (fixed “USD”) SES Number [@MS_SESNo] PO Number [@SA_Purch_Order]
-
vanderLeest reacted to an answer to a question:
Hide blank fields in automatic email?
-
The limit for Number fields is 15 digits (including a floating decimal), and 10 digits for an Integer field. A minus sign counts as a digit in the case.
-
Thanks SunakoChan. to create a rendering of a period between a Start and and End date like Jan '19 - Feb '20, Dmytro and I came up with the following formula (for a formula field), using your substring idea: CONVERT(VARCHAR, (SUBSTRING('Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ', ((Datepart(month, [@field:MS_StartDt])) * 4) - 3, 3))) + ' ' + Char(39) + CONVERT(VARCHAR, (Right(Year([@field:MS_StartDt])+ 1,2))) + ' - ' + CONVERT(VARCHAR, (SUBSTRING('Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ', ((Datepart(month, [@field:MS_EndDt])) * 4) - 3, 3))) + ' ' + Char(39) + CO
-
vanderLeest reacted to an answer to a question:
Date format
-
Change background color after expired
vanderLeest replied to thompson's topic in User JavaScript and CSS Discussions
Thanks this works I used: CASE WHEN LEN([@field:MS_InvAmount]) > 0 AND Len([@field:MS_Budget]) > 0 AND Round([@field:MS_InvAmount],0) > Round([@field:MS_Budget],0) THEN '<span style="color:red;">'+cast([@field:MS_InvAmount] as nvarchar)+'</span>' ELSE CAST([@field:MS_InvAmount] as nvarchar) END But sadly, instead of $300,000 in red, I get 300000.00 in both the Result Page as well as in the Details Page of my Tabular Report DataPage.
