How Do a I Create a New Record Using Deluge Script?
Say I have table Users and table Locations. Now, say I want to automatically create a location for a User when I save them for the first time. How would I do this using deluge? Thanks!
Invoice Payment Subform
Is it possible to use subforms to create a invoice payment form. I am trying to import invoice details to a form with information about the invoice (e.g. invoice #, invoice amount, invoice due date) and then create a form where the user can enter select an account and view the invoices that need to be paid. They would then enter the payment amount and select the invoices to be marked as paid. For example Account: XXXXXXX Date: 07/20/13 Amount: 100.00 Invoice # Invoice Due Date Invoice
How to handle web users in Zoho Creator and their passwords?
Hi, I just read that it's against Zoho policy to store passwords in Creator applications and this violation may result in account deactivation. Please advise how does Zoho propose to handle situation when a public application (embeded in public web) has to handle registered users. I need a web user to be able to come back and update his/her registration that I handle in Zoho. There will be thousands of registrations and thus also thousands of users out of which only fraction will actually come back
Hide input text using html code <input type="password" /> in the "Add notes" field type?
HELP!!! I need a simple, minimally secure username/password function to protect access to one of my view pages. So I am trying to hide the input text for a password in a form so that it looks like this: I cannot do it from within an HTML view because the limit on javascript in ZOHO creator prohibits me from submitting (as far as I can tell at least - please let me know if this is wrong because I'm an html noob). Thus I am trying to do it from within the form field "Add notes" which supports HTML.
How can I assing a default user to Zoho CRM Field user
Hi, When I add a new record in a BBDD, I need in event OnAdd -> OnLoad assign user default that it is adding the new record as a record owner. I created a user field (type Zoho CRM field user) but in my script I don't know how assign it. I try to write: input.user = zoho.loginuser; But how they are different types I can't to asign it. Can anyone help me?
end of week/month
hi guys, i hope you can help me to solve this problem. I have a form called "clients" where i set payment terms of them and apply it on every invoice. If i have scheduled payments with "n" days starting by invoice date, i haven't problem to obtain the "due date". The problem is when i set payments with "n" days starting by the end of the month or the week. Can someone help me? Thanks in advance bye
Comment lines changing location
Hi, It's not a major bug but I have noticed that when I add comments to code, they move around Eg When I try to save the following code if (input.ORDER_TYPE == "CHILD") { show SHOW_MILESTONES; } //Show child form hide SHOW_CHILD_FORM; It get's changed to the following when I refresh if (input.ORDER_TYPE == "CHILD") { show SHOW_MILESTONES; //Show child form } hide SHOW_CHILD_FORM; I'm finding my comments move away from where they should be. Can someone please investigate? Is anyone
Webhook to an existing Creator list
I have a list of customers in creator which was imported from CRM data. A decision has now been made to update our CRM subscription to allow webhooks, while it's straight forward on how to set the functionality up am I going to be left with duplication of customers once the webhook starts exporting i.e. when the data imports to creator will it recognize the existing customer name and update data rather than creating a new record?
Can I create a dropdown populated with user logins?
Hi Looking through the docs and searching I haven't been able to work out how to do this; I don't think it's been asked before. Is it possible to create a dropdown that is dynamically populated with the login names/emails of users who have access to the application? I'd like someone filling in a form to select from the list of users and the form to fire off an email to the user when the form is submitted with the details of the form (I'm sure I can do this using Deluge but I don't have access
Creator - new user
I have to say, after only a couple of days using the "Creator"... it is worth every cent!
I can´t update a rec
I am trying to update a rec with the following script recibo = Recibo_de_Caf[N_mero_de_Recibo_ == input.Recibo_de_Caf.toString()]; recibo.Estado_="Anulado"; But when I "run" the app it show me the following message: What is the problem, What am I doing wrong.
magento
hello, I want to add a drop down list on home page so that user has an option to choose magento theme. thanks.
Need help in REST API via browser
Hi everyone, I've been trying to add a record to my form thru the browser using the below link... https://creator.zoho.com/api/xml/junapp/MyForm/add/?authtoken=XXXXXe&scope=creatorapi&First_Name=Me&Last_Name=Myself and always getting the error message below, anyone else has this issue? An error has occurred. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused. cheers
Checkbox list giving duplicate entries when changing text
When I change the text of items on a checkbox list I get the following error message. I am using chrome. I clear the message and continue typing and the new text is saved properly. This is not a show stopper but is irritating.
Multiselect from lookup
Is there a way of populating a multi-select list using a lookup? We have several stock items that continuously change which are input/managed in a 'Service' form. I want to use a multi select list on another form 'Subs' that calls these items for selection. We need as we want to be able to select combinations of the current stock from the list. Either that or have a 'add new' lookup button that will great a new lookup line. Is there a way to do this or is this a limitation of creator?
Powered by broken image
I have a couple html forms embedded with iframes. The place that's supposed to have (I assume) the zoho icon is broken. It says "Powered by" and then a broken image link. The image URL is resolving to this: https://creator.zoho.com/appcreator/live/01/images/ which obviously won't work. I don't mind having the link there - but I'd like it to point to a valid image. As this seems to be a system thing, I don't think there's anything I can do to fix it. Thoughts?
Data refresh on a data list or grid
My apologies if there is an obvious answer . . . I am new to Zoho and would like to create a web app, but need to know the following before putting in the effort. Suppose I am displaying a data grid or data list from, for example, one table. When a user edits data which would reflect a change in that grid or form, how soon will the change appear on all web page displays of that data on other workstations? Is it more or less instant as with Google spreadsheets, for example? I tried a brief trial
Hiding subform formulas
I have a formula field LOGISTIC STATUS in my ASSET form. I have a form CONTRACTED ASSETS that contains the ASSET subform. I want to hide the formula fields from the subform in my CONTRACTED ASSETS form. Note, my requirement is that I want some forms to view the field and other forms to hide the formula. I do not want to turn it off for all forms. When I try the following code, I get an error. Note, I obtained the field name by viewing the form definition. How can I hide the subform formulas? hide
Field Null Validation not working
Hi All, Here is my code: varLeadTime = ((input.Coaching_Start_Date - input.Entry_Date) / (1000 * 60 * 60 * 24)); if ((varLeadTime < 7) && (input.Why_now_Compelling_event_and_timelines_ == null)) { alert "This is less than 1 week notice. Please complete the 'Additional Information' section (Why Now?) to help us prioritize."; cancel submit; } Basically, it is a calculation of how many days notice someone provides for a request. If it is less than 7 days, the user must complete
Isolating date part of date / time variable
I have a date / time variable declared in a form. I am using it's data entry from a calendar view such that both date and time info is input to the variable which is called 'sched_time'. I want to show a grid view of today's records from the form called 'Case' and have attempted to use the criteria as below in the view script. show all rows from Case [sched_time == zoho.currentdate] This does not work and no records are ever shown using this format. I have tried to use combinations of some
Using the API to access a Creator DB.
Hi. I and a coworker have spent quite a bit of time looking for info on this and haven't been able to find anything that works. Here's what we're trying to do. We signed up for the free ZOHO account. We created a DB using Creator. It consists of names and addresses. The only way we want to use ZOHO is as a front end for entering data into this DB, kinda like Access. We want to then use this DB to fuel other web pages. So, if I have an entry in this DB named "FirstName", I need an example of how
Adding Formula results in blank form page
I added this formula to my form: and it results in my form no longer loading:
"Data will be stored in Zoho Creator"?
When I caret new form in new Form Builder, last checkbox ask "Data will be stored in Zoho Creator". What it mean? Nothing happens if I uncheck or check this checkbox...
HTML page...can one view force a refresh of another view
Title speaks for itself. I have an HTML page with multiple views incorporated into it. If a record is changed in one view, can I force a refresh of another view?
Grand Summary Formula Column
Hello. I want to put a formula in a summary row, and have no formula elsewhere. Specifically I want something that does this. See how the Three-Day Average Column has 350 in the "My Movie" Summary line, and is determined by dividing 3-Day Gross / Screens. I've tried everything I can figure out to try. I won't bore you with what I have tried. What works? Title Venue Three-Day Average Screens 3-Day Gross My Movie Astor Theatre 1 567 Average Theatre 1 133 My Movie 350 2 700 Grand Summary: 2 700
warehouse development
Hi guys, nice to meet you. I'm finishing the development of a company application to manage our warehouse. To create a selected list for product, i've arranged following script: lisart = List:Int(); for each y in magazzinos [(((stock_colli > 0 && deposito == doc.deposito2) && data_scadenza_lotto >= zoho.currentdate) && (protocollo_magazzino is not null))] sort by articolo { if (!lisart.contains(y.articolo)) { lisart.add(y.articolo); } } The problem is that "magazzinos" table
I want to map all CRM Leads into an Array in Deluge
I want to map all CRM Leads into an Array in Deluge so that I can access each record (lead) in a FOR loop. Any suggestions? Looks like so far I can only get records by ID.
Creator App Duplication Failed
Hi Zoho Teams, We are a IT consultancy team and zoho creator paid users. We aim to promote zoho to our local SME as it's a wonderful tool. This is our app: https://creator.zoho.com/luyiheng/ucdemo It's a demo for our client. However, when we want to deploy this to our client, we could NOT DUPLICATE this app. After click "duplicate", nothing happens. Also, we could NOT EXPORT this app. Please Help! Thank you very much! Best, Yiheng
Access Request/Zoho Privacy Policy
When accessed using the URL http://creator.zoho.com/[USERNAME]/[APPNAME], the user is not presented with an warning. But then, we've converted the primary account to a domain account, added a sub-domain to point to ZC. So when I use the URL http://[MYSUBDOMAIN].[MYDOMAIN].COM/[USERNAME]/[APPNAME], the user is presented with a warning that reads like below: --- By clicking 'Grant Access', you give Zoho permission to enable [MYSUBDOMAIN].[MYDOMAIN].COM to access all your user data available with Zoho
Can I make a app in Zoho Creator for my database in Zoho Reports???
I want a quick way to make apps for my database that I have created in Zoho Reports. Would like to use Zoho Creator, but cant see anyway of doing it?
Add records by status in ZohoCreator Reports
Some example function that adds record status by the creator of Zoho Reports? I want to add up all the forms that are as "Approved". Thank you.
catch post rest api response
Hello, I am using rest api to add new records to my form from my external php/javascript application: https://www.zoho.com/creator/help/api/rest-api/rest-api-add-records.html The records are successfuly added, but the response is automatically downloaded to the client machine, the customer doesn't understand xml/json/csv formats, so this causes a problem. Second, I want to use that response (the ID) to add other records that have lookup to that first added record. Can anyone help me?? Thank you
Looking-up a record from another site or location
Hello, I need help on how to connect and retrieve a record from another file that is located externally, on some website or network drive, without having to load the entire file into a table in my application? Is it using API? examples would be very helpful. I read the guide with GetUrl, etc. and that was somewhat confusing. I would really appreciate some help on this. Thanks
A question about fetching sorted records
http://kbase.creator.zoho.com/records/fetch-records-within-a-range in the above document, this: rec = Contact [ID != 0] sort by Added_Time range from 1 to 5; so, my question is, if I do a for each r in rec { list.add (r.Name); }Will it add Names from the records to the list in sorted order of Added_Time?
Mobile linking in HTML view
Hi, I'm adding some dashboards to my application, from where the users are being linked to specific views and forms. This is quite simple, linking to #View:<view name>. The problem is with mobile viewers. Since Zoho Creator doesnt support Javascript (why is that anyway?!) I can't change it depending on user agent or whatsoever. How do I solve this? Thanks in advance for your help.
HTML in Variable
I am trying to create a variable for use in an email that contains HTML (for a dynamic link). The issues I am having is with the quote signs in the HTML. I cannot seem to get the variable to save with the quotes: agreementlink = ("Please sign your rental agreement by clicking the following link:<a href=\ "http://creator.zoho.com/carlgifford/vacation-rental/Rental_Agreement/record-edit/Rental_Agreement_View/" + input.RentalAgreementID + "\ ">Rental Agreement</a>"); Is there a way to do this? Thanks
Subform: Criteria rules not working correctly
Hi, Background: I have a PROJECT form that has a relationship with CUSTOMER & AGREEMENT. The AGREEMENT field has criteria where CUSTOMER_ID == input.CUSTOMER_ID. This works fine in the form. Eg When I select customer 123, I can see agreements 12 & 22. Problem: I have a PROJECT subform in my CUSTOMER form. When the user adds a new project, I expect the Agreement dropdown to show the relevant filtered agreements. However, I do not see any agreements. Eg When I view customer 123 & add a new project,
Urgent: task zoho.crm.searchRecords don't works
the taks zoho.crm.searchRecords don't works anymore in my app, i try to see crm response with this functions list test.test() { crmResp = zoho.crm.searchRecords(("Accounts"), "(CIF|=|XXXXXXX)"); return crmResp; } and show me this: [{4834=Invalid Ticket Id}]it was working 2 days ago
Sum of 3 fields depending on user login??
Would love for someone to help me out with this. I can't think of a solution and have spent SO many hours.... I am using a form, where up to 3 users can split a commission on a team. The main agent adds the file, then they add one or two agents to share commission. Then, 3 fields are calculated that shows the commission for agent 1, agent 2 and agent 3. Now, I want each agent to be able to see their commission in a view or report form. I would prefer it to show as one field only, that represents
Update for the whole application
fetch and record for update from one form to other form is fine. However, my application need to be very relative together. For example: Form A: a cost of something (I will call A) Form B: fetch A * with a user input num = B Form C: a cost of something (I will call C) Form D: fetch C * with a user input num = D Form E: fetch B + fetch D = E Fetch and Update record will work when I update value in update Form A --> auto update to the fetching A in form B. But can not update value B update Form C
Next Page