Limited editing for users
I want my users to be able to edit their data entry without being able to edit the application. How can I achieve this?
Mandatory attachement
Hello, how to force the user to attach a file to validate the recording? Regards,
Cannot figure out how to fetch data from a subform field (on_user_input)
Hello, I am a new to Zoho (just bought the license) but I am an experienced programmer and database developer. Yet I could not figure out how to fetch data from a field in a subform. I am following the documentation, in my subform, my lookup field execute a field action script on_user_input. The goal is to fetch an unit cost for the selected product - very basic stuff ! So my script is the following: selected_ingredient = Ingredient_form[ ingredient_name == row.ingr_name ] ; Ingredient_form = name
Problem to join a group when account was created through Google (federated login)
Hello, We have users in Zoho with federated accounts (Google login). In creator i created a group and added the users I wanted to join. They received an email invitation to join the group, but they cannot proceed with the invitation request since they have to log and only an username/password is asked. They cannot log with their Google federated login credential. Is there another method?
Record Limit Workaround
I'm working on an app for a client that holds practice SAT tests. They want the app to be able to create and store 200 question long tests for up to 100 students (currently, although they plan to expand in the future), and each student may have up to 5 different tests. They also want the app to include a variety of Zoho Reports showing breakdowns of statistics about types of questions, responses, and so on. Right now I have it set up so each separate question on a test is its own record, as is each
Email Notification via custom action - Urgent Request
Hi, Is it possible to send email notification via custom action for a particular record and include user submitted data template (custom record summary) as pdf? Please let me know your answer at the earliest. Thanks! -V
Help required field (mandatory)
HI I have a required field that is hidden. But when I send the form I got an error because the hidden field must be filled. How can i do? Thanks
I need help in report.. Formula Field Logic
I'm using 3 formula field. One time commission, Monthly Commission and Grand total (total of 2 ) It is working but i need to ask what if One time payment is Paid, How can i put logic to formula field that it will not add The onetime commission to the grand total and it will just show a 12usd instead of 232usd.. please see picture pelow One time Commission is made up of 2 number fields Monthly Commission is made up of 2 number fields Grand Owe is made up of 4 Number Fields This is what i want
Anyone know the Zoho Invoice Status Codes?
If I do a call to Zoho invoice and want to return the status of a particular invoice, all I get is a string number as opposed to the actual written value of it (i.e. "5" for "Void" etc) I've been searching far and wide, but have yet to find a resource that contains the translations for these... so far I've been able to extrapolate two and script them like so: i = Invoices [ID == c.Select_Invoice]; s = zoho.invoice.getInvoiceInfo(i.Inv_IDN); st = s.get("Status"); if (st
Issue with Summary View- urgent
Hello, I have an urgent issue which has recently occurred on our Zoho Application. I have two or three views set on 'Summary View' which are no longer viewing correctly. Results columns are out of order from where they should be. Please see this view for an example: https://creator.zoho.com/rachelogg/kiwioz/#View:Job_list_UK For example the result for the Job ID field should be MF1D (it is correct if you view in "List" view) however instead in summary view it says UK- London South. Please advise
Print PDF
Hi, I want to capture some details in Zoho Creator form and on submit, it should print 2 copies of data, 1 of the printer can be Google Printer. How is it possible? Any Ideas?
Subform and Mainform relationship when using creator remote api
I have a main form and subform with subtotals the subform. If I want the main form to be updated when saving a record to the subform, where do I attach the script? I realize 'On user input' when I'm using the web interface, but where do I place the script when I'm adding records through the API?
Adding the totals from two reports
Hello, Does anyone know if it's possible to add (and subtract) the grand totals from two reports? I have two reports, each showing totals of the figures for a list of stock items. Both reports show totals of the same items... one is stock in and one is stock out. What I'd like to do is deduct stock out from stock in to give me a running total in a new report or page. Any help on how I might set this up would be appreciated. Many thanks.
Fields don't update on edit
This is listed previously in the forum under "field don't update" with no solution. Major portions of my application are broken and this is causing huge delays. Very simply: Technology_text=input.field_of_technology.toString(); this works on initial entry, but does not work when re-entering a form in edit. The string goes to an invisible field and comprises the data we are collecting. Production is at a standstill, and all the work done in the last week will need to be reviewed. This is a MAJOR lapse
Need to pull data from multiple tables into an HTML Page
I have a database containing student data. Within this, I have an html page to display (and allow staff to print) data from 15 tables. These tables are linked via a FullName lookup field. There are multiple I have created an html page and now need to: 1) Insert the zoho creator field names into relevant sections 2) Create new rows where needed to display multiple records in sections (eg My Family Contacts, My Daily Requirements, etc). 3) Enable users to be able to filter the Student
creator auto backup?
Hi how can i turn creator app to regular auto-backup ? for example 1 time every week
Possible bug with drop-down field (picklist) created with UI:ADD when editing an db entry?
I created a form with a drop-down (picklist) generated from a call to a Zoho Invoice account. I run the form, add a few entries. (see image below the Client drop-down is generated using an Zoho invoice API call on Contacts and populated using the deluge UI:ADD() ). The bug is when I edit an entry, the drop-down value is not selected. The form show the drop-down and below an input box with the value. If I edit any field other than the drop down and want to save I will get an error message (Invalid
Wrong criteria search on system fields for today ?
hi just make new view for working app there is about 26 today entries but with criteria "Added_Time == today" system finds 12 entries and with criteria "Modified_Time == today" system finds 0 entries in all entries report for today (for example) are 26 entries how can i make criteria field to view current today's entries?
Option to prevent search engine indexing of public views
I make a lot of use of public views that clients access via a url we send them. The url has a filter parameter so that they only see there own data. Ideally, I would very much rather this data was not indexed by search engines. An option to do this would be fab.
Zoho Creator send Email with rows attached
I need to send an email to each user with all the rows in which they have been assigned. The idea is to send a mail per person every Wednesday with all rows belong. How can I do it?
Stateless form issues
This is almost copied out of the examples with changes reflecting my forms. I am trying to create a stateless form so that when cnumber is selected it will display name and account as well. But somehow the script yells at me whenever i try to save it and i get this error with a long list of what it was expecting...including that it was expecting "form" hmmmm. I tried form = Transfer and it didn't mind that but it didn't like { Encountered "form Transfer" at line 1, column 3. Was expecting one of:
Confirmation email with data from lookup fields
Currently when a confirmation email is sent any lookup fields show the record ID. Normally I would just add a send mail in the On Success section after fetching the record. However the Confirmation email can include a PDF attachment of a form Template/Record Summary. Is there a way to fetch a record in the Send Mail notification section or Is there a way to include a PDF of a Template/Record Summary.
Formula Field..
Asking for youre help. How can i do this? If date feild is Not null, it will not count the data and turn it to 0. please see picture
Is this possible customize view?
Hope you can answer me
Barcode Integration
Hi, I saw on the forum that Zoho Creator does not support barcode integration. If I had an excel file with barcode information and imported it into Zoho, is there a way to access a barcode number from a form (to be an ID for a product that I have information to fill in in the form)? I'd appreciate any direction on how to get barcode information into Zoho creator. Thanks!
Email Builder: Insert Expression Broken
Similar to https://help.zoho.com/portal/en/community/topic/html-builder-insert-expression-broken Now inserting an expression into the email builder fails. You only get what's shown in the picture and the "X" does nothing to close the window. You have to refresh the whole page to get out of this. Cheers, John Whitney
HTML Builder: Insert Expression Broken
Attempting to insert an expression in some HTML only gives this: ...in Chrome, Safari, and IE Cheers, John Whitney
Private URL Link and Application Portability
My client's application has a mixture of public and private sections. Some of the forms will be placed in iframes on hml pages shared using the private url option (share without a login). When I finally export this app and hand it over to my client, all the private url links will break. It would be nice to have a deluge function that takes care of this like: https://creator.zoho.com/<%=zoho.adminuser%>/<%=zoho.appname%>/form-perma/user_form/<%=zoho.privatekey%> Is this even possible? Cheers, John
Convert Zoho Creator App Into Smart Phone App
Can a Zoho Creator App be converted into a smartphone app?
OpenUrl vs insert into
As far as I can see, there are 2 ways to create a new record: 1) Use openUrl... and pass all the field values as "&fieldname=" + fieldvalue... The disadvantage is the string nature of the field names which don't get updated if a name is changed in the form. 2) Use insert into... and set all the field values and then open the form for editing using the openUrl 'record-edit' format. The advantage is that all field names will be updated if changed but I guess because the form name is a string, the form
Linking form with calender
I amnew to creator! Have created a booking form which I will embed in a website. The booking form has a date field and I need to link the date field to a calnder so each of my customers can see the bookings they have made on a day to day basis, without seeing bookings by other customers bookings. Can this be done and if so some help would be very much appreciated.
Paypal - cancel payment
Hi - I have a form linked to paypal and everything works if you go through with the paypal process. But if you submit the form, and at the paypal screen change your mind and cancel - I get a "Payment has been cancelled" in a little zoho status window, and then at the main creator.zoho.com page - it doesn't go back to my site. Any ideas how to handle cancelled payments? This is not a subscription - just cancelling a one-time payment before it's submitted. Thanks,
Search criteria in mobile app
I have a DB with approx 18,000 records of names and address's. When I view a report on the iphone mobile app and I put in a search criteria the results I get are just the first 50 records repeting over and over. For example .. I have a field called SN (street name). whan I bring up report on monile app I can scroll down and see many records. When I search on the field SN = Main St it returns the first 50 address's on main street and stops. when I scroll down it brings down another 50 address's
scheduling email for record with certain criteria
So if I had a bunch of records with say 3 fields Email address Message to send send email y or n so say there are 100 records I want to send the "message to send" to the "email address" once every 3 hours if the send email field says "y" Could someone explain the logic please
Application Context (Again)
So in testing out my clients application, everything is within the application context EXCEPT for the confirmation email for the newly created zoho account. In this email, you get a link that opens this page: I'd like to see the links for "HomeBlogsForumsFAQ" removed as it will confuse customers. Additionally, the zoho logo should be the admin's logo. Once you click that "Continue to Sign In", I'd expect as a customer to see the application. Instead you get this: This is not acceptable. I understand
Questions about limits ...
@ZOHO Creator Team: A couple of questions about limits. Over here ... https://creator.zoho.com/platform/home/settings ... it says that ... 1) Maximum number of executable statements per deluge action (e.g. on load or validate or on submit ) is 5000 When you compose an HTML View, do the commands constitute a deluge action ? 2) the number of times you can post data to another website per day is 500 Is there any limit on the number of API calls that can be made from external applications ? Gaev
eliminate sign-in on form on my website
I have attached a form on my website and I don't want to have parents sign in with email and password to get into the fill form data sheet. Can I also get an email sent to me when a form has been submitted? Sean
Field don't update
Hello, On load I write a command to fetch record with form: https://creator.zoho.com/appbuilder/misca/consulado-geral-do-brasil/form/CI_Confirma_o_Retirada_Passaporte/edit but the record in the field "Missao" don't update! Thanks Mike
Help for report , i got the message : we are unable to fetch this data sorry .....
Listing des personnes par évenements : We are unable to fetch this data, sorry! Please note that your data is SAFE.Reporet this problem to support@zohocreator.com
Will Payment form (Paypal) preserve lookup parameter?
I have a customerID being passed to a payment form. On submit, the page is redirected to Paypal; once payment is posted the Paypal page is supposed to return to Creator. Will that customerID be preserved upon the page-return, or will the lookup value be empty?
Next Page