Experimenting for the first time with a database and pulling through into a table.
The first issue i’m having is that when i add / remove columns in the database they don’t update from sandbox to live after syncing. Does this take time to up date or is it pretty instant?
The second issue is that the table on the webpage doesn’t pull through all the columns. It only shows the first three. I have linked the table to the database and tried again, but still the same issue.
If anyone as experienced this before and knows a solution or can help me as I would appreciated it.
Thank you.
See the article How to Sync Data Between Sandbox and Live Collections for the details of collection sync. Changes made in one (sandbox vs. Live) do not affect the other. You can peform different sync operations to allow data from one to be made available to the other with the limits as discussed in the article.
Thank you Yisrael, but it doesn’t explain why the data doesn’t pull through. Thank you.
You can add columns to your table from the Connect Table panel:
Or, you can also do this with code using the Table columns property.
Ok thank you Yisrael. I thought it pulled them all through, just referencing YouTube videos I’ve seen. I’ve pulled one column through, the other one called Lyrics (which references a PDF document i have uploaded into the database) is blanked out, can you let me know why i cannot access it? Thank you for your help, it is appreciated.
