Discussions

Expand all | Collapse all

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

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

    Posted 01-07-2020 14:29
    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
    ------------------------------


  • 2.  RE: How to create a table (like excel spreadsheet) on a form and store the values

    Posted 01-07-2020 14:42
    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
    ------------------------------



  • 3.  RE: How to create a table (like excel spreadsheet) on a form and store the values

    Posted 01-07-2020 15:31
    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
    ------------------------------



  • 4.  RE: How to create a table (like excel spreadsheet) on a form and store the values

    Posted 01-07-2020 15:41
    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
    ------------------------------



  • 5.  RE: How to create a table (like excel spreadsheet) on a form and store the values

    Posted 01-07-2020 16:17
    Thanks Adam, appreciate the quick response and help.

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



  • 6.  RE: How to create a table (like excel spreadsheet) on a form and store the values

    Posted 01-07-2020 15:05
    Edited by Evan Martinez 01-07-2020 15:04
    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
    ------------------------------