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

Question

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 · Answer

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
------------------------------

evanmartinez · Answer

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 MartinezCommunity Marketing ManagerQuick Base------------------------------

rajhelaiya · Answer

Thanks Adam, I think this is an easier way to go. But I have a condition, if there are multiple fields in the child table and on the parent table I want to display certain fields based on certain conditions, say if a check box is checked only show 2 out of 3 fields from the child table when add button is clicked on the parent form. How does that work?

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

adamkeever1 · Answer

You would need to use dynamic form rules in the form settings:
You may need to use a formula field to compute a result for multiple conditions and then apply a dynamic form rule to that formula field depending on exactly what it is you need to do.------------------------------Adam Keever------------------------------

rajhelaiya · Answer

Thanks Adam, appreciate the quick response and help.------------------------------Raj Helaiya------------------------------

Forum Discussion

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

Related Content

Find and Replace Field Values

Using AND with Null values

Jinja If statement equals field value

AI Smart Builder for Creating Apps and Streamlining Pipelines

Grabbing value between 2 fields