Forum Discussion

RajHelaiya's avatar
RajHelaiya
Qrew Captain
6 years ago

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

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
------------------------------
    • RajHelaiya's avatar
      RajHelaiya
      Qrew Captain
      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's avatar
        AdamKeever1
        Qrew Commander
        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
        ------------------------------
  • 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
    ------------------------------