Solved: How to prefill form from the same table - Page 2

drfuadj · 03-18-2023 06:31 AM

Hello, im using the "IC NUMBER" as an uniqueID for my registration form

When we entered the already registered IC NUMBER it will reject the registration which is how it should work,

Can we auto prefill the form if we enter the already registered IC NUMBER? the data source will be from the same table and not from REF table.

RedVox

One approach might be to have the user start by completing a small form where only the IC number is input. (This should probably be stored as a separate table.) A custom Go To View action could be assigned as the form save action, and an if statement in the trigger view field to check whether the IC number exists. If it does exist, use LINKTOFORM to prefill the new full registration with values from the existing record. If it doesn't exist, navigate the user to a registration form with only the IC number pre-populated.

View solution in original post