Form Field Names => Id mapping

build the label to Table field map
  • run query: Select * from Trip_Team_Selection limit 1
  • get_col_info()
  • dump of get_col_info
  • see column: Village_Trip_Lookup
    column type = 253
    see column: Member_Name
    column type = 253
    see column: ComLog
    column type = 253
    see column: Assignment
    column type = 253
    see column: Request
    column type = 253
    see column: Trip_Status
    column type = 253
    see column: Pilot_Transport
    column type = 253
    see column: Arrival_Date_Time
    column type = 12
    see column: Signup_Complete
    column type = 253
    see column: Trip_Exp_Status
    column type = 253
    see column: SUBTEAMID
    column type = 8
    see column: Status_on_Team_per_trip_leader
    column type = 253
    see column: Pull_Chapter
    column type = 253
    see column: USERID
    column type = 8
    see column: ID
    column type = 8
    see column: Name_of_Requested_Roommate
    column type = 253
    see column: Emergency_Contact_Name
    column type = 253
    see column: Weight_your_person
    column type = 253
    see column: Pull_Zone
    column type = 253
    see column: Room_Assigned
    column type = 253
    see column: Passport_Link
    column type = 253
    see column: Weight_equipment
    column type = 253
    see column: Comments
    column type = 253
    see column: Share_Email_Cell
    column type = 254
    see column: Emergency_Contact_Email
    column type = 253
    see column: Pull_Departure_Date
    column type = 10
    see column: Trip_Leader_Email
    column type = 253
    see column: Pull_Member_Name
    column type = 253
    see column: Pull_Passport_id
    column type = 253
    see column: Arriving_Flight
    column type = 253
    see column: Attest_Roster_Record
    column type = 253
    see column: Pull_Email
    column type = 253
    see column: Agree_Important_Info
    column type = 253
    see column: Trip_Waiver_Status
    column type = 253
    see column: Departure_Date_Time
    column type = 12
    see column: Emergency_Contact_Cell_Phone
    column type = 253
    see column: Trip_Expense_Received
    column type = 253
    see column: Trip_Waiver_in
    column type = 253
    see column: COVID_Vac_Link
    column type = 253
    see column: Departing_Flight
    column type = 253
    see column: Agree_Release_Indemnification
    column type = 253
    see column: Subteam
    column type = 253
    see column: Pull_Village_Trip
    column type = 253
    see column: Weight_baggage
    column type = 253
    see column: Emerg_Contact_found
    column type = 253
    see column: TRIPID
    column type = 8
    see column: Trip_Expense_Still_Due
    column type = 253
    see column: Status_Changed
    column type = 253
    see column: I_m_available_to_work_Oasis_only
    column type = 253
    see column: IP_Address
    column type = 253
    see column: Update_Date
    column type = 12
    see column: Update_UserID
    column type = 253
    see column: SubmissionID
    column type = 3
    see column: sendConfirmEmail
    column type = 1
    see column: sendFeesEmail
    column type = 1
    see column: sendBackupEmail
    column type = 1
  • creating Form Id Select List
  • Village_Trip_Lookup
    Member_Name
    ComLog
    Assignment
    Request
    Trip_Status
    Pilot_Transport
    Arrival_Date_Time
    Signup_Complete
    Trip_Exp_Status
    SUBTEAMID
    Status_on_Team_per_trip_leader
    Pull_Chapter
    USERID
    ID
    Name_of_Requested_Roommate
    Emergency_Contact_Name
    Weight_your_person
    Pull_Zone
    Room_Assigned
    Passport_Link
    Weight_equipment
    Comments
    Share_Email_Cell
    Emergency_Contact_Email
    Pull_Departure_Date
    Trip_Leader_Email
    Pull_Member_Name
    Pull_Passport_id
    Arriving_Flight
    Attest_Roster_Record
    Pull_Email
    Agree_Important_Info
    Trip_Waiver_Status
    Departure_Date_Time
    Emergency_Contact_Cell_Phone
    Trip_Expense_Received
    Trip_Waiver_in
    COVID_Vac_Link
    Departing_Flight
    Agree_Release_Indemnification
    Subteam
    Pull_Village_Trip
    Weight_baggage
    Emerg_Contact_found
    TRIPID
    Trip_Expense_Still_Due
    Status_Changed
    I_m_available_to_work_Oasis_only
    IP_Address
    Update_Date
    Update_UserID
    SubmissionID
    sendConfirmEmail
    sendFeesEmail
    sendBackupEmail