Cloud Backend (Cloud DB, API Builder)

• M

  Additional elements in Header, Desktop vs. Mobile
  • Meir Sabbah  

  1
  0
  Votes
  1
  Posts
  3
  Views

  No one has replied

• 

  Default Timezone
  • Pierre SULPICE  

  3
  0
  Votes
  3
  Posts
  8
  Views

  

  Ok I'll go with that, thanks !
• D

  Advanced SQL Field Types
  • Daniel Mulroy  

  3
  0
  Votes
  3
  Posts
  17
  Views

  

  Hello Daniel, Linked field by reference will store the id of the element in the selected table => 1 Linked fields by reference will store a JSON Array of ids => ["1","2"] Linked field by value will store the value of the element in the selected table => 'Jean' Linked fields by value will store a JSON Array of values => ["Frederico","Jessica"] The main criteria to decide whether you use by reference or by value is if you want it to be static or updated at each modification. If you use by reference, you will need to do join operations to get the linked element but you will always have the updated value. If you use by value, you will directly have access to the value but if it changed in the other table, it won't change here. Another concern is that you will only have access to this field from the other table. When you use by reference you can select other fields as well.
• D

  Production version of API and scheduling
  • Daniel Mulroy  

  2
  0
  Votes
  2
  Posts
  15
  Views

  

  Hello Daniel, Yes, it triggers the production version from your function.
• R

  This topic is deleted!
  • Robert Chura  

  1
  0
  Votes
  1
  Posts
  12
  Views

  No one has replied

• D

  Download nightly backups of individual tables?
  • Daniel Mulroy  

  2
  0
  Votes
  2
  Posts
  10
  Views

  

  Hey Daniel, unfortunately it's not possible and would not be practical and efficient for us to do backups at table level instead of DB level. What we usually do to restore just one table from a backup: restore the backup (either locally on your computer or in a new project on AppDrag) export in CSV the table you are interested in Clear the table you want to restore (to make it empty before the restore, use the Clear command we have on the table in cloudbackend) import the CSV of your table Done
• K

  Can I leverage socket.io via the API Builder or Page builder?
  • Konrad Hylton  

  3
  0
  Votes
  3
  Posts
  15
  Views

  K

  @Joseph-Benguira Thanks, Joseph! I'll look into those links and play around with them in the meanwhile.
• J

  This topic is deleted!
  • John Lamb  

  2
  0
  Votes
  2
  Posts
  7
  Views
• J

  Date Functions?
  • John Lamb  

  4
  0
  Votes
  4
  Posts
  9
  Views

  

  In VisualSQL, Formulas can be user in WHERE conditions ... not to format the selected data and the output ... you can do that only in Raw SQL
• J

  Scheduled Tasks
  • John Lamb  

  2
  0
  Votes
  2
  Posts
  9
  Views

  

  Hey John in the recurrence mode "EVERY DAY", what you indicate is the interval of execution (every 4h, or every 5 minutes for eg) Please note: It's not possible to schedule jobs below 5 minutes interval Eg: this means every 5 minutes
• J

  Visual Select Descending not working
  • John Lamb  

  2
  0
  Votes
  2
  Posts
  12
  Views

  

  Hey John, Please ensure the data type of your column is numeric (Integer or decimal) and not as TEXT then the sort will work as expected
• 

  I see 500 rows free in a database does it mean we get maximum 500 enquiries in contact forms, for more do I need to pay?
  • Question.BOT  

  2
  0
  Votes
  2
  Posts
  8
  Views

  

  Hi, Blog, shop & Contact forms don't count to the 500 lines quota! The 500 rows limit is only for the tables you create by yourself in our CloudBackend.