Chose table out of expression?

Hi,
I'm working on a new project where I will need to have alot of tables. I'm wondering if there's a way to select which table to use based of an expression. Is it? I'm pretty sure it isn't, but I wanted to double-check here with you guys just to be sure. I know I can use rules for it, but since I have 100+ tables, the amount of rules feels kind of unnecessary.

Thanks in advanced! :)

Comments

  • Braydon_SFXBraydon_SFX Member, Sous Chef, Bowlboy Sidekick Posts: 9,273

    You have 100+ tables? I'm pretty sure the cap is 50.

    Can you elaborate on your question.

    @ImNiklas‌ said: I'm wondering if there's a way to select which table to use based of an expression.

  • tatiangtatiang Member, Sous Chef, PRO, Senior Sous-Chef Posts: 11,949

    As @Braydon_SFX said, it would be helpful to know your reason for needing 100+ tables.

    To cut down on the complexity of rules, consider combining tables when possible. So for example if you had 10 rows for each level of a game and you needed 200 levels, instead of having 200 tables, you could have each level use an index row value. Level 1 would be rows 1-10, Level 2 would be rows 11-20, Level 3 would be rows 21-30, etc. and your index (starting) row would be calculated by (Level-1)*10+1.

  • ImNiklasImNiklas Member Posts: 103

    @Braydon_SFX said:
    You have 100+ tables? I'm pretty sure the cap is 50.

    Can you elaborate on your question.

    @tatiang said:
    As Braydon_SFX said, it would be helpful to know your reason for needing 100+ tables.

    To cut down on the complexity of rules, consider combining tables when possible. So for example if you had 10 rows for each level of a game and you needed 200 levels, instead of having 200 tables, you could have each level use an index row value. Level 1 would be rows 1-10, Level 2 would be rows 11-20, Level 3 would be rows 21-30, etc. and your index (starting) row would be calculated by (Level-1)*10+1.

    What I'm using the tables for is not important for the question. My question is if it is possible to chose a table from an expression, the same way as you for example can chose image for an actor with:

    Change Attribute self.image to "Image"..game.number

    Is that possible?

  • tatiangtatiang Member, Sous Chef, PRO, Senior Sous-Chef Posts: 11,949

    Fair enough. The reason I asked is because sometimes there's a way to simplify or merge table data to allow for much easier coding. But to answer your question: no, there isn't a way to select a table using an expression.

  • ImNiklasImNiklas Member Posts: 103

    @tatiang said:
    Fair enough. The reason I asked is because sometimes there's a way to simplify or merge table data to allow for much easier coding. But to answer your question: no, there isn't a way to select a table using an expression.

    Thanks anyways. I'd prefer to have alot of tables since I will constantly be updating them with more rows. I can use a different version of your method, but then I would instead need alot of colmuns. How many is possible in each table?

  • tatiangtatiang Member, Sous Chef, PRO, Senior Sous-Chef Posts: 11,949

    @ImNiklas said:
    I would instead need alot of colmuns. How many is possible in each table?

    I don't recall. I know I've used around 500 without issues.

Sign In or Register to comment.