How do i get rid of these warnings?
Iโve unchecked read only and they keep getting reset.
The initial value is set to uniqueโฆ
And please donโt post a link to the documentation for primary key because Iโve read it, re-read it and still donโt understand.
#ERROR!
Also ensure that your data itself in the column is unique and there are no blanks
@Tammi_Canelli letโs shoot for Friday. 10am Central, is ideal.
Iโve been enjoying Discord for screen share, but we can also just use Hangoutsโฆ
Iโd expect to see that warning only if the Key column โRegIdโ had been marked as ReadOnly.
If it isnโt marked as readonly, you shouldnโt see the warning.
Also, Iโm still available for a screen share sessionโฆ I donโt charge for education. LOL
Tammi, warnings donโt usually prevent you from continuing with your app.
Just open them and they
will disappear.
You have marked the key column as read only. The editor is removing this option. The Read_Only would be okay if your table is just Read_Only. Because itโs not, your key column canโt be Read_Only because then you canโt add a new record.
Does this imply formulas must be in Data โ Column โ Formula and not is spreadsheet?
(kinda makes sense)
Generally speaking, your goal should be for your app to do as much of the processing as possible, and to avoid spreadsheet formulas as much as possible.
Actually Iโve unchecked the read only column each time the warning pops up and it just keeps resetting itself.
Grant, yes the uniqueid is set to the initial.
This particular app has just 3 tables.
The main registry table where I have a RegID that is the key.
This field has an auto-number from Smartsheet.
I set the initial value to unique and said editable if regid is blank.
Then i have a check in/out table that references the registry through the regID and has an ID field as key - the ID field is set to unique in initial value.
The 3rd table is just totals for charting - i have no errors or warnings on that one.
And yes Grant I would LOVE a screen share session!
Iโm working on documenting what iโve done so far and want to gather some specific questions for you.
How flexible is your schedule?
@Tammi_Canelli are your app and sheet formula fields blank in that column?
@Tammi_Canelli Iโm usually free from 10am to 2pm Central Time. Feel free to shoot me an email grantstead@steadglobal.com
I think a quick run through on some key database design elements would really set you in the right direction. You know what they say, learn the rules so you can break them.
Iโm free tomorrow until 1pm or Friday until 2pm (eastern time).
I can send you a calendar appt if either of these days work.
What program do you use to do the screen share?
Want to make sure itโs not blocked on my end.
User | Count |
---|---|
35 | |
34 | |
26 | |
23 | |
18 |