Hi, do to the nature if how the generator works, certain fields can’t be inputted by me as the would affect how my SQL table works. I’m trying to get a cost value (65) to be multiplied by a random number between 1 and 500. What would be the formula for this? 65 * RandInt(499)+1 was the closest i could think of.
For context it’s the base price for seeing a consultant, 65 euro * by the amount of times a patient visited said consultant , any time between 1 and 500. I can’t input a “number of times visited” field type as that already occurs in another table for my SQL and there’s no referencing feature in the generator.