Question

Creating a form

Forms

Updated September 7, 2023

asked on August 30, 2023

I am working on a form, which all the data will be pulling up from the database and its read-only format. I tried creating a form with table format but i could do same as excel. We need to create a from same as the Excel, the data needs to be populated in parallel depending up on the student they select. Also i am attaching my Excel format.

Please advice, thanks.

Capture.PNG (42.04 KB)

| Download

0 0

Replies

replied on August 31, 2023

Hi Mono!

Do you mean a form that if student name is selected, then the rest of rows in a project should be auto-populated? For example I fill a student name in project 1, then the rest of rows shall be filled with data from database? Same goes for project 2 and 3.

If that's the case, then you might want to use a collection and configure corresponding lookup rules. Trigger lookup rules to fill the rest of fields when a student name is matched. You can find more details here about collections and lookup rules .

0 0

replied on September 1, 2023

Thanks for your respond Wang. yeah we tried the way you mentioned, but the team wanted like below.

Project Detail.png (13.63 KB)

| Download

0 0

replied on September 5, 2023

Hi Mano,

Thanks for your respond. Would this kind of form works for you ?

By choosing student names form drop down, all other fields will be filled.

1 0

replied on September 6, 2023

Thanks Wang,

Yeah, this works and we have to test this. Can you tell me how did you do?

Thanks,

Mano

0 0

replied on September 6, 2023

Hi Mono,

The student name is a dropdown, where you can select student names, a lookup rule need to be configured here.

The titles of rows/columns are plain HTML, since it's static

Then I used single line for each cells, and erased its label. You actually can choose different type of fields as your cell (number/email/date/time etc.) depends on your need.

It's just a demo form trying to mock the excel you provided, feel free to extend and customize it for your needs.

Hope it helps :)

Thanks,

Yuxuan

1 0

replied on September 7, 2023

Thanks Wang, some in some case the student have only one project, some student have 2. how that one will work?

Thanks,

Mano

0 0

You are not allowed to follow up in this post.

Question

Question

Creating a form

Replies

Sign in to reply to this post.