Hello,
I want to know if I could create a matching algorithm that would be able to connect two users together with the result being the same as a rider matching with a driver on Uber or Lyft. Is this possible? I am new to this forum, so please let me know if I should be posting this elsewhere.
Thank you!!
Hey @nocodebuilder, welcome to the community.
The Basic Dashboards Of AppSheet | AppSheet Explained - YouTube
and(
if(ISNOTBLANK(index(Current_User[User_Current_Fields], 1)),
in([Trapping_Location_Field_Link], LIVE_Scouting_Fields[Farm_FieldsID]),
in([Trapping_Location_Farm_Link], LIVE_Scouting_Farms[GrowerFarmsID])
),
if(ISNOTBLANK(index(Current_User[User_Crop_Type_Filter], 1)),
IN([Trapping_Location_Crop_Type],
split(CONCATENATE(Current_User[User_Crop_Type_Filter]), " , ")
),
true),
if(ISNOTBLANK(index(Current_User[User_Trap_Type_Filter], 1)),
isnotblank(INTERSECT(
[Trapping_Location_Trap_Types],
split(CONCATENATE(Current_User[User_Trap_Type_Filter]), " , ")
)),
true)
)
SELECT(patient_enrollment_records[PatientEnrollmentID],
AND(
IN([patient_link], [_ThisRow].[Report_Patient_Filter]),
IF(isnotblank([_ThisRow].[Report_Hospital_Link]),
[_ThisRow].[Report_Hospital_Link] = [Hospital_discharged_from],
TRUE),
IN([facilities_link], [_ThisRow].[Report_Facility_Filter_ID_List]),
SWITCH([_ThisRow].[Report_Status_Filter],
"Active",
AND(
[Enrollment_Active] = TRUE,
IF(IsNotBlank([_ThisRow].[Report_Date_Min]),
[Enrollment_Date] >= [_ThisRow].[Report_Date_Min],
TRUE),
IF(IsNotBlank([_ThisRow].[Report_Date_Max]),
[Enrollment_Date] <= [_ThisRow].[Report_Date_Max],
TRUE)
),
"Discharged",
AND(
[discharge] = TRUE,
IF(IsNotBlank([_ThisRow].[Report_Date_Min]),
[discharge_date] >= [_ThisRow].[Report_Date_Min],
TRUE),
IF(IsNotBlank([_ThisRow].[Report_Date_Max]),
[discharge_date] <= [_ThisRow].[Report_Date_Max],
TRUE)
),
OR(
AND(
OR(
[Enrollment_Date] >= [_ThisRow].[Report_Date_Min],
[discharge_date] >= [_ThisRow].[Report_Date_Min]
),
OR(
[Enrollment_Date] <= [_ThisRow].[Report_Date_Max],
[discharge_date] <= [_ThisRow].[Report_Date_Max]
)
),
AND(
[Enrollment_Date] <= [_ThisRow].[Report_Date_Max],
IsBlank([discharge_date])
)
)
),
IF(IsNotBlank([_ThisRow].[Report_Discharge_Reason_Filter]),
IN([status], [_ThisRow].[Report_Discharge_Reason_Filter]),
TRUE),
IF(IsNotBlank([_ThisRow].[special_status_filter]),
IN([Patient_Link].[Special_Status], [_ThisRow].[special_status_filter]),
TRUE),
IF(IsNotBlank([_ThisRow].[Report_Acute_Chronic_Filter]),
IN([Acute_or_chronic], [_ThisRow].[Report_Acute_Chronic_Filter]),
TRUE)
),
TRUE
)
Wow, incredible. I am not a programmer, not even a technical person, so I donโt have the ability to put in any code unless Iโm told exactly what code to put in and how, but the 7 minute video you included that I am going to watch looks like it might be a solution. Would that turn that translate that SQL algorithm into logic for the app or would it be doing something else? Iโm just trying not to place any of my own assumptions on it. Thank you!
Youโll have to develop your own version, obviously column names and tables and things will be named differently; but yeah you should be able to devise a formula that takes one set of criteria and matches it against another.
Whoah. I did not know that Appsheet was actually a low code platform. Wish they had a customer service live chat to help with that.
To make sure that Iโm understanding you correctly, in developing my own version, I can accomplish creating this matching algorithm
Kinda what this community is for!
I have never experienced an online dev community this supportive before. Itโs inspiring.
Indeed.
Looking at their plans again, is there a way to limit how many people could use the app as a consumer facing mobile app?
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |