PhelanSanders
Qrew Assistant Captain
Joined 7 years ago
User Profile
User Widgets
Contributions
Homepage accessible to Everyone on Internet Role
I have a link to an add form that is sent to users (everyone on internet) to add records only, however, the homepage is still visible which if selected takes the user to another unrelated page that is also public. Am I able to hide the home button somehow? ------------------------------ Phelan Sanders ------------------------------112Views0likes1CommentAccessing two public forms within the same table
I have two forms I want visible to Everyone on the Internet however the forms are within the same table. I'd like each form to be in add record mode only when the link to the form is selected and not via the dashboard. Thanks ------------------------------ Phelan Sanders ------------------------------89Views0likes1CommentPipeline between two apps
I have two applications both with the same type of field [ID Number] I want to update records in one application [App 2] only when there is a matching ID numbers in both apps. For example, If john smith has ID Number "123" and there is a John smith with the same ID "123" in the other app, then update ... ------------------------------ Phelan Sanders ------------------------------61Views0likes1CommentPipeline update record when numeric field value matches
I have two applications both with the same type of field [ID Number] I want to update records in one application [App 2] only when there is a matching ID numbers in both apps. For example, If john smith has ID Number "123" and there is a John smith with the same ID "123" in the other app, then update the record. ------------------------------ Phelan Sanders ------------------------------19Views0likes0CommentsFormula Text Field
I'd like to create one formula text field, not sure how to set up the conditions, believe it's a case condition. Below are the actual field names including dashes "-" all other fields not listed date are text fields unless noted. Will appreciate the help Display the text "Phase 1" All fields are NULL Program – HTH (Text field) RRH Match (Numeric Lookup) nonDHS Program – Manual Display the text "Phase 2" At least one of the following fields is NOT NULL Date of Match to Program - HTH nonDHS Date of Match to Program - MANUAL AND All of the following fields are NULL Date Provider Changed - HTH nonDHS Date Provider Assigned – MANUAL Display the text "Phase 3" At least one of the following fields is NOT NULL Date Provider Changed – HTH Most Recent Program Entry Date - RRH nonDHS Date Provider Assigned - MANUAL is NOT NULL All of the following fields are NULL Intake Date - RRH None of the following fields equal 'Approved' Application Status - HTH nonDHS Application Status - MANUAL Display the text "Phase 4" Application Status – HTH = 'Approved' OR Intake Date - RRH is not null OR 'Application Status – HTH' = 'Approved'. All of the following fields are NULL Date Unit Viewed - HTH Inspection Scheduled – RRH (date) nonDHS Date Unit Approved - MANUAL Display the text "Phase 5" At least one of the following fields is NOT NULL Date Unit Viewed - HTH Inspection Scheduled - RRH nonDHS Date Unit Approved - MANUAL All of the following fields are NULL Lease-up Date - HTH Recent Lease Start Date - RRH nonDHS Lease-up Date - MANUAL Display the text "Phase 6" At least one of the following fields is NOT NULL Lease-up Date - HTH Recent Lease Start Date – RRH nonDHS Lease-up Date - MANUAL ------------------------------ Phelan Sanders ------------------------------145Views0likes3CommentsRe: Formula Date field based on conditions
Getting an error below var bool newPlacement = [Entrance Reason] = "New Placement"; var bool changedRoom = [Entrance Reason] = "Customer Changed Room"; var bool newRoom = $newPlacement or $changedRoom; var bool customerReturned = $newRoom and ([Entrance Reason] = "Customer returned after Pre-Clearance departure"); var bool positiveContact = $newRoom and ([Reason for Placement]="Customer had contact with known positive"); var bool customerSymtomatic = $newRoom and ([Reason for Placement]="Customer is showing symptoms"); var bool customerPositive = $newRoom and ([Reason for Placement]="Customer is positive"); var bool noSymptoms = isNull([Last Date COVID-19 Test Completed]); var bool noSymptomsDate = isNull([Date of First Symptoms]); var date symptomsDate = if ($noSymptomsDate, ([Placement Date] + Days(10)), ([Date of First Symptoms] + Days(10))); var bool noCovidDate = isNull([Last Date COVID-19 Test Completed]); var date covidDate = if ($noCovidDate, ([Placement Date] + Days(10)), ([Last Date COVID-19 Test Completed] + Days(10))); var bool fourteenDays = todate([Placement Date] + Days(14), If ($positiveContact,$fourteenDays, $customerSymtomatic, $symptomsDate, <<<Error expecting bool but found date $customerPositive, $symptomsDate, $customerReturned, $symptomsDate) ------------------------------ Del ------------------------------9Views0likes12Comments