I need to create 930 fields in a datatype, and I don’t want to do this manually. Any suggestions?

[image] robert: Each field represents a numerical value for a particular record. Each value is unique, so i m not aware of a better way of doing this. Are they name value pairs ? So does each numerical value have a descriptor of what it is ? I would be trying to do this as a list field to …

Without knowing more, making suggestions are like stabbing in the dark, but I’ll close my eyes and try anyway. If you are only going to be reading and updating the fields (and not searching or filtering) you could find logical ways to group them (say 100 at a time) and store them as delimited string…

Yes, each numerical value has a descriptor. Think of it like this. The data, originally, is a table. Columns B - AW (48 total), and rows 2 - 24 (23 total) for a total of 1,104 unique combinations. There are 176 always invalid combinations, for a total of 928 possible unique numerical values per r…

If I grouped them by column, there would be 48 groups/data types. I don’t think this would simplify anything. Part of the problem is my limited knowledge in this area, so I am certain that I am not explaining this properly. It’s a problem of each record having its own 2x2 table. This led me to f…

Thank you @NigelG . I’ll look into the list field. That would potentially make things much easier…48 list fields.

In testing this, I have run into the bracket problem, which apparently still has not been addressed… [image] List of things- export/import Need help Having trouble getting the list of things into the right format so it uploads. What I’m doing: Example data (list of thin…

This is enormously frustrating. Can’t get the data to upload into the database using a common csv.

Seriously, this shouldn’t be this difficult.

It doesn’t work with lists of texts (for example) but you can quite easily upload multiple tables and link them together. You if you upload table a and table b, you can then a bulk API to link a and b.

will it work with lists of numbers?

Create a large number of fields in a datatype by upload?

Need help Database

robert March 12, 2018, 6:35pm 11

In testing this, I have run into the bracket problem, which apparently still has not been addressed…

Topic		Replies	Views
How do i create a task's data type? Database	2	242	August 28, 2023
How to create many new fields on DB Database	2	296	December 16, 2023
Is it possible to add Fields for a Type in batches? Database	2	301	October 25, 2022
Create tables via API APIs	3	112	July 20, 2024
Bulk Create New Field Database	2	507	March 30, 2021

Create a large number of fields in a datatype by upload?

Related topics