Run a Google Script from Zoho
Hi All, I have a script in Google Scripts that I'd like to run from Zoho. The script has a few parameters, including a file that I need to attach. Is it possible? Thank you Ravid
Concern
Hi, Every time i submit it will always pop up error like the picture below: 1 picture is the first error. 2 picture is "Successfully send remarks" and i attach my code;
Creating report containing email addresses so that I don't have to input email in every single form?
I have a Vacation Requests form. The basic process is this: Employee submits vacation request Submit button then determines who is sent a notification for 1st approval. (It could be a number of managers, depending on which department, etc the employee is in) 1st approval person approves/rejects. If they approve, it is then sent to the HR Manager for review. She/he is sent an email telling them to review this. HR Manager then decides if she will final approve this or if the President of the company
Not able to change a report to spreadsheet format
I have a report that I'm trying to convert into a spreadsheet format, so that fields can be edited from the report screen in one click. However, I'm not getting the view I'm expecting (see screenshots) – i.e. the report is still uneditable unless you click into an individual record screen. Any ideas why?
Lost Table Relationships
Hello. I have used the MS Access Migration Tool several times to upload/import my Access database to ZOHO.. All of the tables and data seem to be there but none of the relationships. Any idea on what I'm doing wrong?
Updating Application/Patch
I have two zoho creator application 1 is the original and 2 is the duplicate. 1. The original application will be used by others by sharing to them the permission to used. 2. The duplicate one is for me to change or to update the application. My question is: How do i update my original application from duplicate one without deleting the users,data and the user profile of the application? Thank you in advance, Jee Zoho creator User
Insert into returning lookup ID instead of value
I am creating records on a secondary form on submit and everything works great except the client field, since is a lookup field on the main form, it is inserting the ID into the secondary form record, can you please help me telling me how to convert the ID to value? [ Added_User = zoho.loginuser Cliente = Cliente (this is a lookup field) Codigo = Paquetes_sub.Codigo Telefono = Telefono Paquete = Paquetes_sub.Paquete Fecha_de_vencimiento = Paquetes_sub.Fecha_vencimiento Servicios_disponibles = 2 Saldo
Performing a Look-up within a Function
Hi - I'm having trouble fetching a string value in conjunction with a Function that uses a Form Object Argument. I have a Tasks Form that uses a look-up to Project_Name from another form....once a Task is Completed I would like to be able to press a custom action button to have it marked completed and logged in a separate Project_Notes form. The code below is working but it is giving me a numerical value for the Project_Name in the confirmation email. Normally I'd do a look-up but this doesn't
Format the Excel - Export Data
Hi Team I can export the data using url in excel format. for eg: http://creator.zoho.com/zchelp/employee-manager/xls/Employee_View My question is that Can I get the Excel file as the First row is in Bold .So that it will differentiate from the data.Also Can IAdd some header text in the file, ie, Employee Details Please Help me Thanks
How do I create multiple views in a Report?
I would like to create many visualization layouts without creating new reports. In Customer Portal, if a customer modifies a Report, Zoho suggests to create a View inside the current Report withour creating a new one. When I modify a Report as admin, this option does not appear, only suggesting me to create a new Report. Where is it hidden?user
Formatting Record Summary templates for Sendmail Inline
Hi, I'm finding it impossible to clean up my templates and to present right in emails. Anyone have any resources or answers to the following? Scaling to display accurately/consistently across devices. For example, logo cut off on phone, border right side not showing on desktop pc. Font size discrepancies. While editing, font size is consistent, but when in use, one line can be a lot larger than the next (See attachment 1_image.png) Line spacing - is there a way to change the spacing between lines?
iframe is blank
tried using an iframe but it does not seem to work, i tried using a simple url but it is also blank, anyone has any ideas? htmlpage Search() content <%{ %> <iframe name="frameSearch" src="http://www.google.com/" width="500" height="250"></iframe> <% }%>
Set report criteria via URL to view data in subform
Hi, Can you open a report to a specific record (and maybe other criteria) where that record ID and other criteria is passed in via the URL? I have a Master Form with a Subform. The Subform of course has a lookup back to the Main Form (let's call that MF_Link_ID). Let's say the Main Form has information about a contract and the Subform has some details about the contract, some of which require approval (a decision box in the Subform). I want have a report that has custom actions for a person to approve
Application Form Width - Wide Screens
Not sure what I am missing, but why do the Application Forms only utilize a small portion of the screen aligned to the left? Is there anyway to adjust the forms to take advantage of wider displays? Do I just need to develop HTML pages for each of my forms?
Deluge scripts run OK when subform is standalone, but not when embedded in a parent form
Hi all, I'm modifying the Order Management application. When a New Product is added, I have a SubForm to add Serial #s for unique SKUs. For the first row, the user can use the Barcode read function to get the first Serial #. After that, when each row is added, for the Item_ID_UPC_Barcode field, I have added a script (that I found here) that will increment the original Serial # by 1 and place that value in the new row's Item_ID_UPC_Barcode field, thus saving the user the work of having to scan or
We need to pick the fields automatically while we perform the click action
We need to store the (Gross Size, Size , Price) fields in purchased view from the stock form. And need to pick automatically those fields (Gross Size, Size , Price) to the Add sales view. Our problems are marked in Screen shots and uploaded with this request , so we need support
We need to pick the fields automatically while we perform the click action
We need to store the (Gross Size, Size , Price) fields in purchased view from the stock form. And need to pick automatically those fields (Gross Size, Size , Price) to the Add sales view. Our problems are marked in Screen shots and uploaded with this request , so we need support
Building an FAQ App in Creator
Hi, We want to build an app in zoho creator on FAQ. We will upload all our FAQs belonging to different categories(About 10 categories) using forms. Each category will have 100s of FAQs. A Report will be embedded in the FAQ page of our website. We want to use button field for categories. App will display a list of FAQs whenever a choice category button is selected. At a time only one question can be displayed. When another FAQ is selected previous one will be shut. Similar FAQ APP is readily available.
Delay between request
I need to call 2 request one after the other and Im getting the "Calls are limited to 1 per second, 60 per minute and 1000 per day." Is there a way to put a Sleep between them, or any other solution?
Different price based on field value
Hi, I have one service, gymnastics classes at various preschools, I'd like to sell via a form in Zoho Creator. I want to use the same form for all locations/class times but need price to change based on field "school name" parent selects for their child. For example, Parent registers child at school selected in drop down field "school nam" called ABC School. the price may be a recurring monthly cost of $49. Another parent may select school DEF school and the price there is a recurring monthly cost
Variable Field names for reporting product attributes
I would like to create a report of Products that for every Product includes fields like: Part number Description Product Type Manufacturer Data sheet link but also has a number (say 10) fields that contain attribute values (text or decimal) such as: Weight Power Type etc. BUT I need to be able to change the attribute field name depending on the Product Type i.e. some product types will require certain attributes but not others. Does anyone know how to achieve this?
Office 365 Single Sign On for Zoho Creator
Hi, We are using Zoho Creator to build apps to be used across our enterprise and are interested in using Office 365 Single Sign On for all our Active Directory users (about 2400) to access our Creator apps. Do you know when SSO will be supported in Zoho Creator? I see that the Office 365 SSO option is available on the accounts.zoho.com login page, but that provides a poor user experience for our end users. We need single click access and pass through to our zoho dashboard. Thanks Phil
Find and replace values of a rich text without activating the html format on it.
Hello, I need to create a function that removes the <xmp> </ xmp> from my rich text but without the html being activated. I want you to see exactly the same, since the code will be executed and I need it in this format, with these spaces, etc. I have intented with the function Replace all, but I do not think it is appropriate. Any ideas? Rich text = Mass_code Thanks!! { 'title':'Item Test No ofertar - Domino', 'category_id':'MLM126166', 'price':945.03, 'currency_id':'MXN', 'available_quantity':1,
Allowing a user from outside the organisation access a report and update a form using a custom action
I have create a report and also a custom action that allows a user to see a list of records in a report and then click a custom action which will open. dialogue window where they can enter data using a stateless form which then updates a record in the database once submitted. This works for an internal user however when I send a link to the items I want to share with a user external to the organisation. All that is visible is a form which is not what I want. If I send a published link or embedded
can Zoho creat test with select question A, B, C, D? Zoho Docs, Zoho creator or other ??
I want to creat Toiec test!
{"code":"4832","message":"Problem occured while processing the request"}
I am trying to send data from form created in Zoho Creator to Create a Ticket on Zoho Desk using this code: info input.Enter_your_Name; info input.Phone_Number; info input.Upload_Image; info input.Describe_your_Problem; response = zoho.support.create("Requests","prometheanspentatechnologiespvtltd","Promethean Spenta Technologies Pvt Ltd",{"Contact Name":input.Enter_your_Name,"Phone":input.Phone_Number,"Attachment":input.Upload_Image}); info response; Why is it Returning an error code 4832 to me?
Check previous forms from the same day
Hi For my form created in Zoho creator, i want to have a check. Only 1 time a day the form can be submitted for K&n K2, G1, .. So when someone tries to send the form again on the same day when K1 (or K2,..) is selected a message should be displyed. How can this be achieved as a script in delunge? Kind regards
How to build Api integration
Hi there, i've been using creator for our standalone app in the past year. Now I would like to build an integration with local (Dutch) accounting software. They do have an API available, and I'd like to have Creator create a new customer when we do that in our accounting software, and vice versa. I'm not an API expert so was looking online but couldn't really find how to do this. anyone that can point me in the right direction? eg online explanation etc. I remember this was part of the developer
Import existing customers with paypal
Hi, I need to import about 180 existing students into our database whose parent already pays monthly via PayPal recurring payments...what is the best workaround/way to: A) import these students with their associated parent contact (2 separate forms: 1 for students, 1 for parents then Set in creator to Lin) infoand B) import their payment information either automatically (hopefully) or manually if I absolutely had to do it that way?
Can I get Report Name?
I want a custom function, triggered from a Report, that passes the Report's deluge name as a parameter. Is that possible?
Stateless Forms - next previous buttons
Right so I have a multiple form app (using stateless forms) writing to a single table . What I can't work out is what the onclick command is for custom buttons to go to the next stateless form or previous ! Please help I know it's possible as done here https://creator.zoho.com/mobile/sampleapps/next-previous/#
can contact number in report take user to dialer screen like the mail ID takes user to mail screen in Zoho Creator MOBILE APP
In the Zoho Creator mobile app, when I click on the email ID in a report, it opens up my mail application with the clicked mail ID in the receiver place. Now can I have a similar facility for the Contact Number, like if I click on the contact number in the mobile app, it automatically opens up the mobile dialer screen with the number populated already? Sriram
Creator Scheduling is BROKEN
Hi there, So I am coming to the forums with this because our emails and calls with support don't seem to be making a difference anymore. We have at least 400 applications, months ago I created a script to export records via email and then delete old records. I then inserted this into every application and created a schedule to trigger it on the 1st of each month. This took ages to set up and embed into each application. After setting it all up I then found that not a single schedule even attempted
How to save field settings???
I feel like there's some secret button I'm supposed to click to get Creator to save form field settings. I'll set something in the field, like the name of the field. Then a little yellow box appears that says "Saving Changes...". Then, when I go back to the edit the form, none of the changes are there. Sometimes I've given up and just let a field be called "Single Line" because I can't get Creator to save anything. Here's an example. Here's a screen shot of Creator saying it's saving changes to a
Replicate database to external Postgres or MySQL?
Operating in an environment where a lot of enterprise data is already getting warehoused in a Postgres db and would like to replicate/sync creator tables/data there for reporting and backup purposes. Is this possible?
Need help creating a simple search interface
Hi, I've researched and I found some sample apps for search interface https://app.zohocreator.com/sampleapps/search-records-in-a-form/#Report:Search_records_in_a_form_View https://app.zohocreator.com/sampleapps/embed-search/#Form:Form_A But at old entries; they say you can copy that applications. On new interface, there is no option like that. How can I install or edit these sample apps for looking the codes?
Data Lookup Field Action
Greetings, I have created a form and need to populate a lookup field based on a previous selection. This is the example. I have a form that has client information. The client information form has 5 statements provided by the client. In the evaluation form, we select the client from a lookup field. The next field needs to look up the 5 statement from the client information form based on the client that was selected. I have used the following script with limited the success. My issue is while it
Error in Advanced App Building example tutorial
HI, I am trying below example from Zoho Creator site. I am getting errors. Total Amount is not showing accurately. Please find link for the example I am trying Also attached screen shot of the same Advanced App Building Please Help Thanks Anand
Validation Question
I have a form Expenses. I have two field I need to work with, (1) Reason for expense and (2) order#. I need to write a script that when you select a reason " Fees", that you MUST enter an order # before yo can submit. my script said; (Order is a number field) (Reason is a drop down select-Boolean) order_Temp =input.order; if reason = "Fee" { order_Temp=input.order>0; alert "an order must be inputted when "Fees are selected" } I keep getting errors any idea what I am doing incorrectly?
Field Alignment
Hi, I have a 2 column form that contains say 20 fields, 10 on each side. Fields in column 1 relate to the fields opposite in column 2. Field 1a Field 1b Field 2a Field 2b However, at the top of the form I need to insert an additional field called 'Selection' my problem then is this.... Selection Field 1a Field 1a Field 2a Field 2a Is there a way I can insert a hidden field at the top of column 2 to even up the fields? Ive noticed that while Zoho CRM has
Next Page