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

5 Replies

Related Content

Find and Replace Field Values

Create new app - import a spreadsheet

Jinja If statement equals field value

Using AND with Null values

AI Smart Builder for Creating Apps and Streamlining Pipelines