Skip to main content
Question

How to create a table (like excel spreadsheet) on a form and store the values

  • January 7, 2020
  • 0 replies
  • 160 views

I want to create a 2 column table like a spreadsheet with 5 rows on a form. I understand we can use code pages to load a java script that can be invoked on a form using a formula field. I want to use a similar technique or any other if possible to load a table like structure on a form where user can enter values and those values be stored in a field or in any other way related to the record. Is this possible?

------------------------------
Raj Helaiya
------------------------------

AdamKeever1
Forum|alt.badge.img+2
  • Registered
  • January 7, 2020
You can create a table to store the values and use a relationship to add the values in your form. Take a look at this post:

Add multiple child records on a form at one time

------------------------------
Adam Keever
------------------------------

Forum|alt.badge.img+17
  • Community Moderator
  • January 7, 2020
Hi Raj,

Based on your description I would agree with Adam that using the method he linked would be your best bet. Allows for what you need and keeps it scalable with a related table of data and also helps it to be reportable in the future.

------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------